News for hackers. Stuff that matters.
Re:SQL is syntactic sugar for relational algebra by williamdclt on Saturday March 23, 2024 @10:02AM (#39800008)
Definitely disagree on this one. ORMs are a leaky abstraction, they hide the wall you’re going to bump into anyway, and they bring their own gotchas on top
Re:SQL is syntactic sugar for relational algebra by Scene_Cast2 on Saturday March 23, 2024 @12:02PM (#39800854)
I worked with two frameworks so far - SQLalchemy core and a much bigger "orchestration" one (dagster / airflow equivalent). SQLalchemy got me type checking, column name checking, and DB migrations versioning with Alembic.

The bigger framework got me more static analysis and dependency graphs on top of that. Those features saved me lots of time and headaches (type checking, dependency graphs, etc). Mind you, the frameworks I worked with still allowed for raw SQL for those edge cases that still pop up.