PostgreSQL

日本PostgreSQLユーザ会（JPUG)が、11月20,21日に設立10周年記念のPostgreSQLカンファレンス2009Japanを開催します。

http://www.postgresql.jp/events/pgcon09j/j/

そこで、次のようなご協力を関連のある各コミュニティにお願いしてほしいとのことでした。

稲葉さん（実行委員長）より：

昨日の理事会でお願いいたしましたが、PostgreSQLに関係のありそうな各種OSS
コミュニティに、協力団体になっていただきたいと思います。

こちらからのお願い

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??

Position Title: Web Application Developer - PHP, CSS, JavaScript, Postgresql, Drupal, Linux, HTML, Apache

Location: Boston, MA (Financial District, Commuter Rail and T-accessible).

Status: Full Time, Regular

Responsibilities: The Sr. Web Application Developer will be responsible for developing and administering all Web marketing infrastructure for the WordStream.com Web site. Typical day-to-day responsibilities include:

• Writing Drupal Modules
• Writing & Customizing Drupal Themes
• Writing custom PHP & JavaScript Web applications
• Managing Web Server and IT Infrastructure

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:

• Richmond Location with Parking
• Fast-paced Culture (Agile)
• Performance driven team

A hugely successful and progressive organization based in Richmond is experiencing tremendous growth and investment resulting in the need to 'beef up' their web development team. The nature of the service of this organization means you will never be stuck 'just maintaining' but you will always be involved in new projects and development as web technology grows along with the success of the organization.

PHP/MySQL/Drupal Web Developers and Tech Lead

We've placed 5 developers on this fast-growing, high profile web development team. The site is a high traffic online website destination, and is soon to be the largest Drupal site in the world. You'll get to work in a casual, fun, and creative work environment. With about a hundred new projects on the horizons, there is a lot to do and no limit to your contributions as one of our valued employees!

To qualify, you must be responsible, self-directed, and enthusiastic about open source technologies.

Requirements:

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

Want to live and work in New Zealand?

We are expanding our drupal work, and are looking for more developers who love drupal.

Other Opportunities within catalyst to learn and work with other opensource technologies as well as drupal including php, perl, java, ruby, erlang, more...

send your CV to brenda@catalyst.net.nz. Please include links to modules you've contributed or patches/testing/benchmarking you've done on drupal.org, or another open source project.

http://catalyst.net.nz