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

technology

24106 readers
278 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
[–] footfaults@lemmygrad.ml 5 points 2 months ago* (last edited 2 months ago)

Being able to use set theory and do the symmetric difference of two QuerySets without bogging down in the SQL subquery syntax and instead have the ORM do it is far more powerful.

If you don't think an ORM is good, you probably haven't written a complex enough SQL query by hand to realize what an ORM gives you