Can I use Sqlite3 for a site that performs more than 2,500 insert queries a day?

Question

Can Sqlite3 perform more than 2,500 insert queries a day.

Answer 1

That kind of speeds depends on how large your DB is and how much data you are inserting per query, as well as what hardware you are running. Regardless, we usually wonder if we can perform 2500 inserts per second, not per day.

https://www.sqlite.org/speed.html

Answer 2

Prince Chimaokwu Generally speaking, 2,500 inserts (and/or queries) per day is a tiny amount of work on any database and shouldn't be an issue with SQLite.

The decision on which database to use will not be impacted solely on the number of inserts per day. Without a more complete picture of the context and expected usage scenarios for this database, it's difficult to advise on whether or not you have other factors to consider.

Assuming the usage scenario is super basic, you should be fine.