In the past I had a website with hundreds of gigs of data that needed updating regularly, but could be read-only from the web server perspective.

I used sqlite for that, and had a mysql server for the user data and stuff that needed to be written to. Performance was fantastic, users were happy, data updates were instantaneous ; copy the new data to the server then repoint a symlink.

Most of my work is modeling and simulation. Sqlite is almost always my output format ; one case per database is really natural and convenient, both for analysis, and run management.

Anyway. Sqlite is amazing.