What role does PHP PDO and SQLite play in production projects?

Question

PHP

What role does PHP PDO and SQLite play in production projects?
Is this used besides mySQL?

Answer 1

according to PDO - all ORMs in popular frames work with it, but you don’t need to work directly, as a rule,
it’s another matter - if you work without a frame and from a database, then it’s best to work through it
SQLite - no, it’s practically not used
Considering your previous questions - I advise deal once and for all with the connection, this is not the most difficult moment

Answer 2

PDO is the main extension for working with various databases in PHP now. It is used in all modern projects, either directly or as the lowest layer of abstraction above the database. It's not worth using anything else.
SQLite is used where there is no high competition of queries, large amounts of data, etc. For example, when prototyping, or as a convenient local storage in desktop and mobile applications, instead of your own bicycle. For example, history was previously stored in Skype in this way while it was local.
Also, for some of your blogs, you can completely use SQLite, or for a small site. And it is possible for a large one, if the cache is higher, and there will not be many requests ...
Here, a big plus is that it does not require the launch of any database server.