-
Rearchitecting: Redis to SQLite
The SQLite hype train continues. Love to be Excited About Benchmarks.
-
Always use an enum for your status field
Damn right.
-
The UX of UUIDs
Love anything about UUIDs and ULIDs. The base58 stuff here was a new one on me.
-
Tracking SQLite Database Changes in Git
Think I’m gonna use this for something.
-
Optimizing SQLite for servers
Will always bookmark a SQLite in production post. Learned something I didn’t love in this one!
-
DB Indexes Do Not Magically Compose
-
Oracle Database 12.2. It is close to 25 million lines of C code
Interesting old story about the Oracle source code.
-
SQLite & Rails in Production
One of the articles that helped me get 666a up and running using SQLite.
-
An Introduction to LiteStack for Ruby on Rails
Part of the SQLite in production hype train of summer 2023, this article helped motivate me to give the stack a serious try.
-
Enhancing your Rails app with SQLite
The blog post that inspired me and showed me how to use ULIDs with SQLite in a Rails app. I shipped ULID primary keys in 666a because of this post.
-
My SQLite in production epiphany
My work environment email alerts service – 666a – is a Rails app using SQLite for its production database. I’m super happy with this stack, but it wasn’t an obvious choice from the start, and I know a lot of folks still haven’t heard the growing hype about using SQLite in production in the Rails community. Here’s how I ended up shipping a production app with a SQLite database, and how it helped me rediscover some joy in full-stack work.