What is SQLite?
Who uses SQLite?
Here are some stack decisions, common use cases and reviews by companies and developers who chose SQLite in their tech stack.
I need to add a DBMS to my stack, but I don't know which. I'm tempted to learn SQLite since it would be useful to me with its focus on local access without concurrency. However, doing so feels like I would be defeating the purpose of trying to expand my skill set since it seems like most enterprise applications have the opposite requirements.
To be able to apply what I learn to more projects, what should I try to learn? MySQL? PostgreSQL? Something else? Is there a comfortable middle ground between high applicability and ease of use?
Should I use PostgreSQL or MySQL for a SQL database? I already use MongoDB and SQLite but SQLite doesn't meet my criteria. I know PostgreSQL and MySQL are very popular databases. Note: I am not looking for a job, this is just for a personal project!