4 ms·
In a similar vein, here is my very similar rant and a teeny tiny sqlalchemy plugin that deals with the grossness a bit if you're using python. Not entirely sure
by makmanalp 3y ago
In a similar vein, here is my very similar rant and a teeny tiny sqlalchemy plugin that deals with the grossness a bit if you're using python. Not entirely sure if it still works, was floored to realize I'd written this a decade ago! But the sqlalchemy API tends to be quite stable.
https://github.com/makmanalp/sqlalchemy-crosstab-postgresql https://github.com/makmanalp/sqlalchemy-crosstab-postgresql
- tommasoamici 3y agoThanks for your work on that! I recently implemented a pivot table widget at work and it was mostly based on your code. It was a while ago, but I remember it worked with very few changes.
- makmanalp 3y agoOh wow, it's a tiny world! Glad to hear it worked out and you're more than welcome! :-)