I've used SQLite in a project once, client-server application configuration management interface; I picked SQLite because the application I was replacing also u

I've used SQLite in a project once, client-server application configuration management interface; I picked SQLite because the application I was replacing also used it, and because it was standalone; the application was run on-premise, and one of the issues was that the version of PHP it ran on was horribly outdated (plus it was PHP, so it needed some setup work). My replacement was intended to be fully standalone, no external dependencies, and so also no requirement to have a database server running somewhere. I would've preferred something like postgres but embedding that and running it with redundancy is nontrivial compared to sqlite. Mind you I never did get as far as running sqlite redundantly (using e.g. rqlite), I quit after 2.5 years since the project was bigger than any project I've ever done, and those were fully staffed teams.