Sloppily ported to PostgreSQL by Keenan Tims ([email protected]). Source codebase is the 6-Oct-2004 release of WordPress 1.2.1.
For those so inclined, donations are accepted via PayPal with the address [email protected]
WordPress version 1.2.1 PostgreSQL port version 1.0
Generally, following the WordPress documentation will be fine. Specifically:
The WordPress developers have opted to use some capitalized fields in function names and MySQL table definitions. PostgreSQL and PHP are case sensitive, however columns in PostgreSQL are automatically made lowercase. Thus, many templates and plugins may have problems due to the case discrepancies. This has (so far) been reported to break custom wp-comments.php implementations, but I suspect this problem manifests itself elsewhere as well. As the only way to solve this would be a change in WordPress, there's nothing I can do about it. If you run into this issue, just searching for 'ID' and 'IP' and replacing them with 'id' and 'ip' in the plugin or template should solve the problem. If it doesn't, feel free to contact me.
Certain old builds of PHP's PostgreSQL support module (including the ones packaged with some Mac OS X builds of PHP and PostgreSQL) don't include the pgaffectedrows() function which is called in ezSQL (wp-includes/wp-db.php). These builds generally do include the older pgcmdtuples() function which returns the same result. Replacing "pgaffectedrows" with "pgcmdtuples" should help people who are seeing an "undefined function: pgaffectedrows()" error.
I'm not aware of any other bugs in the current implementation (specific to WordPress-Pg; general WordPress bugs should be directed at the WordPress developers). If there are bugs, they are likely date-related, or portions of WordPress code that don't honour referential integrity. Such code is (generally) easy to fix. Bug reports are greatly appreciated, preferably with a repeatable scenario for recreating the bug on a fresh install.
Everything in WordPress base should work fine in this version. Plugins (including the included ones) are untested and may or may not work.
PostgreSQL 7.4.3
FreeBSD 4.10-stable
The database schema has remained virtually unchanged from the MySQL schema. Some rudimentary (and insufficient) referential integrity checking has been added, however, some MySQL-isms remain hacked in (enums are implemented with a simple constraint on a text field). This decision was made to ease the transition from MySQL and to make the job of porting simpler. In the future, WordPress-Pg may be upgraded to have full referential integrity checking and the removal of denormalized enums. Functionally, this shouldn't be an issue for most users. Beware that some scripts or plugins that manipulate the database directly may cause errors if they violate referential integrity.
Ports of future versions of WordPress will be done from scratch, rather than by merging changes. Hopefully the WordPress team rectifies the horrible mess that is the installation scripts so that the process isn't quite as onerous the next time around. The only changes made to WordPress code will be made to the DB access and related code. No bugfixes or patches will be applied save for those that fix bugs in the PostgreSQL port or improve referential integrity or normalization. These fixes should apply exclusively to embedded SQL code whenever possible.
It would be nice to have a properly abstracted version utilizing PostgreSQL's superiour featureset, such as views and stored procedures. This would greatly simplify the code embedded in WordPress. I'd also like to see WordPress use something more robust than ezSQL, like PEAR DB or ADODB. ezSQL is rudimentary and doesn't provide much abstraction (or even parameterized execution). On the way there, they should properly abstract the DB. Embedded SQL is a horror to port and difficult to maintain. It's also good place to start on OOizing WordPress. However, the amount of work required is huge, and many scripts would have to be rewritten from scratch. In the meantime, this version will suffice to offer an alternative to MySQL for those that need it. To the best of my knowledge, it is a fully-featured port.