pull down to refresh
👀
I wonder if you hate working with SQL as much as I do
Relative to the alternatives, I love it.
I wrote a relational database from scratch in college for one of my classes (its the only assignment we were given). I get them. They're like a crazy best friend - crazy on the outside, deeply sane on the inside, irreplaceable.
There's a half century of research invested into them. Normal data is so so so so underestimated. (At least in applications like this.)
Fair. I don't even really know what the alternatives are.
My background doesn't deal much with live data, so I'm mostly happy using pandas in python, but no one uses that for a production database.
I think my beef with SQL is that wherever I've seen it used, complex queries are often written out entirely in a single chunk of code. Not sure if the language doesn't lend itself well to modularity, but these chunky queries always seemed hard to decipher and thus error prone.
Man I was cooking the DB's CPU for the last 4 hours with an index typo in this release.
CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC NULLS LAST)is NOT equivalent toCREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC).The site was feeling so slow for a
second4-hour there.