Ace editor updated for PostgreSQL 9.3

Ace is a standalone code editor written in JavaScript. The latest version includes support for all PostgreSQL 9.3 keywords and built in functions. JavaScript syntax coloring is now supported for pl/v8. Syntax coloring is also implemented for JSON strings (strings dollar quoted with $json$).

To try the live demo, select "pgSQL" from the Document menu.

PostgreSQL support in Ace editor

Ace is a standalone code editor written in JavaScript. It now supports PostgreSQL specific syntax coloring, including support for pl/pgsql, pl/perl, and pl/python.

To try the live demo, just select "pgSQL" from the Document menu.

pgEdit on GitHub

The source for the pgEdit TextMate bundle is now available on GitHub at

pgEdit 2.1 released

pgEdit has been updated to support PostgreSQL 9.1. The syntax highlighting grammar now supports all 9.1 keywords and the documentation tools recognize all SQL commands.

The variable PGEDIT_PSQL_PATH can be set in TextMate preferences to customize psql executable name and/or location.

See the Download page for the latest release of pgEdit.

Drupal 7 upgrade

Wow, 2 posts in one year. I'll try to be less chatty.

I finally upgraded this web site to Drupal 7. One big advantage of Drupal 7 over previous versions is a database abstraction layer based on PHP PDO. This means that all Drupal 7 modules should support PostgreSQL without any additional changes. In previous versions, PostgreSQL module support lagged far behind because developers often coded only for MySQL. Another advantage is Drupal 7 now supports more databases. PostgreSQL, SQLite, and MySQL are officially supported, and any database that supports PDO should theoretically work.

pgEdit 2.0 released

pgEdit has been recast as a bundle for TextMate, a highly customizable editor for the Macintosh. This allows pgEdit to take advantage of TextMate's advanced capabilities and focus solely on PostgreSQL related features. pgEdit supports PostgreSQL specific syntax coloring (e.g. dollar quoting), SQL execution, context specific help, completion, and recognition of SQL language constructs (tables, functions, triggers, etc.). pgEdit uses psql for executing SQL and takes advantage of many psql features.

pgEdit 2.0 is now free and released under the BSD open source license. If you find pgEdit useful, please make a donation to the PostgreSQL project.

See the Download page for the latest release of pgEdit.

pgEdit 1.4.1 released

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.

pgEdit 1.4 released

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.

PostgreSQL Lisp library

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


Subscribe to RSS