v0.3.0.0

Fixed

• Use reasonable amount of memory during bulk inserts - @begriffs

Added

• Ensure JWT expires - @calebmer
• Postgres connection string argument - @calebmer
• Encode JWT for procs that return type jwt_claims - @diogob
• Full text operators @>,<@ - @ruslantalpa
• Shaping of the response body (filter columns, embed relations) with &select parameter for POST/PATCH - @ruslantalpa
• Detect relationships between public views and private tables - @calebmer
• Prefer: plurality=singular for selecting single objects - @calebmer

Removed

• API versioning feature - @calebmer
• --db-x command line arguments - @calebmer
• Secure flag - @calebmer
• PUT request handling - @ruslantalpa

Changed

• Embed foreign keys with {} rather than () - @begriffs
• Remove version number from binary filename in release - @begriffs

v0.2.12.1

Fixed

• Correct order for -> and ->> in a json path - @ruslantalpa
• Return empty array instead of 500 when a set returning function returns an empty result set - @diogob

v0.2.12.0

Added

• Embed associations, e.g. /film?select=*,director(*) - @ruslantalpa
• Filter columns, e.g. ?select=col1,col2 - @ruslantalpa
• Does not execute the count total if header "Prefer: count=none" - @diogob

Fixed

• Tolerate a missing role in user creation - @calebmer
• Avoid unnecessary text re-encoding - @ruslantalpa

v0.2.11.1

Fixed

• Accepts */* in Accept header - @diogob

Note that the binaries in this release are all 64-bit. They will not work on a 32-bit machine.

v0.2.11.0

Added

• Negate any filter in a uniform way, e.g. ?col=not.eq=foo - @diogob
• Call stored procedures
• Filter NOT IN values, e.g. ?col=notin.1,2,3 - @rall
• CSV responses to GET requests with Accept: text/csv - @diogob
• Debian init scripts - @mkhon
• Allow filters by computed columns - @diogob

Fixed

• Reset user role on error
• Compatible with Stack
• Add materialized views to results in GET / - @diogob
• Indicate insertable=true for views that are insertable through triggers - @diogob
• Builds under GHC 7.10
• Allow the use of columns named "count" in relations queried - @diogob

v0.2.10.0

Added

• Full text search, eg /foo?text_vector=@@.bar
• Include auth id as well as db role to views (for row-level security)

v0.2.9.0

Added

• Return range headers in PATCH
• Return PATCHed resources if header "Prefer: return=representation"
• Allow nested objects and arrays in JSON post for jsonb columns
• JSON Web Tokens - Federico Rampazzo
• Expose PostgREST as a Haskell package

Fixed

• Return 404 if no records updated by PATCH