Is SQLite good for website?

Question

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.

Why you should not 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.

Is SQLite good for ecommerce?

SQLite usually will work great as the database engine for low to medium traffic websites... If you have many client programs accessing a common database over a network...

Do people still use SQLite?

SQLite is used by literally millions of applications with literally billions and billions of deployments. SQLite is the most widely deployed database engine in the world today.

Is SQLite good for big projects?

SQLite is not particularly fast when getting into the millions of entries. Results will vary according to what you put in there, schema, number of columns, indexes. The advantage (especially in your case) of SQLite is that it is so light that trying it with some data would probably be worth the time and effort.

Expert · Answer