3 ms·
I can't even tell you how many times a dev came to me with some weird question that was very simply answered by "just use sqlite." I've never thrown more than
by hobs 6y ago
I can't even tell you how many times a dev came to me with some weird question that was very simply answered by "just use sqlite."
I've never thrown more than 20GB of data at it, but it always handles things admirably, and it often (to me) makes the right calls about the level of complexity required (accepts column type defs but really just doesnt care if it maps to string.)
- nolok 6y agoSQLite handles dozens of DB databases surprisingly well, especially in a single user for data analysis scenario.
- darksaints 6y agoI have done several multi-terabyte queries on it. One time I had a race with another dev to see who could get the right answer on a 3TB dataset. I was finished before his spark cluster had even spun up.