Hacker News Reader

Comment by thatguyagain | Hacker News Reader

Rails 8 made me love Rails again after a few years working with other tools. The new direction is just perfect, specially for solo developers. The 'solid trifecta' in combination with the simplicity of using sqlite3, the new built in auth solution, Kamal... everything, so f*ing good.

View on HN

> sqlite3

I know sqlite3 is great, but I've always found it much more annoying to use it on a server for small side projects than just using Postgres where I could just connect to the prod instance from my local machine and run some queries to look at the data. With sqlite I'd always have to sync files, set up volumes, make sure permissions are correct vs. just setting an environment variable to a PG instance.

From what I understand, the sqlite3 comment was made it context of the Solid libraries. Basically common Redis-backed functionality can now be sqlite3-backed instead.

I do share your preference on using Postgres as the main database. Having that as the main db with sqlite3 used for auxiliary functionality sounds great.

It's not much different than with Postgres:

    ssh your-server sqlite3 /tmp/path/to/your/db.sqlite3

Or if you're using Kamal, then the choice of database is completely transparent:

    kamal app exec -i --reuse bin/rails console

I've been out of rails for more than a decade, ended up mostly with Django, but I always kinda miss rails. But Django has treated me so well, just wish async and python in general had more legs on this side

We Use Rails uses SQLite, by the way

Reply on news.ycombinator.com