ActiveRecord / SQlite3 Compatibility Matrix

Photo (Cropped) by Raghavendra Badaskar on Unsplash

This matrix covers the versions of Rails / ActiveRecord against the versions of the sqlite3 RubyGem.

Other posts in my Compatibility Matrix Series

• RRRRb Matrix (Ruby, RubyGems, RuboCop, Rails, Bundler)

Notes:

• For all versions above, constraints are for: platforms :ruby, :mswin, :mswin64, :mingw, :x64_mingw or :windows.
• For the :jruby platform, use activerecord-jdbcsqlite3-adapter (not shown, yet; watch this space).
• These constraints are derived from the Gemfile line for the sqlite3 dependency at the specified tags. Since sqlite3 isn't a runtime dependency in the gemspec, this is the most effective way to determine the constraint.

References:

• Rails Gemfile at v5.2.0 (gem "sqlite3", "~> 1.3.6")
• Rails Gemfile at v6.0.0 (gem "sqlite3", "~> 1.4")
• Rails Gemfile at v6.1.0 (gem "sqlite3", "~> 1.4")
• Rails Gemfile at v7.0.0 (gem "sqlite3", "~> 1.4")
• Rails Gemfile at v7.1.0 (gem "sqlite3", "~> 1.6", ">= 1.6.6")
• Rails Gemfile at v7.2.0 (gem "sqlite3", ">= 1.6.6")
• Rails Gemfile at v8.0.0 (gem "sqlite3", ">= 2.1")
• Main branch Gemfile (gem "sqlite3", ">= 2.1")