node-postgres

node-postgres will allow Node.js-driven applications to store and retrieve data from PostgreSQL applications.

The library contains a pure JavaScript driver for various PostgreSQL operations, and additional JS bindings for the libpg library, for supporting extra features that JavaScript alone can't cover.

The basic JavaScript driver is recommended though, since its much faster and covers all the basic database transactions.

The two connection systems (JS and via libpg) are inter-changeable and don't require any code modifications.

What is new in this release:

• Support for additional error fields in PostgreSQL >= 9.3 if available.

What is new in version 4.4.1:

• Support for additional error fields in PostgreSQL >= 9.3 if available.

What is new in version 4.3.0:

• Support for additional error fields in PostgreSQL >= 9.3 if available.

What is new in version 4.1.0:

• Allow type parser overrides on a per-client basis.

What is new in version 4.0.0:

• Make native bindings an optional install with npm install pg-native
• No longer surround query result callback with try/catch block.
• Remove built in COPY IN / COPY OUT support - better implementations provided by pg-copy-streams and pg-native

What is new in version 3.4.0:

• Include port as connection parameter to Unix sockets.
• Better support for odd date parsing.

What is new in version 3.2.0:

• Added support for parsing date arrays
• Exposed array parsers on pg.types
• Allow pool to be configured

What is new in version 3.1.0:

• Added support for parsing date arrays
• Expose array parsers on pg.types
• Added count of the number of times a client has been checked out from the pool
• Emit end from pg object when a pool is drained

What is new in version 2.11.0:

• Added support for application_name.

What is new in version 2.10.0:

• Add support for the password file.

What is new in version 2.7.0:

• Uses single row mode in native bindings when available.
• Automatically bind buffer type parameters as binary.

What is new in version 2.3.0:

• Remove built-in support for binary Int64 parsing.

What is new in version 2.2.0:

• Added support for excapeLiteral and escapeIdentifier in both JavaScript and the native bindings.

What is new in version 2.0.0:

• Properly handles various PostgreSQL to JavaScript type conversions to avoid data loss.

What is new in version 0.14.1:

• Fixed numeric array parsing.

What is new in version 0.13.1:

• Encodes JS arrays as Postgres arrays.

What is new in version 0.11.2:

• Fixed throw on copy.

What is new in version 0.8.3:

• Initial support for JavaScript SSL.

What is new in version 0.8.2:

• Date parsing support.

What is new in version 0.8.1:

• Native binding fixes.

What is new in version 0.7.1:

• Uses node-gyp.

What is new in version 0.7.0:

• Minor API change.
• Added metadata to native result callback.

Requirements:

• Node.js 0.4 or higher
• PostgreSQL 8 or higher
• generic-pool Node.js module 1.0.6 or higher