Drupal group for PostgreSQL

Drupal is a very nice content management system which supports PostgreSQL. You can find a Drupal/PostgeSQL discussion group at http://groups.drupal.org/postgresql.

pgEdit 1.3 released

pgedit.com is pleased to announce the release of pgEdit 1.3, a powerful tool for PostgreSQL database development and administration. Changes since the release of version 1.2 include:

  • New definition browser tool can be used to find and browse definitions in open files, recently used files, and file system directories.
  • New command to jump to the PHP documentation for the selected symbol.
  • Macintosh version now runs natively on both PPC and Intel processors (Universal Binary).
  • Compatibility with PostgreSQL 8.2 (includes psql 8.2).

pgEdit 1.3 operates in trial mode for 30 days without a registration key. There are no feature limitations or restrictions during the evaluation period. See the product information page for a complete list of pgEdit features.

pgEdit 1.3b1

pgEdit 1.3 is available for beta testing. This version includes a new definition browsing tool, PHP enhancements, and native Intel processor support for the Macintosh.

See the pgEdit beta page for complete details and download links.

More fun with definitions

The definition parsing features added in pgEdit 1.2 are great, but only useful for open files. And somehow the definition I'm looking for always seems to be hidden away in some file I have not opened in a while. So the next version of pgEdit will have a spiffy new definitions browser that can search for definitions in open files as well as file system directories (see screen shots below). You can also choose to search your list of recently opened files.

The browser consists of two views: one for specifying search options, the other for previewing files. Clicking on a definition in the result list switches to the editor view and highlights the definition. Full editing capabilities are available here, so this provides a convenient way to quickly change a number of related definitions. Double-clicking on the definition opens the file in the full editor window.

PostgreSQL function call model for PHP

This article describes a simple class that can be used to call PostgreSQL functions. Using the class has a number of advantages:

  1. PostgreSQL functions can be called like they are PHP method functions with no special syntax.
  2. The statements are automatically prepared giving faster execution for multiple calls.
  3. No string escaping is needed for prepared statements.
  4. The prepared statements are automatically deallocated when the object is destructed.

Resources:

pgEdit 1.2 released

pgedit.com is pleased to announce the release of pgEdit 1.2, a powerful tool for PostgreSQL database development and administration. Changes since the release of version 1.1 include:

  • New grid-based query browser tool. Result sets of any size are efficiently handled using automatic cursor management (no use of COUNT(*) or LIMIT/ORDER BY to manage paging).
  • Definition (e.g. function, table, trigger) parsing and searching commands.
    1. Find Definition - Finds the definition source by name (with completion) in any open file. Jumps directly to the definition without prompting if the highlighted text matches the name of a definition.
    2. List Buffer Definitions - List all of the definitions in the file with an icon corresponding to the definition type. Full keyboard control for type-ahead selection, jump to definition (Return), or cancel (Escape).
  • Added option to store preferences (e.g. last connection, syntax mode, character encoding, etc.) in comments within the source file.
  • Implemented multiple-level undo operations.
  • Compatibility with PostgreSQL 8.1 (includes psql 8.1). Added tab completion support for new 8.1 SQL commands.
  • Integrated PHP 5.1 which includes support for prepared statement processing and execution.

pgEdit 1.2 operates in trial mode for 30 days without a registration key. There are no feature limitations or restrictions during the evaluation period. See the product information page for a complete list of pgEdit features.

pgEdit 1.2b2

pgEdit 1.2b2 is now available. See the pgEdit beta page for complete details including screenshots and download links. The changes since b1 are mostly fixes and improvements related to multi-byte character support. The complete change list is included below.

pgEdit 1.2b1

pgEdit 1.2 is available for beta testing. This version includes a new query browsing tool, definition parsing and search features, and support for PostgreSQL 8.1 and PHP 5.1.

See the pgEdit beta page for complete details including screenshots and download links.

Name parsing with PL/Perl

I have been working on a database cleanup task which required normalizing names of people into first and last names. Unfortunately, this is legacy data from many different databases where a single field is used for the entire name. The names appear in every conceivable order and variation, with lots of extraneous words and characters thrown in for extra fun.

Certainly I was not the first person faced with this task, so I searched for existing tools rather than start from scratch. I found commercial software to do this "starting at" $10,000. I hunted around a bit more and came across this Perl module for parsing names.

I have never written a single line of Perl in my life, but I thought I would give it a try. I was able to get the module installed via CPAN on OS X without too much trouble.

Next, I wanted to get it running in PostgreSQL so I could call the name parser in the database. I recompiled PostgreSQL using the --with-perl option and then installed PL/Perl in my database using the CREATE LANGUAGE command. I created a PL/Perl function based on examples from the module and was pleasantly surprised when everything worked on the first try. Here is the function I ended up with:

Install Drupal with PostgreSQL

Drupal is an excellent PHP content management system. It supports both MySQL and PostgreSQL as the back end database for content management. Unfortunately, PostgreSQL comes up short in the documentation department: it is not even mentioned in the Drupal INSTALL.txt file. So here we do our small part for the cause and provide some instructions to get Drupal up and running with PostgreSQL.

Resources:

Pages

Subscribe to pgedit.com RSS