2 ms·
SQLite is such a beautiful program. It doesn't do much, but what it does do, it does very well. If I need to analyze some data, say in a logfile, I'll often wri
by gaius 16y ago
SQLite is such a beautiful program. It doesn't do much, but what it does do, it does very well. If I need to analyze some data, say in a logfile, I'll often write a trivial bit of Python to load it into SQLite and do my work in SQL. For a few 10s of Gs of data, this works brilliantly. I'd go so far as to say it's the least-buggy program I use day to day, and that includes the OSs I run it on and "real" commercial databases.
- mkramlich 16y agoYep I like to think of sqlite as being to relational databases as memcache is to caches. Both are super simple and straightforward, with a minimum of moving parts, and yet does something really well. You can start with each, and then later evolve into something more featureful. But often you'll not need to!