In any web application you can use Sqlite3? Where there is no simultaneous recording? For example, I have a web site where I display old and very rarely is there any entry in database. It makes sense to use Sqlite3?
When you need another DB — you'll understand. And yet you have no replications, the hayload, the database-specific pieces like JSONB — rock boldly.
There is a sqlite blamed for poor performance. But performance problems these guys most often in the curve of the architecture. Real problems — when you have thousands of RPS from customers, not when your curves, the model generates N+1 queries, which thousands. And Postgres all sorts of such comrades save for a while. And tuning too.
However, there is one unpleasant feature in sqlite that is associated with strings. sqlite can not in a case-insensitive search.
Maybell_Okune answered on June 10th 19 at 16:55
In addition to sasanuma it can be used in web applications orientirovannyh of the user. Let's say something like Mingmar, or kakihto online designers where the user registers and creates Sovi documents. Then you can create a file on the user operation will be very fast, you can read the rest of the file, the extension can be given their own, and then attract it gastrolnoe version of the app.
Using sqlite as file for software very rasprostronenie.
Leora answered on June 10th 19 at 16:57
Just do it and look at the result. If you want, then fine, if not, it will transfer the data to another database. One will experience.
The answer is Yes or no, and even reasonable you will not get for one simple reason, it is not clear what is inside your website.
jared.Little answered on June 10th 19 at 16:59
If something rarely changes, and you need easy, quite a it. Even copy/move conveniently in the operational plan.
Any synchronization script with a web interface for configuration.
Any calculator with a web interface settings.