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 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.
For more information about SQLite, please have a look at their main web page: https...