Features

API

• Aggregate Functions by @timabdulla in https://github.com/PostgREST/postgrest/pull/2925

• Media Type Handlers by @steve-chavez in https://github.com/PostgREST/postgrest/pull/2825, https://github.com/PostgREST/postgrest/pull/3076

  • New how-to for Providing HTML Content Using Htmx by @laurenceisla

• Strict/Lenient handling for Prefer header by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/2969

• Timezone for Prefer header by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/3024

• Config to specify CORS origins by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/2986

Authentication

• JWT Caching by @taimoorzaeem in #2928

Connection Pool

• Configuration for disabling Automatic Recovery by @taimoorzaeem in #2900.

Errors

• Add HTTP Headers with RAISE by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/2911

Observability

• Server-Timing response header by @taimoorzaeem, @develop7, @laurenceisla in #2937, #2983, #3064, #3068

• Log all internal database errors to stderr by @laurenceisla in https://github.com/PostgREST/postgrest/pull/3067

Transactions

• Function Settings by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/3056

• Settings with privileged context by @steve-chavez in https://github.com/PostgREST/postgrest/pull/3058

Fixes

API

• Remove unnecessary count on RPC returning single row by @steve-chavez in https://github.com/PostgREST/postgrest/pull/3015

• HTTP status responses for upserts by @taimoorzaeem in https://github.com/PostgREST/postgrest/pull/2926

  • PUT returns 201 instead of 200 when rows are inserted
  • POST with Prefer: resolution=merge-duplicates returns 200 instead of 201 when no rows are inserted

Observability

• Transaction-Scoped Settings are now shown clearly in the Postgres logs by @laurenceisla in https://github.com/PostgREST/postgrest/pull/3032

  • Shows set_config('pgrst.setting_name', $1) instead of setconfig($1, $2)
  • Does not apply to role settings and app.settings.*

• Display an actual TCP port app is bound to by @develop7 in https://github.com/PostgREST/postgrest/pull/3034

• Fix Acquision Timeout errors logging to stderr when log-level=crit by @laurenceisla in https://github.com/PostgREST/postgrest/pull/3067

Breaking changes

API

• Removed raw-media-types config by @steve-chavez in #2825
  • Can be done more granularly with Media Type Handlers now.
• Removed application/octet-stream, text/plain, text/xml builtin support for scalar results - @steve-chavez
  • Can be done with more flexibility with a Handler Function now.
• Removed default application/openapi+json media type for db-root-spec by @steve-chavez in #2825
  • Can be done by adding a media type for application/openapi+json and a Handler Function now.

Transactions

• Removed db-use-legacy-gucs by @laurenceisla in #3032
  • All PostgreSQL versions now use GUCs in JSON format for Headers, Cookies and JWT claims.

New Contributors

• @develop7 made their first contribution in https://github.com/PostgREST/postgrest/pull/2946
• @omahs made their first contribution in https://github.com/PostgREST/postgrest/pull/3044
• @timabdulla made their first contribution in https://github.com/PostgREST/postgrest/pull/2925

Full Changelog: https://github.com/PostgREST/postgrest/compare/v11.2.2...v12.0.0