Skip to content

WP PostgreSQL Database

Drop-in replacement for the WordPress wpdb class that uses PostgreSQL instead of MySQL — makes full WP sites run on Postgres.

Overview

WordPress ships with MySQL/MariaDB as its only officially supported database. WP PostgreSQL Database is a wpdb drop-in that translates WordPress's MySQL-flavoured queries to PostgreSQL-compatible SQL at runtime.

Why It Matters

If you're already running a Postgres-heavy infrastructure (or want pgvector, better JSON support, or row-level security) this drop-in lets you run WordPress without introducing a separate MySQL server.

Current Status

Experimental but fully functional for core WP and most popular plugins. WooCommerce support is in progress.

Tech

PHP, WordPress wpdb, PDO, PostgreSQL SQL dialect translation.

Interested in working together?

I'm open to freelance engagements and consulting. Let's talk.