NEWS.md

All major and minor releases are briefly explained below.

For richer information consult the commit log on github with referenced pull requests.

We do not include break-fix version release in this file.

v2.8.0

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

v2.7.0

• 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]

v2.6.0

• Respect PGSSLMODE environment variable

v2.5.0

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

v2.4.0

• Use eval in the result set parser to increase performance

v2.3.0

• 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

v2.2.0

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

v2.1.0

• 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

v2.0.0

• 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 brianc#353 If you are unhappy with these changes you can always override the built in type parsing fairly easily.

v1.3.0

• Make client_encoding configurable and optional

v1.2.0

• return field metadata on result object: access via result.fields[i].name/dataTypeID

v1.1.0

• built in support for JSON data type for PostgreSQL Server @ v9.2.0 or greater

v1.0.0

• remove deprecated functionality
  • Callback function passed to pg.connect now requires 3 arguments
  • Client#pauseDrain() / Client#resumeDrain removed
  • numeric, decimal, and float data types no longer parsed into float before being returned. Will be returned from query results as String

v0.15.0

• client now emits end when disconnected from back-end server
• if client is disconnected in the middle of a query, query receives an error

v0.14.0

• add deprecation warnings in prep for v1.0
• fix read/write failures in native module under node v0.9.x