In any web application you can use Sqlite3?

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?
June 10th 19 at 16:51
4 answers
June 10th 19 at 16:53
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.
that is, offhand, if I come up with 1 thousand-5 thousand per day, sqlite - pull? website-blog or well, something a little more complicated. - Arvid commented on June 10th 19 at 16:56
say so , if you have Nekeva architecture, optimal queries, sqlite on a VPS for $5 quietly pull 1 million+ requests per day. - glennie_Mer commented on June 10th 19 at 16:59
No need to count visitors during the day - doesn't matter
Matter how much comes in second - it may help to answer whether or not something is working

Should provide in order to smallit was not written session - marilyne_Roh commented on June 10th 19 at 17:02
divide those who come in the day for a number of seconds - get a second. - Arvid commented on June 10th 19 at 17:05
no , in reality it does not happen and all come in a short period of time - marilyne_Roh commented on June 10th 19 at 17:08
what a moronic habit of always something to challenge? here my accuracy is not needed. I said without thinking - Arvid commented on June 10th 19 at 17:11
, this habit to train Junior staff rules of good conduct
Also a rule of good behavior is considered to fully disclose information
to me accuracy is not needed
- marilyne_Roh commented on June 10th 19 at 17:14
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.
I understand that he postgresql server turning on the server consumes memory? a sqlite is not memory, because there is no server, just a file and Liba. - Arvid commented on June 10th 19 at 16:58
for any database is the client and the server. From MySQL, Postgresql server is always running as a daemon / service. And the client only when you're using the driver database.

From the Sqlite3 client and server are started and live the same time - while the script is executed, if we are talking about PHP.

Consequently Sqlite3 imposes on PHP script the costs of running the server + the client starts. For example PHP + Pg = 10mb ram | PHP + Sqlite3 = 10mb ram + the memory for the server itself, parsing queries, indexes, and so on + to all this CPU time - glennie_Mer commented on June 10th 19 at 17:01
Well and why then on a sample sqlite database faster than others? No there is no any servers. Just opens the file, and selection. It's just the storage of data in the file. It's not the SQL service. Just selection is familiar to the standard SQL language but in fact it is just a file. - marilyne_Roh commented on June 10th 19 at 17:04
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.
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.

Find more questions by tags SQLiteWeb Development