v7.0.0

You can download this release at the PostgREST v7.0.0 release page.

Added

• Support for Switching to a schema defined in db-schemas.
  – @steve-chavez, @mahmoudkassem

• Support for Planned Count and Estimated Count.
  – @steve-chavez, @LorenzHenk

• Support for the on_conflict query parameter to UPSERT based on a unique constraint.
  – @ykst

• Support for Resource Embedding Disambiguation.
  – @steve-chavez

• Support for user defined socket permission via server-unix-socket-mode config option
  – @Dansvidania

• HTTP logic improvements – @steve-chavez

  • Support for HTTP HEAD requests.

  • GUCs for Accessing Request Path and Method.

  • Support for Setting headers via pre-request.

  • Allow overriding provided headers(Content-Type, Location, etc) by Setting Response Headers

  • Access to the Authorization header value through request.header.authorization

• Documentation improvements

  • Explanation for Schema Structure.

  • Reference for Embedding on Stored Procedures.

  • Reference for Embedding after Insertions/Updates/Deletions.

  • Reference for filters on JSON Columns.

  • How-to for Providing images for <img>.

  • Added Community Tutorials section.

Fixed

• Allow embedding a view when its source table foreign key is UNIQUE
  – @bwbroersma

• Accept: application/vnd.pgrst.object+json behavior is now enforced for POST/PATCH/DELETE regardless of Prefer: return=minimal
  – @dwagin

• Fix self join resource embedding on PATCH
  – @herulume, @steve-chavez

• Allow PATCH/DELETE without Prefer: return=minimal on tables with no SELECT privileges
  – @steve-chavez

• Fix many to many resource embedding for RPC/PATCH
  – @steve-chavez

Changed

• Bulk Call should now be done by specifying a Prefer: params=multiple-objects header. This fixes a performance regression when calling stored procedures.

• Resource Embedding now outputs an error when multiple relationships between two tables are found, see Embedding Disambiguation.

• server-proxy-uri config option has been renamed to openapi-server-proxy-uri.

• Default Unix Socket file mode from 755 to 660

Thanks

This release was made possible thanks to:

• Daniel Babiak

• Evans Fernandes

• Jan Sommer

• Tsingson Qin

• Michel Pelletier

• Jay Hannah

• Robert Stolarz

• Kofi Gumbs

• Nicholas DiBiase

• Christopher Reid

• Nathan Bouscal

• Daniel Rafaj

• David Fenko

If you like to join them please consider supporting PostgREST development.