Why should I not use SQLite?

Question

When Not To Use SQLite High write volumes: SQLite allows only one write operation to take place at any given time, which significantly limits its throughput. If your application requires lots of write operations or multiple concurrent writers, SQLite may not be adequate for your needs. 21 февр. 2014 г.

Why SQLite is not used in production?

Long answer: It is said you can't use SQLite in production because it doesn't support concurrency (no more than one user can be writing to the database at the same time) and it can't scale.

Is SQLite reliable?

SQLite is a high-reliability storage solution. It does not give problems. It just works. The high-reliability of SQLite is proven in practice.

Is it OK to use SQLite in production?

SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite.

Should I use MySQL or SQLite?

MySQL has a well-constructed user management system which can handle multiple users and grant various levels of permission. SQLite is suitable for smaller databases. As the database grows the memory requirement also gets larger while using SQLite. Performance optimization is harder when using SQLite.

Expert · Answer