this post was submitted on 26 Sep 2025
38 points (88.0% liked)

technology

24104 readers
439 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

founded 5 years ago
MODERATORS
 

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