/plushcap/analysis/supabase/supabase-pg-graphql-1-5-7

pg_graphql 1.5.7: pagination and multi-tenancy support

What's this blog post about?

In version 1.5.7 of pg_graphql, several quality of life improvements have been made. These include support for pagination via First/Offset, schema-based multi-tenancy, and filtering on array typed columns with contains, containedBy, and overlaps operators. The introduction of offset-based pagination allows users to skip a certain number of records before returning the results. Multi-tenancy performance has been improved by caching only schemas that tenants have usage permission for, reducing query time in multi-tenant environments. Additionally, filtering array column types is now supported for scalar array fields like text[] or int[]. Future releases will include support for insert on conflict/upsert and nested inserts.

Company
Supabase

Date published
Aug. 15, 2024

Author(s)
Oliver Rice

Word count
468

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.