Which web applications can use Sqlite3?

Question

SQLite

Which web applications can use Sqlite3? Where there is no simultaneous recording? For example, I have a website where I display information and very rarely there is any entry in the database. Does it make sense to use Sqlite3?

Answer 1

When you need another database, you will understand. In the meantime, you don’t have replications, highload, database-specific things like JSONB - use it safely.
Here, many scold sqlite for poor performance. But the performance problems of these comrades are most often in a curved architecture. The real problems are when you have thousands of RPS from clients, and not when your crooked models generate N + 1 requests, of which there are thousands. And all sorts of postgres save such comrades for a short time. And tuning too.
True, there is one unpleasant feature in sqlite associated with strings. sqlite is not case-insensitive.

Answer 2

In addition to carp, it can be used in user-oriented web applications. Let's say something like MindMar, or some online constructors, where the user registers and creates his own documents. Then you can create a file per user and the work will be very fast, you can download the file, you can give your own extension, and then open it with the custom version of the application.
The use of sqlite as files for programs is very common.

Answer 3

If something rarely changes, but you need it conveniently, then it’s quite for itself. It is also convenient to copy / transfer in operational terms.
Some kind of synchronization script with a web interface for configuration.
Any calculator with a web interface settings.