TinyTDS
TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library. (by rails-sqlserver)
SQLite3
Ruby bindings for the SQLite3 embedded database (by sparklemotion)
Our great sponsors
| TinyTDS | SQLite3 | |
|---|---|---|
| - | 5 | |
| 604 | 737 | |
| -0.2% | 2.2% | |
| 6.9 | 9.4 | |
| 9 days ago | 6 days ago | |
| Ruby | Ruby | |
| GNU General Public License v3.0 or later | 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.
TinyTDS
Posts with mentions or reviews of TinyTDS.
We have used some of these posts to build our list of alternatives
and similar projects.
We haven't tracked posts mentioning TinyTDS yet.
Tracking mentions began in Dec 2020.
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 TinyTDS and SQLite3 you can also consider the following projects:
SQL Server - SQL Server Adapter For Rails
mysql2 - A modern, simple and very fast Mysql library for Ruby - binding to libmysql
redis-rb - A Ruby client library for Redis
Clickhouse - A Ruby database driver for Clickhouse
DataObjects
Cassandra Driver - [MAINTENANCE ONLY] DataStax Ruby Driver for Apache Cassandra
Redic - Lightweight Redis Client
moped - A MongoDB driver for Ruby