New to WIP?

We're a group of makers shipping together. We help each other stay accountable and reach our goals.

Apply for access
TheBlue.social
1-click follow back Bluesky followers
@h_boon
Topics
πŸ“Š Analytics πŸ“ˆ Marketing
Other questions
Bought a domain and setup the server Be the first to reply
Created custom text-to-speech layer for switching between models Be the first to reply
Rewrote some convoluted spreadsheet math that was breaking Be the first to reply
First Real Data coming in hot in Production Be the first to reply
Back
 Milestone
Posted

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.

Hwee-Boon Yar
PRO
@h_boon

πŸ‘‹ 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.

 Reply

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.

 Reply