If you didn't see yesterday, I'm partnering with @aarondfrancis and @steve_tenuto to produce an in-depth video course on building with Rails + SQLite. "High Leverage Rails" is coming in February and I couldn't be more excited!
In an upcoming release, SQLite will have a new CLI utility providing built-in replication via rsync. While I still love Litestream, this opens up new possibilities for backup/replication strategies without an additional dependency
sqlite.org/draft/rsync.ht…
If you thought JSON columns in your PG tables were cool, just imagine the power of SQLite columns in your tables 🤯🤯
This new PG extension lets you stores the raw bytes of a SQLite db in a column then use the SQLite engine to work with it.
The Rails error reporting interface makes it possible to have a minimal error tracker built right into your application.
Introducing Solid Errors! It is a DB-based, app-internal exception tracker for Rails applications.
fractaledmind.github.io/2024/01/28/int…
It's official! SQLite v3.45.0 is here with JSONB support: sqlite.org/changes.html#v…
TL;DR — you don't need to change anything, SQLite will just work with JSON faster 🪶🚀
I feel a bit lost. I see so many people "dunking" on DHH's recent tweet by saying that many unicorn companies refactored infra to use less Rails. The implication seems to be that one ought not to use Rails at all, which seems ridiculous. Scale infra when you must, not before. 🤷🏻
Reminder that anyone can spin up a @Hetzner_Online Cloud server for a Rails app that could handle 48 Puma workers, each with at least 2GB of RAM! And all of that for less than €350 per month! Save yourself the headaches and don’t horizontally scale until you max out vertically.
I’ve been trying to tell y’all—SQLite is production-grade software, 100%. Configure it well, and it will sing for you. And the operational simplicity will warm your heart. Plus, for Rails devs, I can confidently say no web framework tunes SQLite better.
So we were testing out ONCE #1 on a big AWS instance and hitting 30,000 concurrent users on our metrics. Pretty cool to see that using sqlite! Can't wait to see what we can do with our new gen 5 SSD boxes. Sqlite can go very far these days.
🚀 High Leverage Rails is available now! Simplify your stack and scale from zero to IPO with Rails + SQLite. I made this video course in partnership with Try Hard Studios to teach you everything you need (and nothing you don't) to build then ship quality apps with less hassle.
Getting married tomorrow. In Jamaica. To the most beautiful and intelligent and patient woman I’ve ever met. With my family here with us. Feeling lucky tonight
Rails is reaching new heights as the One Person Framework, supercharged by the power and simplicity of SQLite. If you’ve ever been curious about why and how Rails 8 and SQLite work so magically together, my #RailsWorld talk is now up. Check it out!
About to present my vision for the best one person framework experience in web development. I truly believe that SQLite and Rails 8 offer the indie hacker, the bootstrapper, the builder the best possible developer experience. Exited to share more soon! #RailsWorld
SQLite needs fine-tuning, but with Rails 8, the Rails framework now does *all* of the configuration and usage tuning for you, invisibly. This is the culmination of over a year of effort from myself and the community at large, and I could not be more proud or excited!