PostgreSQL Plugin is a plugin for the 4th Dimension programming language that allows easy connectivity to a PostgreSQL database.

PostgreSQL is a popular open source database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access your database from a variety of applications written in a variety of programming languages.

The plugin provides features such as rowsets and prepared SQL statements. Rowsets are much like a selection of records in 4D, making it easy for you to browse through the result of a query. Prepared SQL statements make it easy for you to construct valid SQL statements without having to worry about the proper use of quotes.

Here is a short list of all the available features:

• Supports PostgreSQL up to version 8.x.
• Open multiple database connections simultaneously.
• Work with multiple row sets.
• Allows forward and backward navigation through row sets.
• Easy construction of SQL statements.
• Support for picture and blob fields.
• Support for stored procedures.
• Asynchronous notifications.
• Asynchronous queries.
• Notices send by the database server.
• SSL support
• Unicode and native image formats support with 4D v11.
• Includes example code to clone a 4D database to PostgreSQL.
• Available for Mac OS X and Windows.
• Universal Binary support on Mac.
• Works with 4D version 6.7 and higher on Windows or 4D 2003(*) and higher on Mac OS X (10.4 and up).
• Fully compatible with 4D v11 SQL.

* Please note that 4D Client 2003 on Mac OS X does not automatically download plugin bundles. To make the process of distributing such plugins easier, you can use the free BundleLoader plugin.

PostgreSQL Plugin has a very simple licensing scheme:

€ 300 per developer (unlimited deployment Mac & Windows)

Updates from version 1.x are available for € 200 per license.

Version 2.0 is now available!

Click on the following links to download a demo version of PostgreSQL Plugin.

PostgreSQL Plugin for Mac

PostgreSQL Plugin for Windows

Version 1.4 can be downloaded here

PostgreSQL Plugin version 1.4 for Mac

PostgreSQL Plugin version 1.4for Windows