Securing SQLite databases with the authorizer

Many PHP developers prefer to use SQLite as their database engine rather than a separate database server such as PostgreSQL, MySQL, Oracle, or MongoDB. The reasons for using SQLite are many, but often come down to the following:

• SQLite is a file-based database: You don't have to install a separate database server.
• It's easy to distribute: The only requirement is that the target server needs to have the SQLite executable installed.
• SQLite is lightweight: Since there's no constantly running server, it takes fewer resources.

That said, the downside is that it's not very scalable. If you have a fairly substantial amount of data to deal with, it's probably better to install a more powerful database server. The other potentially major drawback is that SQLite has no security, covered in the next subsection.

Tip

For more information about SQLite, please have a look at their main web page: https...