SQLite vs MySQL *

Question

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

Answer

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
• 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.

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/3630/" >SQLite vs MySQL< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.