5 ms·
My ignorance of the topic (and experience with a mostly unrelated one) is showing, but all I could think of when you said CTE was "chronic traumatic encephalopa
by jimmygrapes 4y ago
My ignorance of the topic (and experience with a mostly unrelated one) is showing, but all I could think of when you said CTE was "chronic traumatic encephalopathy". This made a lot more sense when you generalized answering the question as if it's a given that Python is necessary (I know that's not your intent, but that's how it comes off).
Not much more to say, just observing, sorry if this is irrelevant commentary.
- jph00 4y agoCTE==Common Table Expression. It's not specific to any particular language. It's basically like a view, except you can define them the same place as you use them, and they can be recursive.
- jimmygrapes 4y agoThank you for the clarification, that actually makes sense in context! ... Although also now I'm a little. put off because you reminded me of working with DOS-based SAP interfaces and Oracle's Java-based attempts to make "interactive views" circa 2006 :/
- osigurdson 4y ago>> I could think of when you said CTE was "chronic traumatic encephalopathy" The title is "Ask HN: How do you test SQL"
- db48x 4y agoSometimes using databases feels just like repeatedly slamming your head into your desk, so that fits.
- collyw 4y agoI used to think that, but once you start thing about them in the right way, the relational model is pretty nice.
- db48x 4y agoAgreed, but it doesn’t solve every problem. And then there are the purely operational issues; for example a few days ago autovacuum was never able to completely finish vacuuming one particular table, but then the problem mysteriously went away and now it’s fine. Wonderful.