PostgreSQL

Is anyone running test on HEAD, until PostgreSQL testbeds are implemented we still need to ensure peoples are commiting broken code to HEAD that passes on MySQL. Can we get some kind of movement going to keep the testing up??

I'm not a MySQL fun, so some troubles with MySQL database (MyISAM data corruption and too slow InnoDB) force migration of three existing Drupal 6 sites from MySQL to PostgreSQL. Since Drupal 6.2 some PgSQL-related bugs (sample) in core modules has been fixed, so I have a try.

Drupal 6.5 and PostgreSQL 8.3 compatibility

Drupal Core Modules

I've installed clean Drupal 6.5 on top of PostgreSQL 8.3.3 (with UTF8 database encoding) and played with it a lot. There is no heavy troubles, only minor ones:

Fresh install this time with Drupal 5.7 and stabile release of phpBB3 forum.

First time i had problems with sequences.
This can be easy done like this:

connect with database:
~ $ psql drupal_db

To view sequence tables:
drupal_db=> \ds

And there i found sequence table that i looking for
drupal_db=> SELECT * FROM drupal_users_uid_seq;

First have to restart it
drupal_db=> ALTER SEQUENCE drupal_users_uid_seq RESTART WITH 1000;
and than fix minimal value

Abstract

Drupal 6.0 is revamped with Schema API, so what's next for Drupal 7.x? PDO for sure! With this powerful data-access abstraction layer, workload will much reduced for DB abstraction layer designers and developers, and finally benefit our contribute developers and end users.

By the way, together with the decision of Drupal 7.x + PDO, there is also some voice about moving PostgreSQL (and so other potential databases support, e.g. Oracle, DB2, MSSQL, etc) support away from core, but contribute; on the other hand, add official SQLite support into Drupal core, together with MySQL.

Is this really a good idea? Or even if it is possible? As an existing Drupal + PostgreSQL users, what will this affect your daily work? As a potential customer of Drupal + Oracle/DB2/MSSQL/etc, is this a good new for you, or just an evil? I would like to provide some brief idea for you within this article.

Monday 8th October 2007 - Announcing the New Zealand PostgreSQL Users' Group

NZ PostgreSQL Users' Group (NZPGUG) will bring together NZ's PostgreSQL users
to discuss the world's best database server.

PostgreSQL is a powerful, open source relational database system. It has more
than 15 years of active development and a proven architecture that has earned
it a strong reputation for reliability, data integrity, and correctness.

NZPGUG is open to professionals, students, and enthusiasts. Activities include

Now that we have four more weeks before D6 code freeze, maybe it is possible to add join relationships/foreign key support into Schema API 1 after all. Otherwise, it will be another year before this info is in core. Note that this info does not really have to be in core---it can be added by a contrib module hook_schema_alter. But a lot of people would be pretty psyched to have referential integrity for pgsql built in to D6.

Hi folks

i use trust mode for authentication within my DMZ. Drupal "outta da box" doesn't support this, and so i've got a patch for it here:
http://drupal.org/node/125105

Can postgresql folks stop by for a comment?

Hello,

I've may have some time available in the next few months to devote to upgrading Drupal's GIS abilities. One area where I'd like to concentrate is exposing PostGIS data and functionality. In a nutshell, PostGIS allows storing arbitrary geometries (points, lines, polygons, multipolygons and combinations of those types) in database columns.

Hi,

Could someone please look at http://drupal.org/node/29706 and see if it's pgsql compliant? How do the CONCAT, MD5 and SUBSTRING functions behave on PostgreSQL?

Thanks,
Johan Forngren

Hello,

I think this is a great group.

I'm not sure if it's within the charter, but I'd like to request some assistance in testing/reviewing the Pathauto module to make sure that it is Postgresql compliant. I'm a maintainer of Pathauto and would love to find a user of both Postgresql and Pathauto to make sure that it works (and that changes I make don't break the compliance!)

Anyone care to help? It's a pretty popular module so I imagine I'd hear about any problems, but it would be nice to know "for sure".

Thanks,
Greg