Submitted by John DeSoi on Mon, 2012-05-07 22:55
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.
Submitted by John DeSoi on Thu, 2012-01-19 01:14
Submitted by John DeSoi on Fri, 2011-12-30 21:57
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.
Submitted by John DeSoi on Mon, 2011-12-19 17:48
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.
Submitted by John DeSoi on Thu, 2011-01-27 22:24
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.
Submitted by John DeSoi on Sun, 2008-11-09 18:32
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.
Submitted by John DeSoi on Mon, 2008-10-13 01:13
Submitted by John DeSoi on Sat, 2008-05-17 11:44
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.
Submitted by John DeSoi on Wed, 2007-04-18 23:18
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/
Submitted by John DeSoi on Sat, 2007-02-24 22:09
Pages
