Supabase Beta December 2020

Summary

Supabase transitioned to Beta following ten months of development concentrated on performance, security, and reliability. The platform introduced inline table documentation updates, storing descriptions directly as PostgreSQL comments and exposing them through OpenAPI specifications. Developers can now utilize a table view featuring immediate realtime update reflection alongside pagination for handling large datasets. Performance measurements show a 26 percent increase to 1460 requests per second in regions supporting AWS Graviton instances. Furthermore, the update introduces a new region in Sao Paulo, editing support for native Postgres arrays in the grid editor and side panel, and broader compatibility for custom database types.

Context

Supabase spent ten months building and addressing performance, security, and reliability before launching its beta phase and securing a six-million-dollar seed round.

Approach / What changed

The team enabled inline table descriptions via PostgreSQL comments exposed through OpenAPI, added realtime updates and pagination to the Table View, added native Postgres array and custom type support, launched a Sao Paulo region, and leveraged Graviton-supported regions.

Takeaways

• Table descriptions added inline are directly stored as PostgreSQL comments and exposed through the OpenAPI specification.
• Table View supports pagination for large datasets and immediately reflects realtime changes occurring in the database.
• Throughput reached 1460 requests per second in Graviton-supported regions, up from 1167 requests per second.

Related reading

• Supabase · May 5, 2021

  Supabase Beta April 2021

  Supabase focused on platform stability, security enhancements, and community support during its April 2021 beta update cycle. To address visual accessibility needs for developers with astigmatisms or those operating in brightly lit environments, the team delivered Light Mode within the dashboard settings. The release also introduced OpenAPI-powered Storage API documentation, community translations for the main repository spanning nineteen distinct languages, and an experimental synchronization server connecting Postgres with Stripe. Dashboard components are systematically migrating into an open-source UI library, establishing necessary foundations for local development tooling and self-hosted environments. Additionally, the team reported substantial contributor growth across its realtime server and UI repositories while continuing engineering on a Workflows engine aimed at a July release.

  Paul Copplestone

• Supabase · Jun 2, 2021

  Supabase Beta June 2021

  Supabase announced a series of platform updates, documentation additions, and tooling enhancements for June 2021 ahead of its scheduled Launch Week. Developers can now provision a Postgres database directly through a new Vercel integration and enable authentication using Discord logins. Supabase Storage added support for upsert operations alongside public buckets that allow unauthenticated file access. The web dashboard introduced a restart button for debugging and a table policy editor with templates to configure Row Level Security. Additional backend improvements include timestamps for PostgREST error logs, an OpenAPI mode patch ignoring anonymous privileges for Prisma users, and an XSS fix in the Auth0 Next.js library.