SQLite 3.32 - Hackdot

Re:SQLite 3.32 by hobs on Saturday May 23, 2020 @09:22AM (#23282713)

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.)

[ Parent | on HN ]

Re:SQLite 3.32 by darksaints on Saturday May 23, 2020 @03:28PM (#23285663)

I 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.

[ Parent | on HN ]

Re:SQLite 3.32 by nolok on Saturday May 23, 2020 @10:46AM (#23283375)

SQLite handles dozens of DB databases surprisingly well, especially in a single user for data analysis scenario.

[ Parent | on HN ]