Ruby bindings for the SQLite3 embedded database (by sparklemotion)

SQLite3 Alternatives

Similar projects and alternatives to SQLite3

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better SQLite3 alternative or higher similarity.

SQLite3 reviews and mentions

Posts with mentions or reviews of SQLite3. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-07-09.
  • Working with SQLite in Ruby
    1 project | /r/rails | 11 Dec 2023
  • Extralite 2.0 has been released!
    3 projects | /r/ruby | 9 Jul 2023
    Extralite is a gem for working with SQLite databases. It is blazing fast (up to 11x the performance of the sqlite3 gem), and provides a rich API for accessing database data in a variety of formats.
  • Understanding Clean Architecture with small Ruby libraries
    6 projects | dev.to | 1 Nov 2022
    DB: sparklemotion/sqlite3-ruby: Ruby bindings for the SQLite3 embedded database
  • Sharing my exp so far with using SQLite in Production
    2 projects | /r/rails | 14 Oct 2022
    # This configure_connection is run when each new connection is created. # see https://github.com/rails/rails/blob/main/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb#L1112 def configure_connection super puts "Configuring DB connection with app-specific PRAGMA statements" conn = self.raw_connection # see https://github.com/sparklemotion/sqlite3-ruby/blob/master/lib/sqlite3/pragmas.rb conn.synchronous = 1 # normal # this is a permanent pragma but in case DB is brand new, no harm is invoking it conn.journal_mode = 'wal' # this is unnecssary b/c rails' sqlite3adapter turns it on by default conn.foreign_keys = true # this is not yet supported with convenience method #conn.analysis_limit = 400 # PRAGMA temp_store = 'memory' # hold temporary indices and tables in memory # conn.temp_store = 2 end
  • Resources for learning environment related things?/Help getting sqlite3 working with ruby on WSL ubuntu
    1 project | /r/learnprogramming | 1 Jul 2022
    That looks like you're missing the ruby module, not the OS package. If you're using bundler to manage your dependencies, add gem 'sqlite3', '~> 1.3', '>= 1.3.11' to your Gemfile. For reference, I got that line from this page: https://rubygems.org/gems/sqlite3/versions/1.3.11
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 26 May 2024
    Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →


Basic SQLite3 repo stats
5 days ago

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives