(Experimental Post - 1) : SQLite vs MySQL

SQLite is a single-file based database and MySQL is a normal database.SQLite is great for testing and prototyping, or for embedding in applications. MySQL is worthy of (large scale) production environments.

Here is my personal summary:

SQLite:

• easier to setup
• great for temporary (testing databases)
• great for rapid development
• great for embedding in an application
• 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
• can scale well if tuned properly
• can manage users, permissions, etc.  

In a nutshell...

•  MySQL is an open source relational database server designed to serve multiple users concurrently and uniquely allows pluggable storage engines for different workloads (OLTP, OLAP etc).
•  SQLite is a library for embedding a relational database within an application and aimed primarily at single user environments.
• SQL is a query language (used by virtually all relational databases).