Just because I think SQLite works great for Joy of Rails doesn’t mean it’s right for you. You may be wondering: "Is SQLite a good fit for my next Rails app?" I’ve set out to help you answer that question here: joyofrails.com/articles/wha... #sqlite #rails - ThreadSky

rossta.net • 87 days ago

Just because I think SQLite works great for Joy of Rails doesn’t mean it’s right for you. You may be wondering:

"Is SQLite a good fit for my next Rails app?"

I’ve set out to help you answer that question here:

https://joyofrails.com/articles/what-you-need-to-know-about-sqlite

#sqlite #rails

Comments

allan.social•87 days ago

This is a really fabulous writeup, thank you!

rossta.net•87 days ago

Thank you!

danenania.bsky.social•87 days ago

Great post!

Seems like sqlite is perfect for projects that def won’t ever need to scale horizontally.

Otherwise, still seems simpler to me to use postgres/mysql even if it’s on a single node. Similar benefits and easy to scale if needed without distributed systems headaches.

rossta.net•87 days ago

Thanks. Horizontal scaling for SQLite does exist but you would be on the cutting edge.

danenania.bsky.social•87 days ago

Yep imho only makes sense to consider if you need ultra low latency and eventual consistency is ok.

For the typical app I think you just end up (badly) reimplementing postgres once you realize you need read-after-write consistency or transactions.

First rule of distributed systems is… 😀

intertwingly.net•87 days ago

I work for https://fly.io, and sqlite3 databases are placed on volumes *by default* for Rails applications. My application uses sqlite3 and scales horizontally - and I'm in the process of extracting that code into a toolkit: https://github.com/rubys/fly-atc?tab=readme-ov-file#fly-atc

rossta.net•87 days ago

Thanks for clarifying. I would be interested to hear how this is works, what limitations you might have, or any additional configuration if any you might need in Rails

intertwingly.net•87 days ago

Thruster is a reverse proxy and process manager. I just extended it to also reverse proxy remotely and manage multiple processes. See https://github.com/rubys/fly-atc/blob/main/docs/demo.md

flavorjon.es•86 days ago

Just a note that using sqlite extensions from Rails is about to get significantly easier.

Step 1 was https://github.com/sparklemotion/sqlite3-ruby/pull/586

So that already unlocks usage like:

development:
adapter: sqlite3
database: ...
extensions:
- <%= SQLean::UUID.to_path %>

flavorjon.es•86 days ago

Step 2 will be a Rails PR that I'm working on RIGHT NOW to enable this usage:

development:
adapter: sqlite3
database: ...
extensions:
- SQLean::UUID

rossta.net•85 days ago

Nice! Will this be compatible extensions managed with sqlpkg?

flavorjon.es•85 days ago

You bet! Though I think sqlpkg-ruby could use some helper modules to work with the Rails feature once it lands. /cc @fractaledmind.bsky.social

Here's the Rails PR!

https://github.com/rails/rails/pull/53827

fractaledmind.bsky.social•85 days ago

Yep! Just saw the PR and will work to make the gem fit more snuggly with this interface. Rails + SQLite just keeps getting better and better

Comments

Posting Rules

Reply