-
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 … -
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 … -
ActiveRecord adapter improvements
Ruby on Rails continues to be a lively and thriving framework. Unfortunately, when it comes to the database adapters, a vast majority of the attention and effort has been focused on the MySQL and PosgreSQL adapters. SQLite supports a large percentage of the database features that Rails has added support for in the recent past. So, today I am starting to do my part to make the developer experience of using Rails with SQLite as seamless and powerful as possible. Maybe you’ll join me?
Continue reading … -
Local snapshots
Today we consider how SQLite can enhance working with our database in our Ruby on Rails applications. The the database is simply a file, snapshots and clones are both simple and powerful.
Continue reading … -
Array columns
One of the reasons people hesitate to use SQLite in their Ruby on Rails applications, in my opinion, is a fear that they will miss certain features they are accustomed to from PostgeSQL or MySQL. As discussed in an earlier post, we can load SQLite extensions into our Rails applications to enhance the functionality of SQLite. Moreover, today I want to show you that it is possible to build on top of SQLite’s primitives to provide matching behavior for one of my favorite features of Postgres—array columns.
Continue reading … -
Optimizing compilation
This is the next in a collection of posts on how to enhance SQLite in order to power up our Ruby on Rails applications. In this post, we dig into how to tune SQLite at compile-time to better support production usage in a web application. This is a close companion to a previous post on optimizing the run-time configuration of a SQLite database.
Continue reading …