Thanks! My attitude is that you’ve got to handle SIGTERM and SIGINT properly in any case. There’s no excuse not to because it’s the only way to do fully graceful deployments. If your app gets SIGKILL’d you’re going to lose whatever transactions are in flight anyway. I probably should document it!
Yes. The trouble is, most people compare SQLite (an embedded db) with the likes of Postgres / MySQL and come with different set of expectations You can also document that the lib optimises for performance over durability. You do mention ‘sync’ but I would make the trade offs prominent
Yeah, good idea, I'll definitely put more effort into explaining the rationale behind all the decisions. And maybe I'll make it easy to optimize for different trade-offs with "profiles" or something, but will have to think about it more.