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.

Context

Supabase required enterprise-grade throughput, simplified instance configuration at scale, and zero-downtime schema reloading across thousands of managed PostgREST instances.

Approach / What changed

Supabase updated new projects to PostgreSQL 13.3, developed extensions like supautils and pg_net, upstreamed prepared-statement and logging optimizations into PostgREST 8.0, and supported community-driven Flutter and Dart client libraries.

Takeaways

• PostgREST 8.0 achieved up to 50% higher GET throughput in benchmarks by converting SELECT queries to prepared statements and reducing log verbosity.
• Schema cache reloading in PostgREST 8.0 operates with zero downtime and utilizes NOTIFY commands instead of the external pg_listen utility.
• The new openapi-mode in PostgREST allows complete OpenAPI output generation without granting high privileges to the anonymous database role.

Related reading

• Supabase · Jul 26, 2021

  Epsilon3 Self-Host Supabase To Revolutionize Space Operations

  Epsilon3 digitizes paper procedures and telemetry data for high-stakes space missions and complex operational testing. Operating in heavily regulated environments requires strict security, ITAR compliance, and flexible deployment options ranging from AWS GovCloud to on-premises installations. To meet these demands without sacrificing developer velocity, Epsilon3 deployed a self-hosted Supabase configuration running against an Amazon RDS Postgres instance on AWS. This architecture gives the team real-time data streaming capabilities over Postgres so operators can track live procedure changes as they happen. In addition to reducing DevOps complexity, self-hosting Supabase enables Epsilon3 to leverage Postgres Row Level Security while ensuring full compliance across diverse deployment environments.

• Supabase · Aug 12, 2021

  Supabase Beta July 2021

  Supabase concluded July 2021 with its second Launch Week event, delivering daily product updates and infrastructure upgrades across its platform. Authentication features expanded to support SMS logins through Twilio, Twitch authentication, and API endpoints for generating custom email authentication links. Storage capabilities were upgraded to include media streaming, public buckets, directory uploads, and speed improvements, alongside dashboard enhancements for usage statistics and database insights. Furthermore, all newly created Supabase projects now run PostgreSQL 13.3 by default, and instances incorporate the updated PostgREST version 8.0 server to generate CRUD APIs. The release also introduced preliminary components for Supabase functions as development continues toward general availability.