extralite
Ruby on SQLite (by digital-fabric)
SQLite3
Ruby bindings for the SQLite3 embedded database (by sparklemotion)
extralite | SQLite3 | |
---|---|---|
4 | 5 | |
245 | 745 | |
2.9% | 2.3% | |
9.3 | 9.4 | |
about 1 month ago | 15 days ago | |
C | Ruby | |
MIT License | BSD 3-clause "New" or "Revised" License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
extralite
Posts with mentions or reviews of extralite.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-07-09.
- Extralite: SQLite Ruby gem with concurrency, extensions, backup features
- Extralite: Ruby on SQLite
- Extralite: Fast and innovative SQLite wrapper for Ruby with a rich feature set
-
Extralite 2.0 has been released!
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.
SQLite3
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
-
Extralite 2.0 has been released!
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
DB: sparklemotion/sqlite3-ruby: Ruby bindings for the SQLite3 embedded database
-
Sharing my exp so far with using SQLite in Production
# 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
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
What are some alternatives?
When comparing extralite and SQLite3 you can also consider the following projects:
litestack
mysql2 - A modern, simple and very fast Mysql library for Ruby - binding to libmysql
usqlite - μSQLite library module for MicroPython
TinyTDS - TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.
sqlite-gui - Lightweight SQLite editor for Windows
SQL Server - SQL Server Adapter For Rails
esp32_arduino_sqlite3_lib - Sqlite3 Arduino library for ESP32
Clickhouse - A Ruby database driver for Clickhouse
react-native-quick-sqlite - Fast SQLite for react-native.
DataObjects
Redic - Lightweight Redis Client
moped - A MongoDB driver for Ruby