Category Archives: Postgresql

Postgresql vs MySQL in the Enterprise

There are few people who have used both MySQL and Postgresql in production at scale. Both are great Open Source databases, so I thought I’d add some comments based on my experience. Feature MySQL/InnoDB Postgresql Replication Many options, simple to … Continue reading

Posted in MySQL, MySQL Cluster, Open Source, Postgresql, Tech | Leave a comment

Maintenance Banner mx_banner Available

While watching Superbowl 52, I finished my github project Maintenance Banner, aka mx_banner.php. It lets an application administrator schedule maintenance event notifications for a web application in a database, and the web application can then automatically display those on the … Continue reading

Posted in Linux, MySQL, Open Source, Postgresql, Tech | Leave a comment

Table Partitions in MySQL and Postgresql

We’re lucky to have two great Open Source databases, MySQL and Postgresql. One of the killer features in both MySQL and Postgresql is table partitions – for example, most Silicon Valley adtech companies are powered by MySQL partitions. They let … Continue reading

Posted in MySQL, MySQL Cluster, Open Source, Oracle, Postgresql, Tech | Leave a comment

Postgresql Concepts for MySQL Users

Postgres’ UPSERT functionality is an important improvement. Although most developers think of it as a syntax improvement, it’s much deeper than that: the developer can do new and different things in one statement duplicate key log messages can be easily … Continue reading

Posted in Open Source, Postgresql, Tech | Leave a comment

Part 2: Migration Notes from MySQL to Postgresql Using pgloader

This is a multi-part series starting with Part 1. After perfecting the schema and data migration with pgloader rules and getting the application sessions and login code working, it was time to convert the non-working SQL statements to Postgres syntax. … Continue reading

Posted in Open Source, Postgresql, Tech | Leave a comment