Supabase introduced Supabase Wrappers, allowing Postgres to connect with external systems like databases and APIs through SQL using Postgres Foreign Data Wrappers (FDW).
The alpha release supports Firebase and Stripe, with future support for Clickhouse, BigQuery, and Airtable in development.
Examples demonstrate how to connect and map Stripe data to Foreign Tables in Postgres and how to query this data directly from the database or via Supabase client libraries.
Wrappers enable various use cases such as on-demand Big Data queries, simplified onboarding from other systems, AI capabilities, caching, and more, contributing to the QETL concept which emphasizes on querying before moving data.
Supabase aims to use FDW to enhance Postgres as a Data Hub and has made progress by including async support, robust typing, and push-down features in Rust.

Supabase is an open source platform providing developers with tools to quickly build and scale applications. It serves as an alternative to Firebase, offering a range of features including a full Postgres database, authentication services, instant APIs, Edge Functions, real-time data subscriptions, storage solutions, and vector embeddings for machine learning models. Supabase emphasizes developer experience with easy setup, maintenance-free scaling, and immediate API generation from database schemas. It supports various user authentication methods, allows for custom security policies, and fosters a community-oriented ecosystem. It is tailored for both rapid prototyping and large-scale production deployments.

Supabase

Supabase provides scalable open source backend services with Postgres database.

Authentication-as-a-service

Supabase Releases Wrappers, a Postgres FDW Framework in Rust

Recent Product News