News for hackers. Stuff that matters.
Re:SQLite 3.32 by nojito on Saturday May 23, 2020 @01:42PM (#23284850)
You should be using PowerPivot in Excel.

Here's a video showing rapid pivots of 100m row dataset

https://youtu.be/0WwFJ0Zg3d8?t=2285

Re:SQLite 3.32 by iagovar on Saturday May 23, 2020 @02:04PM (#23285007)
Mmm, I was using PowerQuery and then use the editor to do the transformations (don't remember exact names sorry), and I just couldn't cope with it.