3 ms·
My favorite reasons for pushing something down into the database include performance, security, concurrency, and portability. Yes, portability. My client langua
by spacemanmatt 6y ago
My favorite reasons for pushing something down into the database include performance, security, concurrency, and portability. Yes, portability. My client language is way more likely to change than my database.
- rini17 6y agoI don't mean that. I just like to construct any nontrivial query piecewise. SQL is about sets, when doing query you in fact make subsets and combine them using set operations. But the syntax makes this composition error prone and objection.js seems not to do much to improve it.
- spacemanmatt 6y agoYou've sorta captured my distaste for ORMs. I'm good at sets and relational algebra. Anything ORM interface that isn't RA is a leaky abstraction, and eventually I just have to go around it.