-
Improving the enhanced SQLite3 adapter
Two months ago I released the
Continue reading …activerecord-enhancedsqlite3-adaptergem, which adds a number of enhancements to theSQLite3Adapterfor ActiveRecord. Today I am releasing version 0.3.0 of the gem, which adds an improved implemenation to handletimeouts. -
Linear writes don't scale
One of the biggest myths around running SQLite in production for web applications is that it simply won’t scale beyond “toy/hobby” numbers, primarily because SQLite requires linear writes (that is, it doesn’t support concurrent writes). This isn’t true. Let’s dig into why.
Continue reading … -
Table Schema and Metadata
How can we get all of the information about a particular table in a SQLite database? The information is spread across several different sources, in various structures, and not so easy to collect into a single report. This post will show you how to get all of the information you need.
Continue reading … -
Don't use autoincrement primary keys
The SQLite documentation recommends not using
Continue reading …AUTOINCREMENTfor primary keys. Is this good advice for web applications? Turns out, the usually solid SQLite docs are wrong on this one. Let’s dig into why. -
Concurrent writes can corrupt the database file
There are a number of myths that have made their way into the “common knowledge” of developers that need busting. Today, I want to explore the myth that attempting concurrent writes from concurrent threads/processes to a single SQLite database file can corrupt that file. This isn’t true. Let’s dig into why.
Continue reading … -
Rails 7.1 and enhanced SQLite3 adapter
Rails version 7.1 was released recently and it includes a number of enhancements to the SQLite ActiveRecord adapter. There are a few enhancements that didn’t quite make it into the 7.1 release though, so today I am releasing the
Continue reading …activerecord-enhancedsqlite3-adaptergem. -
September State of the Union
I wrote my first blog post about SQLite and Rails on September 6th. Today is September 27th; that is 3 weeks. A lot has happened in the last 3 weeks. Let’s recap.
Continue reading … -
More ActiveRecord adapter improvements
After opening my first few ActiveRecord PRs last week, I kept going and opened 4 more to bring more key improvements to the SQLite adapter.
Continue reading … -
ULID primary keys
When using SQLite as our Ruby on Rails database, you might wonder how to use something like UUIDs or ULIDs as primary keys.
Continue reading … -
Performance metrics
When using SQLite in your Ruby on Rails application, fine-tuning is essential. While SQLite is naturally fast, it’s default configuration isn’t tuned for web app usage. In this post, I want to explore some benchmarks and dig into why fine-tuning your SQLite database is so valuable.
Continue reading …