# Supabase Community Day

[Supabase](https://yomu.fyi/company/supabase) · Steve Chavez · Jul 26, 2021

**Type:** Announcement

## 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.

**Tags:** [Open Source](https://yomu.fyi/topic/open-source), [Performance](https://yomu.fyi/topic/performance), [Postgres](https://yomu.fyi/topic/postgres), [REST APIs](https://yomu.fyi/topic/rest-api)

[Read original post](https://supabase.com/blog/supabase-community-day)
