ActiveRecord / SQlite3 Compatibility Matrix

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

Other posts in my Compatibility Matrix Series

• How to Check License Compatibility in GHA (License Compatibility Matrix with Apache SkyWalking Eyes)
• RRRRb Matrix (Ruby, RubyGems, RuboCop, Rails, Bundler)

Rails / ActiveRecord	Min sqlite3 gem	Source Gemfile @ Tag
5.2.x	~> 1.3.6	v5.2.0
6.0.x	~> 1.4	v6.0.0
6.1.x	~> 1.4	v6.1.0
7.0.x	~> 1.4	v7.0.0
7.1.x	~> 1.6, >= 1.6.6	v7.1.0
7.2.x	>= 1.6.6	v7.2.0
8.0.x	>= 2.1	v8.0.0
main/edge (2025)	>= 2.1	main branch

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")

Support & Funding Info

I am a full-time FLOSS maintainer. If you find my work valuable I ask that you become a sponsor. Every dollar helps!

🥰 Support FLOSS work 🥰	Get access	"Sponsors" channel	on Galtzo FLOSS	Discord 👇️

Photo (Cropped) by Raghavendra Badaskar on Unsplash

Comments

[Alia Noza]

Noted, thank you!