I've been using SQLite in production for years and am very happy with it. I believe it's sufficient for the vast majority of web use cases.

I have a bit of battle-tested code that gives me a nice key-value interface to SQLite files, perhaps others will find it useful: https://github.com/aaviator42/StorX