PostgreSQL for WordPress (PG4WP)
PostgreSQL for WordPress is a special 'plugin' enabling WordPress to be used with a PostgreSQL database.
Download Version 1.2.2
1.2.2
- Corrected SQL_CALC_FOUND_ROWS handling, was broken by the latest code reorganisation
1.2.1
- Corrected 'ON DUPLICATE KEY ...' handling (was not working at all)
- Modified SQL_CALC_FOUND_ROWS handling for correct paging
- Some conversion handling for WPMU to install correctly (WPMU not working yet though)
- Improved installation/upgrade handling code (better detection of indexes, ADD COLUMN support, ...)
1.2.0
- Error logging is disabled in the distribution
- Added a handle for correct counting of users and roles
- Added MONTH and YEAR to the 'INTERVAL...' handling code
- Removed all ZdMultilang support hacks
1.2.0rc
- Disabled all ZdMultilang support hacks
- Fixed regressions that caused some WordPress features to not work properly
- Rewrote database connection handling so WordPress installation can tell you when you username and password are wrong
- Support for using an empty password for database connection
Note : this requires setting 'PG4WP_INSECURE' to true in
db.php for PG4WP to accept this
- Some code optimizations
1.2.0b1
- Somewhat improved WordPress plugins compatibility
- Added 'PG4WP_INSECURE' parameter for future use
- Split 'db.php' to be just some kind of loader for PG4WP to ease upgrading
- Improved Akismet compatibility
- Upgrading works with minor errors (PostgreSQL complains about already existing relations)
Tested successfully : 2.9.2 to 3.0.6 - 2.9.2 to 3.1.4 - 2.9.2 to 3.2.1
- Support for WordPress up to 3.2.1 (Installing WP 2.9.2, 3.0.6, 3.1.4 and 3.2.1 works smoothly)
- Implemented a generic "INTERVAL xx DAY|HOUR|MINUTE|SECOND" handler
- Backticks and capital text containing 'ID' now work
- Improved db.php to remove notices and possible fatal errors
- Improved dates functions handling
- PG4WP now appears in WordPress control panel and can be enabled/disabled but this has no real effect
- Added a correct plugin header into db.php to have correct informations shown in WordPress plugin Directory
1.1.0
- This release is identical to 1.1.0rc4, just has error logging deactivated in the distribution
1.1.0rc4
- Corrected a typo in permalinks handling
1.1.0rc3
- Reordered the date_funcs array (Thanks to Boris HUISGEN for reporting the problem and submitting a patch)
- Moved the hack about WP using meta_value = integer (instead of text) out of the SELECT handler
- Boris HUISGEN submitted a patch for permalinks to work properly
1.1.0rc
- Hack for WP using meta_value = integer (instead of text)
- Moved parts required only when installing/upgrading from driver_pgsql.php to a separate file
The file is loaded only when needed so that memory footprint should be a bit smaller
- Added UNIX_TIMESTAMP support
- Added DATE_SUB support for Akismet 2.2.7
- Added DAYOFMONTH support (Thanks to Pete Deffendol for noticing the problem)
- Upgrading from WP 2.8.6 to WP 2.9.1 works with a minor error
Upgrading should remove an index on table "wp_options" that may not exist, throwing an error
- Installing WP 2.9.1 works smoothly
- Generic hack to avoid duplicate index names
- REGEXP gets replaced with '~'
- Added a hack to handle "ON DUPLICATE KEY"
- Moved handling field names with CAPITALS near the end
- Added support for "INTERVAL 15 DAY" found in Akismet 2.2.7
1.0.2
- Updated support for plugin zdMultilang 1.2.5
- Got rid of some remaining hardcoded table prefix
- Added the possibility to log only errors
1.0.1
- Reorganisation of directory structure
- Updated installation procedure
- Changed the fake server version to 4.1.3
- Added support for Unix socket connections (just leave the "host" field empty when installing)
1.0.0
- Initial stable release.
- Code optimisation and reorganisation.
db.php automatically rewrites wp-db.php when loading it, so no maintenance is needed anymore
It also reduces the size of the archive :)
- Debug logs are now written in the
pg4wp directory
- Renamed the driver files
0.9.11
- MySQL's DESCRIBE emulation ( for WordPress upgrade process )
- MySQL's SHOW INDEX emulation ( for WordPress upgrade process )
- ALTER TABLE support ( for WordPress upgrade process )
- Added INDEX creation support when installing
- Cleaned type conversion Array
- Some code optimizations and cleanup
- One debug log file for each query type
- Tested successfully with WP 2.7.1 (Installs with no error + Upgrade to 2.8 OK with non blocking errors)
- Tested successfully with WP 2.6.5 (Installs with no error + Upgrade to 2.8 OK with non blocking errors)
- Tested successfully with WP 2.5.1 (Installs with no error + Upgrade to 2.8 OK)
0.9.10
- Ignore errors about non existing table "wp_options" while installing WordPress when debugging is on
- SQL_CALC_FOUND_ROWS emulation, to have correct posts paging
- Introduced support for the ZdMultiLang plugin
0.9.9
- Comments deletion now works again
- Most specific global variables renamed to have 'pg4wp' in their name
0.9.8
- Case insensitivity of MySQL 'LIKE' restored
- Importing WordPress eXtended RSS tested and seems to work
Requires: 2.5.1 or higher
Compatible up to: 3.2.1
Last Updated: 2011-9-11
Downloads: 5,557
Average Rating
(8 ratings)