4 ms·
> My dislike of ORMs mainly stems from the tendency to treat modern SQL engines as glorified dumb bit buckets. At scale, databases are OFTEN used as glorified
by throw_m239339 3y ago
> My dislike of ORMs mainly stems from the tendency to treat modern SQL engines as glorified dumb bit buckets.
At scale, databases are OFTEN used as glorified dumb bit buckets for performance purposes with heavy denormalization techniques.
- ttfkam 3y agoIf you have fewer than ten thousand simultaneous users, this is not you. After ten million, you're not using an ORM in front of a bare relational database either. Scale at high numbers adheres to no rules or off-the-shelf tools.
- Pxtl 3y agoI wish. I'm constantly having to reinvent materialized views on engines that don't have good support for the concept (ms SQL, sqlite) because my users want to sort/filter on a calculated column, meaning that I have to revert to "dumb bucket of bits" for records in seven figures and user-counts in the dozens. Relational algebra is good. I like the idea of nornalized data. I hope to be able to use it one day instead of SQL.
- ttfkam 3y agoSo… use one of the engines with better support for materialized views? This sentiment is like saying, "Java doesn't support traits, so I hate all programming languages." If an engine doesn't support a feature you need, use a different engine. If your workplace does not allow this, that's an issue you have with your workplace, not the tools.