v7.0.1

Fixed

• #1473, Fix overloaded computed columns on RPC - @wolfgangwalther
• #1471, Fix POST, PATCH, DELETE with ?select= and return=minimal and PATCH with empty body - @wolfgangwalther
• #1500, Fix missing openapi-server-proxy-uri config option - @steve-chavez
• #1508, Fix Content-Profile not working for POST RPC - @steve-chavez
• #1452, Fix PUT restriction for all columns - @steve-chavez

Changed

• From this version onwards, the release page will include a single Linux static executable that can be run on any Linux distribution.

v7.0.0

Added

• #1417, Accept: application/vnd.pgrst.object+json behavior is now enforced for POST/PATCH/DELETE regardless of Prefer: return=representation/minimal - @dwagin
• #1415, Add support for user defined socket permission via server-unix-socket-mode config option - @Dansvidania
• #1383, Add support for HEAD request - @steve-chavez
• #1378, Add support for Prefer: count=planned and Prefer: count=estimated on GET /table - @steve-chavez, @LorenzHenk
• #1327, Add support for optional query parameter on_conflict to upsert with specified keys for POST - @ykst
• #1430, Allow specifying the foreign key constraint name(/source?select=fk_constraint(*)) to disambiguate an embedding - @steve-chavez
• #1168, Allow access to the Authorization header through the request.header.authorization GUC - @steve-chavez
• #1435, Add request.method and request.path GUCs - @steve-chavez
• #1088, Allow adding headers to GET/POST/PATCH/PUT/DELETE responses through the response.headers GUC - @steve-chavez
• #1427, Allow overriding provided headers(Location, Content-Type, etc) through the response.headers GUC - @steve-chavez
• #1450, Allow multiple schemas to be exposed in one instance. The schema to use can be selected through the headers Accept-Profile for GET/HEAD and Content-Profile for POST/PATCH/PUT/DELETE - @steve-chavez, @MahmoudKassem

Fixed

• #1301, Fix self join resource embedding on PATCH - @herulume, @steve-chavez
• #1389, Fix many to many resource embedding on RPC/PATCH - @steve-chavez
• #1355, Allow PATCH/DELETE without return=minimal on tables with no select privileges - @steve-chavez
• #1361, Fix embedding a VIEW when its source foreign key is UNIQUE - @bwbroersma

Changed

• #1385, bulk RPC call now should be done by specifying a Prefer: params=multiple-objects header - @steve-chavez
• #1401, resource embedding now outputs an error when multiple relationships between two tables are found - @steve-chavez
• #1423, default Unix Socket file mode from 755 to 660 - @dwagin
• #1430, Remove embedding with duck typed column names GET /projects?select=client(*)- @steve-chavez
  • You can rename the foreign key to client to make this request work in the new version: alter table projects rename constraint projects_client_id_fkey to client
• #1413, Change server-proxy-uri config option to openapi-server-proxy-uri - @steve-chavez

v6.0.2

Fixed

• #1369, Change raw-media-types to accept a string of comma separated MIME types - @Dansvidania
• #1368, Fix long column descriptions being truncated at 63 characters in PostgreSQL 12 - @amedeedaboville
• #1348, Go back to converting plus "+" to space " " in querystrings by default - @steve-chavez

Deprecated

• #1348, Deprecate . symbol for disambiguating resource embedding(added in #918). The url-safe '!' should be used instead. We refrained from using + as part of our syntax because it conflicts with some http clients and proxies.

v6.0.1

Added

• #1349, Add user defined raw output media types via raw-media-types config option - @Dansvidania
• #1243, Add websearch_to_tsquery support - @herulume

Fixed

• #1336, Error when testing on Chrome/Firefox: text/html requested but a single column was not selected - @Dansvidania
• #1334, Unable to compile v6.0.0 on windows - @steve-chavez

v6.0.0

Added

• #1186, Add support for user defined unix socket via server-unix-socket config option - @Dansvidania
• #690, Add ?columns query parameter for faster bulk inserts, also ignores unspecified json keys in a payload - @steve-chavez
• #1239, Add support for resource embedding on materialized views - @vitorbaptista
• #1264, Add support for bulk RPC call - @steve-chavez
• #1278, Add db-pool-timeout config option - @Qu4tro
• #1285, Abort on wrong database password - @Qu4tro
• #790, Allow override of OpenAPI spec through root-spec config option - @steve-chavez
• #1308, Accept text/plain and text/html for raw output - @steve-chavez

Fixed

• #1223, Fix incorrect OpenAPI externalDocs url - @steve-chavez
• #1221, Fix embedding other resources when having a self join - @steve-chavez
• #1242, Fix embedding a view having a select in a where - @steve-chavez
• #1238, Fix PostgreSQL to OpenAPI type mappings for numeric and character types - @fpusch
• #1265, Fix query generated on bulk upsert with an empty array - @Qu4tro
• #1273, Fix RPC ignoring unknown arguments by default - @steve-chavez
• #1257, Fix incorrect status when a PATCH request doesn't find rows to change - @Qu4tro

Changed

• #1288, Change server-host default of 127.0.0.1 to !4

Deprecated

• #1288, Deprecate . symbol for disambiguating resource embedding(added in #918). '+' should be used instead. Though '+' is url safe, certain clients might need to encode it to '%2B'.

Removed

• #1288, Removed support for schema reloading with SIGHUP, SIGUSR1 should be used instead - @steve-chavez

v5.2.0

Added

• #1205, Add support for parsing JSON Web Key Sets - @russelldavies
• #1203, Add support for reading db-uri from a separate file - @zhoufeng1989
• #1200, Add db-extra-search-path config for adding schemas to the search_path, solves issues related to extensions created on the public schema - @steve-chavez
• #1219, Add ability to quote column names on filters - @steve-chavez

Fixed

• #1182, Fix embedding on views with composite pks - @steve-chavez
• #1180, Fix embedding on views with subselects in pg10 - @steve-chavez
• #1197, Allow CORS for PUT - @bkylerussell
• #1181, Correctly qualify function argument of custom type in public schema - @steve-chavez
• #1008, Allow columns that contain spaces in filters - @steve-chavez

v5.1.0

Added

• #1099, Add support for getting json/jsonb by array index - @steve-chavez
• #1145, Add materialized view columns to OpenAPI output - @steve-chavez
• #709, Allow embedding on views with subselects/CTE - @steve-chavez
• #1148, OpenAPI: add required section for the non-nullable columns - @laughedelic
• #1158, Add summary to OpenAPI doc for RPC functions - @mdr1384

Fixed

• #1113, Fix UPSERT failing when having a camel case PK column - @steve-chavez
• #945, Fix slow start-up time on big schemas - @steve-chavez
• #1129, Fix view embedding when table is capitalized - @steve-chavez
• #1149, OpenAPI: Change GET response type to array - @laughedelic
• #1152, Fix RPC failing when having arguments with reserved or uppercase keywords - @mdr1384
• #905, Fix intermittent empty replies - @steve-chavez
• #1139, Fix JWTIssuedAtFuture failure for valid iat claim - @steve-chavez
• #1141, Fix app.settings resetting on pool timeout - @steve-chavez

Changed

• #1099, Numbers in json path ?select=data->1->>key now get treated as json array indexes instead of keys - @steve-chavez
• #1128, Allow finishing a json path with a single arrow ->. Now a json can be obtained without resorting to casting, Previously: /json_arr?select=data->>2::json, now: /json_arr?select=data->2 - @steve-chavez
• #724, Change server-host default of *4 to 127.0.0.1

Deprecated

• #724, SIGHUP deprecated, SIGUSR1 should be used instead

v0.5.0.0

Added

• The configuration (e.g. postgrest.conf) now accepts arbitrary settings that will be passed through as session-local database settings. This can be used to pass in secret keys directly as strings, or via OS environment variables. For instance: app.settings.jwt_secret = "$(MYAPP_JWT_SECRET)" will take MYAPP_JWT_SECRET from the environment and make it available to postgresql functions as current_setting('app.settings.jwt_secret'). Only app.settings.* values in the configuration file are treated in this way. - @canadaduane
• #256, Add support for bulk UPSERT with POST and single UPSERT with PUT - @steve-chavez
• #1078, Add ability to specify source column in embed - @steve-chavez
• #821, Allow embeds alias to be used in filters - @steve-chavez
• #906, Add jspath configurable role-claim-key - @steve-chavez
• #1061, Add foreign tables to OpenAPI output - @rhyamada

Fixed

• #828, Fix computed column only working in public schema - @steve-chavez
• #925, Fix RPC high memory usage by using parametrized query and avoiding json encoding - @steve-chavez
• #987, Fix embedding with self-reference foreign key - @steve-chavez
• #1044, Fix view parent embedding when having many views - @steve-chavez
• #781, Fix accepting misspelled desc/asc ordering modificators - @onporat, @steve-chavez

Changed

• #828, A SET SCHEMA <db-schema> is done on each request, this has the following implications:
  • Computed columns now only work if they belong to the db-schema
  • Stored procedures might require a search_path to work properly, for further details see https://postgrest.org/en/v5.0/api.html#explicit-qualification
• To use RPC now the json_to_record/json_to_recordset functions are needed, these are available starting from PostgreSQL 9.4 - @steve-chavez
• Overloaded functions now depend on the dbStructure, restart/sighup may be needed for their correct functioning - @steve-chavez
• #1098, Removed support for:
  • curly braces {} in embeds, i.e. /clients?select=*,projects{*} can no longer be used, from now on parens () should be used /clients?select=*,projects(*) - @steve-chavez
  • "in" operator without parens, i.e. /clients?id=in.1,2,3 no longer supported, /clients?id=in.(1,2,3) should be used - @steve-chavez
  • "@@", "@>" and "<@" operators, from now on their mnemonic equivalents should be used "fts", "cs" and "cd" respectively - @steve-chavez

v0.4.4.0

Added

• #887, #601, #1007, Allow specifying dictionary and plain/phrase tsquery in full text search - @steve-chavez
• #328, Allow doing GET on rpc - @steve-chavez
• #917, Add ability to map RAISE errorcode/message to http status - @steve-chavez
• #940, Add ability to map GUC to http response headers - @steve-chavez
• #1022, Include git sha in version report - @begriffs
• Faster queries using json_agg - @ruslantalpa

Fixed

• #876, Read secret files as binary, discard final LF if any - @eric-brechemier
• #968, Treat blank proxy uri as missing - @begriffs
• #933, OpenAPI externals docs url to current version - @steve-chavez
• #962, OpenAPI don't err on nonexistent schema - @steve-chavez
• #954, make OpenAPI rpc output dependent on user privileges - @steve-chavez
• #955, Support configurable aud claim - @statik
• #996, Fix embedded column conflicts table name - @grotsev
• #974, Fix RPC error when function has single OUT param - @steve-chavez
• #1021, Reduce join size in allColumns for faster program start - @nextstopsun
• #411, Remove the need for pk in &select for parent embed - @steve-chavez
• #1016, Fix anonymous requests when configured with jwt-aud - @ruslantalpa

v0.4.3.0

Added

• #567, Support more JWT signing algorithms, including RSA - @begriffs
• #889, Allow more than two conditions in a single and/or - @steve-chavez
• #883, Binary output support for RPC - @steve-chavez
• #885, Postgres COMMENTs on SCHEMA/TABLE/COLUMN are used for OpenAPI - @ldesgoui
• #907, Ability to embed using a specific relation when there are multiple between tables - @ruslantalpa
• #930, Split table comment on newline to get OpenAPI operation summary and description - @daurnimator
• #938, Support for range operators - @russelldavies

Fixed

• #877, Base64 secret read from a file ending with a newline - @eric-brechemier
• #896, Boolean env var interpolation in config file - @begriffs
• #885, OpenAPI repetition reduced by using more definitions- @ldesgoui
• #924, Improve relations initialization time - @9too
• #927, Treat blank pre-request as missing - @begriffs

Changed

• #938, Deprecate symbol operators with mnemonic names. - @russelldavies