Migrating From MySQL To PostgreSQL In PHP

Summary

This article described how to perform the most commonly used tasks from MySQL in PostgreSQL. This barely even touched on the advantages PostgreSQL gives you over MySQL, such as views, transactions, sub-selects, custom types and functions, sequences, triggers and a bunch more! Of course, MySQL gives you some of these using a third-party table type, but PostgreSQL gives you all of it right out of the box! Without the complicated dual-licensing of MySQL.

Other Options

• Download a PDF version of this article
• Put your PHP knowledge to the test with our online and iPad/iPhone quizzes
• View or post comments for this article
• Browse similar articles by tag: MySQL, PHP, PostgreSQL
• Read related articles:
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 2
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL Appendix
  • PHP A to ZCE: Databases and SQL
  • Managing Your Data With DatabaseObject