3 ms·
I don't have any questions, just wanted to comment on this amazing work. It's been a while since I last played with SQL; at one time, it seemed like I was alwa
by cr0sh 8y ago
I don't have any questions, just wanted to comment on this amazing work.
It's been a while since I last played with SQL; at one time, it seemed like I was always doing something with SQL, mainly for MySQL - but everything now seems to be "locked" behind an API and all I do is interact with the API. Which isn't a bad thing, but it does mean my SQL skills are accumulating rust.
I do recall, though, enjoying the task of figuring out solutions to problems where the work could be done in SQL rather than in code. Sometimes, this resulted in SQL that, while valid, took some interesting twists similar to what you have shown.
I have probably made some later developers lives a bit of a hell, unfortunately. The closest I ever came to something like what I see here, was implementing GPS distance calculation code for a map lookup (basically, to allow for a search on "show me nearby locations" based on lat/lon coordinates from a zip code database).
I know what you're doing is all in good fun and seeing how hard you can push SQL into doing certain things; hopefully nobody will take this idea and run with it for something "production", if you know what I mean.
But I'm probably being too optimistic...