postgrest v0.5.0.0 Release Notes
Release Date: 2018-05-14 // almost 6 years ago-
➕ 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 takeMYAPP_JWT_SECRET
from the environment and make it available to postgresql functions ascurrent_setting('app.settings.jwt_secret')
. Onlyapp.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--replace
- curly braces
- The configuration (e.g.