What is the role of PHP PDO and SQLite in "fighting" projects?

What is the role of PHP PDO and SQLite in "fighting" projects?
Whether it is used in addition to mySQL?
June 8th 19 at 16:48
4 answers
June 8th 19 at 16:50
Solution
at the PDO — all ORM in the popular frames work with her, but not directly, you need to work normally
another thing — if you work without the frame and with the database, it is best to work through it

SQLite — no, almost never used

Given your previous questions — I advise you to deal once and for all with the connection, it's not the most difficult moment
Yeah, I already figured out. It was very easy, I don't know why so much time is left. Thank You again! - maxie.Mo commented on June 8th 19 at 16:53
SQLite it is currently used. - kavon.Murphy commented on June 8th 19 at 16:56
June 8th 19 at 16:52
Solution
There is no need with one hand. If you already have MySQL
On the other - why would there not storing for example configuration
June 8th 19 at 16:54
Solution
phpfaq.ru/pdo#intro

- the good old mysql extension. In the 5th version compels the notices that is out of date, and the 7th has been removed completely. Plus, real hysteria on the Internet about her (completely unfounded in this case. Banderlog never learned how to use it, but all their problems decided to dump on it).
- mysqli. This library is not intended to ispolzovaniya directly in the code. But only as a building material to create a library of higher level. Directly same to use it is impossible. Easier to survive a small nuclear war, than to try to bind several variables to the operator IN().
- PDO - stupid by process of elimination: anything more does not remain. Especially because it's such an under-the DAL, which makes a lot of what I have to do the library to work with SQL (but even more she does, what will be discussed below)
all the "joy" of developers about the PDO - from ignorance. PDO - terribly uncomfortable, unfinished crap. Just nothing else. Therefore we write in-house wrapper to simplify working with the database.
What kind of nonsense You wrote? And - kavon.Murphy commented on June 8th 19 at 17:06
, who are You? - Jaiden_Mil commented on June 8th 19 at 17:09
Dude, you're honestly please fix spamming his shit in EACH message with questions about the database. And it would be something really profitable, then Yes. And there are no tests, no coverage, no CI, nothing at all. Yes, and docks in Russian... - maxie.Mo commented on June 8th 19 at 16:57
Again with the fluff. - kavon.Murphy commented on June 8th 19 at 17:00
the arguments are? - Cecelia78 commented on June 8th 19 at 17:03
anxiety/the truth-teller you arguments was written more than once. but you're stubborn. - maxie.Mo commented on June 8th 19 at 17:12
June 8th 19 at 16:56
This is the main PDO extension to work with different databases in PHP now. It is used in all modern projects, either directly or as the lowest layer of abstraction over the database. To use something else is not necessary.

SQLite is used where there is high competition queries, large data volumes etc., for Example, for prototyping, or as a convenient local storage in the desktop and mobile apps, instead of his own bike. For example, before it kept the history in Skype while she was local.
Also, for some blagica can use SQLite quite, or for a small saytik. And it is possible for a large, if it is above the cache, and queries will not be a lot...
Here is the big plus is that you do not need run any database server.
SQLite is used where there is high competition queries, large volumes of data
That is shop for 1-5K goods will no longer be built? - maxie.Mo commented on June 8th 19 at 16:59
Technically possible, but not necessary: there's usually not good to cache, for example, due to check the availability and reserving or calculating discounts, and there will be many queries to the database.
Besides, if there's an attendance, and it turns out that the database was the bottleneck, and the remake then it may not be so simple. Even if it is SQL, but there are a lot of subtleties, and not always easy to change the DB engine. - kavon.Murphy commented on June 8th 19 at 17:02

Find more questions by tags PHP PDOSQLitePHP