Supabase Community Day

Summary

Supabase announced a series of platform upgrades and open-source contributions centered around PostgreSQL and its broader tooling ecosystem. Every new project on the platform now deploys on PostgreSQL version 13.3, accompanied by marketplace images on Digital Ocean and AWS. PostgREST version 8.0 incorporates upstreamed performance enhancements, achieving up to 50% more throughput on GET requests by adopting prepared statements for SELECT queries and decreasing log verbosity. The release eliminates downtime during schema cache reloads and replaces the pg_listen requirement with standard NOTIFY commands for dynamic in-database configuration updates. Additionally, community-led efforts introduced beta releases of Flutter and Dart client libraries alongside a dedicated Discord server for developer discussions.

Takeaways

1. 1

   PostgREST 8.0 achieved up to 50% higher GET throughput in benchmarks by converting SELECT queries to prepared statements and reducing log verbosity.

2. 2

   Schema cache reloading in PostgREST 8.0 operates with zero downtime and utilizes NOTIFY commands instead of the external pg_listen utility.

3. 3

   The new openapi-mode in PostgREST allows complete OpenAPI output generation without granting high privileges to the anonymous database role.