39
submitted 7 months ago* (last edited 7 months ago) by PorkrollPosadist@hexbear.net to c/technology@hexbear.net

SQL is good actually. Using your database system to define your data model along with all of its constraints is much better than just scribbling out some Rust/TypeScript/Go datatypes and shitting them out into a schema with a new database migration every fucking commit.

Your SQL application does not need to be portable. You don't need an over-engineered rube-goldberg solution where you can slot out OracleDB for SQLite for fucking CSV documents. Your code SHOULD be ANSI/ISO standard, but it just needs to run on PostgreSQL. PostgeSQL is portable.

Thanks for coming to my TED talk.

you are viewing a single comment's thread
view the rest of the comments
[-] trinicorn@hexbear.net 6 points 7 months ago

people will build horrible nightmares out of whatever tools you give them, unless they have a fair amount of experience/knowledge and put real effort into planning their data model and queries, which is always going to be a small minority of developers.

But personally I tend to have the same preference, I'd rather keep it simple and directly use the db tools as intended.

this post was submitted on 26 Sep 2025
39 points (88.2% liked)

technology

24351 readers
118 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

founded 5 years ago
MODERATORS