pull down to refresh
👀
I wonder if you hate working with SQL as much as I do
reply
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.)
reply
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.reply
reply
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.
reply
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)
.second4-hour there.