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.

• Download a PDF version of this article
• View or post comments for this article
• Browse similar articles by tag: MySQL, PHP, PostgreSQL
• Read related articles:
  • Managing Your Data With DatabaseObject
  • 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