pg-connection-string

• Add support for the password file

• Add better support for unix domain socket connections

• Add support for parsing JSON[] and UUID[] result types

• Use single row mode in native bindings when available [@rpedela]
  • reduces memory consumption when handling row values in 'row' event
• Automatically bind buffer type parameters as binary [@eugeneware]

• Respect PGSSLMODE environment variable

• Ability to opt-in to int8 parsing via pg.defaults.parseInt8 = true

• Use eval in the result set parser to increase performance

• Remove built-in support for binary Int64 parsing. Due to the low usage & required compiled dependency this will be pushed into a 3rd party add-on

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

• Add support for SSL connections in JavaScript driver
• this means you can connect to heroku postgres from your local machine without the native bindings!
• Add field metadata to result object
• Add ability for rows to be returned as arrays instead of objects

• Properly handle various PostgreSQL to JavaScript type conversions to avoid data loss:

PostgreSQL | pg@v2.0 JavaScript | pg@v1.0 JavaScript
--------------------------------|----------------
float4     | number (float)     | string
float8     | number (float)     | string
int8       | string             | number (int)
numeric    | string             | number (float)
decimal    | string             | number (float)

For more information see https://github.com/brianc/node-postgres/pull/353 If you are unhappy with these changes you can always override the built in type parsing fairly easily.