On: You Shouldn't Use SQLite

[eternityforest]

Why can't you just put an index on the filename?

I've never worked with that much data myself, but a lot of people seem to be doing fine with 10+ GB sqlite databases.