Search⌘ K

Relational database management systems

Explore the key relational database management systems commonly used with PHP, including MySQL, PostgreSQL, and SQLite. Understand their differences, strengths, and how to interact with them effectively using PHP's PDO extension and database abstraction layers for maintainable and flexible data handling.

We can work with relational databases via relational database management systems (RDBMS), which are applications that provide all the functionality to store and manage databases. Here are the three most common ones.

MySQL

MySQL is PHP’s most common database management system. Their website claims it’s “the world’s most popular open-source database.” For our purposes, MySQL has wide support, many instructional ...