Supabase Beta December 2021

Summary

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.

Approach / What changed

Supabase added the pg_sodium extension across all Postgres instances, introduced capabilities to call external HTTP endpoints from Postgres functions, and updated community tooling and third-party integrations.

Takeaways

• The pg_sodium extension is available inside all Supabase PostgreSQL instances, supporting encryption, decryption, hashing, and cryptographic signing via the dashboard extensions tab.
• PostgreSQL functions in Supabase support invoking external HTTP endpoints and can be called from JavaScript using remote procedure calls.
• The ecosystem expanded with updated community Python libraries (supabase v0.0.4, gotrue v0.3.0, realtime v0.0.4, storage3 v0.1.0) and new integrations with Divjoy and n8n.

Related reading

• Supabase · Feb 2, 2021

  Supabase Beta January 2021

  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.

  Paul Copplestone

• Supabase · Oct 4, 2021

  Supabase Beta Sept 2021

  The September 2021 beta update for Supabase outlines several product enhancements, documentation revamps, and community milestones. Developers using the JavaScript library can now leverage AbortController support to cancel long-running queries. Multiple PostgreSQL capabilities have been surfaced directly within the Supabase Dashboard, allowing users to apply custom column types, configure unique constraints on tables, view and edit columns in bulk, and manage table relationships spanning multiple schemas. In addition, the authentication documentation has been restructured into dedicated sections for Authentication and Authorization alongside an accompanying deep dive series. The update also marks two years since the initial commit to the Realtime Postgres engine, details upcoming events such as a Hacktoberfest hackathon, and announces open hiring for Site Reliability Engineers.