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

technology

24104 readers
373 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

I use drizzle and like it, actually. You still are constructing SQL queries, you still have to understand SQL, but you get some nice type safety from TS and more powerful auto complete than other query tools.

Also, how does writing SQL queries by hand lead to less frequent migrations?