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.
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.
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
