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

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.

• MySQL vs SQLite + UNIQUE Indexes

  For reasons that are irrelevant to this question I'll need to run several SQLite databases instead of the more common MySQL for some of my projects, I would like to know how SQLite compares to MySQL…

• Native XML database vs. SQLite/MySQL

  I am in a design phase for designing a media player for an embedded system. Most of such systems use SQLite/embedded MySQL for data management. How would you compare an XML database used for media p…

• mySQL vs. sqlite alias incompatible?

  I use Yii framework with mySQL with an ORM. When I switch to sqlite, I suddenly get 'column not found' errors for columns that have aliases in their query: Querying SQL: SELECT `privateAccesses`.…

• MySQL vs SQLite on Amazon EC2

  I have a Java program and PHP website I plan to run on my Amazon EC2 instance with an EBS volume. The program writes to and reads from a database. The website only reads from the same database. O…

• MySQL vs SQLite on Amazon EC2

  I have a Java program and PHP website I plan to run on my Amazon EC2 instance with an EBS volume. The program writes to and reads from a database. The website only reads from the same database. O…

• PHP+SQLite sqlite_exec and sqlite_query vs mysql_query

  I understand that sqlite_exec is for queries that does not return resultset and sqlite_query is for queries that return resultset. However can I use sqlite_query for all kinds of queries just lik…

• Using SQLite vs. MySQL with Ruby?

  I am new to Ruby and wondering if most people are using the SQLLite db that seems to be the most natural and recommended db to use with Ruby? Or are people using the traditional MySQL db? What ar…

• Selecting random in rails sqlite vs mysql

  Hey guys, I'm trying to select random data from the database in Ruby on Rails. Unfortunately, sqlite and mysql use different names for the "random" function. Mysql uses rand(), sqlite use random(). …

• mysql to sqlite conversion

  I've been trying to convert a mysql database to a sqlite db file but no luck. Is there any software that can do this?

• sync databases Mysql SQLite

  I am wondering what is the best approach to updating a database on an Application. We have a mysql database that handles everything on the main server, but I want to replicate this on my app. I w…