Company
Date Published
Nov. 27, 2021
Author
Steve Chavez
Word count
470
Language
English
Hacker News points
None

Summary

PostgREST 9, released on November 27th, introduces new features such as resource embedding with inner joins and functions with unnamed parameters. Inner join capabilities allow for filtering rows of the top-level table based on a filter of an embedded table. Functions with unnamed parameters enable POST requests to functions with a single parameter, useful for webhooks that send JSON payloads. Additionally, PostgREST 9 is compatible with PostgreSQL 14 and includes support for partitioned tables, improved documentation, and bug fixes.