Supabase Beta January 2021

Summary

Supabase released a collection of platform updates during January 2021 covering database tools, authentication integrations, regional availability, and infrastructure performance. Client libraries added support for PostgREST exact, planned, and estimated count queries to eliminate counting friction commonly experienced in platforms like Firebase. Authentication capabilities expanded to include Facebook and Azure login providers, an in-dashboard GoTrue audit trail, a helper function for user emails, and a prebuilt React Auth Widget. The platform also enabled new database hosting regions in London and Sydney while transitioning storage to GP3 for improved throughput. Furthermore, migrating API subdomains to Route53 alongside custom Let's Encrypt certificates yielded read performance benchmark gains of up to twelve percent.

Context

Developers working with alternative platforms like Firebase faced difficulties with count operations, while Supabase users required broader authentication integrations, additional hosting locations, and lower latency.

Approach / What changed

Supabase added PostgREST count support to client libraries, integrated Azure and Facebook authentication via GoTrue, added database hosting in London and Sydney, upgraded database storage to GP3, and transitioned subdomains to Route53 with custom Let's Encrypt certificates.

Takeaways

• Supabase client libraries support PostgREST exact, planned, and estimated count operations on PostgreSQL.
• Migrating subdomains to Route53 with custom Let's Encrypt certificates yielded read benchmark improvements of up to 12%.
• Database instances were upgraded to GP3 storage to provide faster and more consistent throughput.

Related reading

• Supabase · Jan 20, 2022

  Supabase Beta December 2021

  Supabase announced a series of platform updates, educational content, and community milestones for December 2021. PostgreSQL instances now include the pg_sodium extension, enabling users to perform encryption, decryption, hashing, and cryptographic signing directly within database queries and functions through the Supabase Dashboard. The release details educational video guides demonstrating remote procedure calls from JavaScript, invoking external HTTP endpoints from database functions, and setting up triggers to run SQL on table modifications. In addition to ecosystem updates featuring new Python library releases and integrations with Divjoy and n8n, the project surpassed 26,000 GitHub stars and opened fully remote job positions across engineering, marketing, and human resources.

  Paul Copplestone

• Supabase · Mar 2, 2021

  Supabase Beta February 2021

  Supabase published its February 2021 beta update marking one year of development as an open-source Firebase alternative. The release introduces dashboard interface improvements across the Table view, Auth section, and SQL Editor, which now features autocomplete suggestions for tables and columns. Authentication updates allow user redirection to specific site routes upon invoking signIn and signUp, while a new database management interface lets users configure Postgres replication settings and events for the realtime API. Infrastructure additions include a new deployment region in South Africa and a Docker Compose configuration intended to power local development in the forthcoming CLI. Documentation expanded with resources for GoTrue and Google OAuth, alongside ongoing RFCs covering connection pooling and local workflows.