@exojason@justinvincent I have mixed feelings: on the one hand, I track my time on the site, and I enjoyed the leagues feature when I first started. On the other hand, MA feels like the antithesis of Duolingo & co., and I like that it feels serious and spartan; it doesn't feel gamified and I like that.
@NoahUnleashed@animoshing IIRC when I tried to import the CSVs directly, in my case, I actually got an OOM for some reason. So in my case it was worth it to normalize and use a script to transform the data first. As long as you can get it into CSV w/o OOM, I *suspect* it would be faster than iter. rows
I've been going through a SQLite course and working with census data, so I collated the massive, bespoke CSV datasets into an easy-to-use SQLite db. It was a week of work to get all the parts of the project going, but worth it :)
https://t.co/4JQ1hwuFoq
@NoahUnleashed@animoshing WRT CSVs, there's also the CSV virtual table extension, which allows loading CSVs as if they were tables. I'm not sure of the real advantage over the importing I showed before.
https://t.co/lraKA67tCS