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.