ProAnswers.org

SQLite vs MySQL

SQLite is a single-file based database and MySQL is a normal database. but I’m not sure which is faster where or better for what…what are the pros and cons of each option?

SQLite is great for testing and prototyping, or for embedding in applications. MySQL is worthy of (large scale) production environments.



This site has guidance on [when to use SQLite](http://www.sqlite.org/whentouse.html)



Here is my personal summary:



SQLite:




	easier to setup

	great for temporary (testing databases)

	great for rapid development

	great for embedding in an application

	not fit for production (in large scale)

	doesn't have user management

	doesn't have many performance features

	doesn't scale well.


MySQL:




	far more difficult/complex to set up

	better options for performance tuning

	fit for a production database

	can scale well if tuned properly

	can manage users, permissions, etc.