Back
Post
Switch theblue.social to be backed by database
Was 2 JSON files. Hard trouble scaling. Also an RDBMS allows me to build a few more features I'm toying with.
New to WIP?
We're a group of makers shipping together. We help each other stay accountable and reach our goals.
Join now
Topics
π Join WIP to participate
What RDBMS did you end up switching to? I would have opted for SQLite over anything else as it gives you that next step above JSON, but still remains filesystem based and less infrastructure to manage.
PostgreSQL. I briefly considered SQLite. It might not actually be less infrastructure for my setup since I run on Render. So it'd be their Postgres service vs sqlite+their disk mount service (+ figure out how to back up). Using their Postgres service means it's usually their problem to keep it up :)
Drizzle work is mostly the same whether it's Postgres or SQLite.
But I'd pay more of course.