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.

  • footfaults@lemmygrad.mlEnglish
    5·
    7 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