Supabase Alpha June 2020

Summary

Four months into development, Supabase released its June 2020 alpha update focused on simplifying PostgreSQL management and eliminating regional performance bottlenecks. The release introduces a spreadsheet-like interface for drilling down into relational tables alongside automated detection and editing support for JSON and JSONB columns. To address latency issues previously caused by hosting all projects exclusively in Singapore, the platform now allows developers to select specific database regions. In line with its zero lock-in principle, Supabase exposed daily backups on the dashboard and enhanced the SQL editor with improved syntax highlighting. The team also expanded by hiring PostgREST maintainer Steve Chavez while continuing efforts toward future multi-region replication and WAL-G backup integration.

Context

Four months into development, Supabase needed to make relational Postgres workflows simpler than document stores, eliminate network latency caused by setting up all projects in Singapore, and provide database exports to uphold a zero lock-in principle.

Approach / What changed

Supabase implemented an Excel-like relational table editing interface, detection and editing tools for JSON and JSONB columns, selectable hosting regions, and dashboard access to daily backups. They also improved SQL editor syntax highlighting, added code snippets to API docs, and hired PostgREST maintainer Steve Chavez.

Takeaways

• Supabase introduced an Excel-like interface for viewing relational tables alongside automated detection and editing support for JSON and JSONB columns.
• Projects can now be launched in user-selected database regions to reduce latency, replacing the initial Singapore-only deployment setup.
• Daily database backups were made downloadable directly from the dashboard to prevent vendor lock-in and ease external migrations.

Related reading

• Supabase · Nov 2, 2020

  Supabase Alpha October 2020

  Eight months into building Supabase, the team released product updates focused on stability, reliability, and performance while preparing to transition from Alpha to Beta. The release introduces supabase-js version 1.0, incorporating extensive community feedback to deliver major developer experience improvements across client libraries. Platform interface updates include tabs and full-screen mode for the SQL Editor, alongside new keyboard shortcuts to help power users navigate and manipulate tables rapidly. For user authentication, Supabase added magic link capabilities, enabling passwordless login flows for both new and existing users either as a standalone method or alongside passwords. Under continuous improvement efforts, the team converted realtime-js to TypeScript, heavily optimized dashboard routing performance, and established a repository to benchmark all integrated open source tools.

  Paul Copplestone

• Supabase · Aug 2, 2020

  Supabase Alpha July 2020