Re:SQL is syntactic sugar for relational algebra
by Scene_Cast2 on Saturday March 23, 2024 @09:34AM
(#39799820)
My take is that SQL is a bit like C - very nice to know, but move off of it to a more "managed" environment for safety and sanity.
[ Parent
| on HN ]
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.