pgEdit 1.4.1 is now available. This version fixes problems with finding and listing definitions in open SQL and PHP files.

See the Download page for the latest release of pgEdit for Macintosh and Windows.

A nice article on migrating Drupal from MySQL to PostgreSQL.

pgEdit 1.4 is now available. Changes since version 1.3 include:

• Various interface improvements. The connection window now supports sorting.
• Compatibility with Mac OS X 10.5 Leopard.
• Compatibility with PostgreSQL 8.3 (includes psql 8.3).

See the Download page for the latest release of pgEdit for Macintosh and Windows.

Postmodern is a Common Lisp library for interacting with PostgreSQL. It uses the frontend/backend protocol to communicate directly with PostgreSQL over a TCP/IP socket. Features include:

• Efficient communication with the database server without need for foreign libraries.
• Support for UTF-8 on Unicode-aware Lisp implementations.
• A lispy syntax for expressing SQL queries.
• Convenient support for prepared statements and stored procedures.
• Defclass-like definition of tables and associated accessor classes.

For more details and downloads see http://common-lisp.net/project/postmodern/

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

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.

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.

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.