March 2022 Summaries

Supabase has launched Edge Functions, allowing users to execute TypeScript code close to their users regardless of location. These functions are executed on the secure-by-default Deno runtime and deployed globally using Deno's hosted Deno Deploy offering. Supabase Edge Functions aim to provide a seamless experience for developers by handling all the complexities, enabling them to focus on business logic. The platform offers global deployments instead of specific geographical regions, ensuring fast response times no matter where users are located.

Edge Functions, a new feature from Supabase, allows users to execute Typescript code close to their users worldwide. The platform uses Deno runtime for secure execution of functions deployed globally. Supabase Edge Functions are designed with simplicity and developer experience in mind, offering live-reloading, local development environment matching production, and quick deployments. The service is scalable and cost-effective, allowing users to pay only for what they use. Future features on the roadmap include cron functions, Studio support, cold start time optimization, and more.

Supabase has introduced new enterprise features for its Pro tier users, including spend caps and database add-ons. The company aims to provide enterprise-grade resilience for developers building business-critical applications. Additionally, Supabase is working on several upcoming features such as Point-in-Time Recovery, Prometheus Endpoints, SLAs & Enterprise Support, and more. These enhancements are designed to make the platform more developer-friendly and predictable in terms of pricing.

The developer platform Supabase is expanding its features to cater to a growing segment of users building business-critical applications that require enterprise-grade resilience. The company has introduced several new features, including spend caps on the Pro Plan, self-serve Database Add-ons, and a new Log Explorer that allows users to query logs using SQL. Additionally, Supabase has released Elixir Livebooks for Monitoring, which provides built-in monitoring for PgBouncer, a Postgres connection pooler. The company also announced its new Enterprise Plan, which includes features such as Point-in-Time Recovery, Prometheus Endpoints, and SLAs & Enterprise Support. Supabase is SOC2 Type 1 compliant and is working on getting certified for SOC2 Type 2 and HIPAA. The platform is also developing features such as Foreign Data Wrappers, Materialized Views, and Log ingestion. With these new features, Supabase aims to provide a more comprehensive and scalable solution for developers building enterprise-grade applications.

Supabase has introduced general availability of GraphQL on its platform through an open-source PostgreSQL extension called pg_graphql (beta). This enables users to query existing PostgreSQL databases using GraphQL, either from within SQL or over HTTP. The new feature also translates schema reflection into the GraphQL base type and exposes bulk CRUD operations on Query and Mutation types with relay style keyset pagination, filters, ordering, and optional name inflection. Supabase's integration of GraphQL directly in the database allows it to leverage PostgreSQL's built-in primitives for authentication and authorization.

Supabase has introduced significant enhancements to its pg_graphql extension, which enables querying PostgreSQL databases using GraphQL from SQL or over HTTP. The update includes schema reflection, where tables become types and columns become fields, as well as support for bulk CRUD operations with pagination, filters, and ordering. Security features include authentication based on PostgreSQL's built-in primitives and authorization that respects existing row level security policies. Performance optimizations include transpiling GraphQL queries into a single SQL query and caching prepared statements to reduce network round-trips and time spent in the database. To enable GraphQL in Supabase, users can create the extension in their database or enable it from the dashboard.

Supabase is celebrating its launch week by showcasing the communities and contributors that make up the Supabase community, highlighting their work, and celebrating everyone who contributes their time. The company has a quarterly cadence for launch weeks, which include feature launches, blog posts, and virtual hackathons. During this launch week, Supabase is partnering with GitHub to scan for Supabase service role API keys, releasing a pre-release of PostgREST v10, adding new OAuth providers and phone providers, enabling server-side auth for Next.js and Nuxt, and more. Additionally, the company is launching a partner gallery to keep track of all integrations that work with Supabase.

Supabase, an open-source platform, has experienced numerous advantages since its inception. Open-sourcing Supabase helped solve talent acquisition problems by attracting developers interested in contributing to the project. It also improved product development as community members provided valuable feedback and code improvements. Additionally, it fostered a sense of security as more eyes on the code led to early detection and fixing of potential issues. Lastly, open-sourcing Supabase helped build a strong community that could outcompete competitors in the long run.

Supabase Launch Week is an annual event where the company launches new features, tools, and updates every day for a week, starting on March 28th with Community Day, followed by specific themes for different teams such as Frontend, Enterprise, and Fullstack. The week culminates in a surprise announcement on Friday, and concludes with a 10-day virtual Hackathon where participants can build projects using the new features and win prizes, including limited Supabase Swag and the chance to plant trees through a partnership with the Future Forest Company.

The text discusses creating a generic auditing solution for PostgreSQL using 150 lines of SQL code. The goal is to create an auditing system that is low maintenance, easy to use, and fast to query. The solution uses PostgreSQL's schema-less JSONB data type to store each record's data in a single column, allowing for efficient querying and storage of multiple tables' audit history in a single table. The solution also includes triggers to populate the audit table with changes made to the original table. The auditing system provides a public API for enabling and disabling tracking on specific tables.