Posts with tag `rails`

← All blog posts

December 13, 2023 · Stephen Margheim · code, ruby, rails, sqlite · Enhancing your Rails app with SQLite

Prefixed ULID keys

I have written previously about using custom primary keys for your Rails app when using SQLite. In this post, I want to show how you can use the same sqlite-ulid extension to create prefixed ULIDs. Shout-out to Andy Stewart who suggested this.
Continue reading …
December 12, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite on Rails

Introducing litestream-ruby

I have already detailed why Litestream is essential for SQLite on Rails applications. But, as that original post makes clear, getting this utility setup and working in production requires some systems administration. Rails applications deserve better. Thus, litestream-ruby.
Continue reading …
December 11, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite on Rails

Improving concurrency

Two months ago I released the activerecord-enhancedsqlite3-adapter gem, which adds a number of enhancements to the SQLite3Adapter for ActiveRecord. Today I am releasing version 0.4.0 of the gem, which allows your Rails application to work in Puma’s clustered mode with multiple workers without getting those dreaded database deadlock errors.
Continue reading …
December 06, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite on Rails

Improving the enhanced SQLite3 adapter

Two months ago I released the activerecord-enhancedsqlite3-adapter gem, which adds a number of enhancements to the SQLite3Adapter for ActiveRecord. Today I am releasing version 0.3.0 of the gem, which adds an improved implemenation to handle timeouts.
Continue reading …
December 05, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite Myths

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 …
November 13, 2023 · Stephen Margheim · code, sqlite, ruby, rails · Enhancing your Rails app with SQLite

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 …
October 09, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite on Rails

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 activerecord-enhancedsqlite3-adapter gem.
Continue reading …
September 27, 2023 · Stephen Margheim · code, ruby, rails, sqlite · SQLite on Rails

September State of the Union

I wrote my first blog post about SQLite and Rails on September 6^th. Today is September 27^th; that is 3 weeks. A lot has happened in the last 3 weeks. Let’s recap.
Continue reading …
September 26, 2023 · Stephen Margheim · code, ruby, rails, sqlite · Enhancing your Rails app with SQLite

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 …
September 22, 2023 · Stephen Margheim · code, ruby, rails, sqlite · Enhancing your Rails app with SQLite

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 …

Posts with tag rails

Posts with tag `rails`