PostgreSQL motorcycle in Austin, Texas

I came across this motorcycle leaving the movies on Friday. Very cool!

pgEdit 2.2 released

pgEdit has been updated to work with TextMate 2. The syntax highlighting grammar now supports all PostgreSQL 9.3 keywords and SQL commands.

This update also includes other minor fixes and improvements related to syntax highlighting, completion, and dropping SQL objects.

See the Download page for the latest release of pgEdit.

The source code for the pgEdit TextMate bundle is available on GitHub at https://github.com/desoi/pgedit-textmate.

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 https://github.com/desoi/pgedit-textmate.

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.

Pages

Subscribe to pgedit.com RSS