I have been working on developing a website using PHP and I'm now at the stage of configuring the database. I'm currently trying to decide between MySQL and PostgreSQL as the database for my project. However, before I make my choice, I want to make sure that PHP is compatible with both databases.
Can anyone shed some light on the compatibility issues that might arise when installing PHP with specific versions of databases like MySQL or PostgreSQL? Are there any specific versions of PHP, MySQL, or PostgreSQL that work well together and others that should be avoided?
I appreciate any insights or experiences you can share. Thank you in advance!