/plushcap/analysis/supabase/supabase-postgrest-11-prerelease

PostgREST 11 pre-release

What's this blog post about?

PostgREST 11 introduces improved querying capabilities, including spreading related tables, related orders, and anti-joins. Spreading related tables allows for a "flattened" result to be presented to the frontend without nested objects. Order by related tables enables ordering of a table based on a related table column. Anti-joins allow filtering rows where the related table is null or not null, providing more flexibility in combining related tables' conditions. These features are currently available as a pre-release and can be tried out locally with the Supabase CLI.

Company
Supabase

Date published
Dec. 16, 2022

Author(s)
Steve Chavez

Word count
630

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.