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-schema.
  – @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.