SQLite is the MSAccess of this generation. MSAccess was an absolutely wonderful database when you were hosting multiple small sites on a server and wanted quick deployment, easy setup and segregation. It connected easily with ODBC to a website and was robust and feature rich enough for hobby projects. They was no way I would want to bet the farm on it for a enterprise project.
That's demonstrably not true, and not a useful comparison.
A growing number of real-world production apps are running on SQLite these days, precisely because it's so mature, robust and performant at this point - and, unlike Microsoft Access, is very actively maintained.
