Supabase Beta September 2023

2023-10-04

5 minute read

We’ve come a long way since our first update email in April 2020. We’ve gone from 6 hosted databases on our platform to over 650,000 (and that doesn’t even include database branches. As always we’ve had another hectic month of shipping fast, and community involvement in our open source repos, meaning we can iterate on Supabase faster than ever. Here’s a small sample of some of the things we shipped during September…

Broadcast realtime messages via REST API

Broadcast realtime messages via REST API

You can now broadcast Realtime messages to all your connected users by simply using a REST API call, removing the need to connect to a WebSocket. This will be especially useful with our Edge Functions!

Broadcast docs

Supavisor is now used for connection pooling in all new projects

Supavisor is now used for connection pooling in all new projects

Less than two months ago, we announced Supavisor, our own Postgres connection pooler that handles millions of connections. It’s now available in all new projects. You can continue using pgbouncer alongside Supavisor, however, it will be deprecated effective January 15th, 2024.

Learn more

Moving to IPV6 for Database Connection Strings

With IPv4 addresses becoming increasingly scarce and cloud providers starting to charge for it, we won’t be assigning IPv4 addresses to Supabase projects from January 15th, 2024. [db.projectref.supabase.co](http://db.projectref.supabase.co) will start resolving to a IPv6 address instead. If you plan on connecting to your database directly, you must ensure that your network can communicate over IPv6. Supavisor will continue to return IPv4 addresses, so you can update your applications to connect to Supavisor instead.

Learn more

New Foreign Data Wrapper: Airtable

New Foreign Data Wrapper: Airtable

Introducing the latest addition to our Wrappers lineup: Airtable! You can use it to query data from your Airtable bases and tables directly from Postgres:


_10
select * from my_airtable_table;
_10
# data from Airtable

Read the Airtable Wrapper docs Learn about Wrappers

Supabase Studio's latest enhancements

Supabase Studio's latest enhancements

Supabase Studio is under constant improvement, here is what’s new:

  • Added UI support for cascade updates
  • Improved JSON previewing and editing
  • Button for toggling Realtime right from the Table Editor
  • See View definition and open it in the SQL Editor to modify
  • UI to view and unban IP addresses to manage banned IPs more conveniently
  • Import CSV files at the table creation stage and a new button to download the table as CSV

Try them out

HNSW Support for Vecs + pgvector

HNSW Support for Vecs + pgvector

Added HNSW support inside Vecs, our Python library for pgvector. Vecs automatically creates schemas and collections inside your database, making it one of the easiest ways to get started with pgvector.

Read the HNSW docs

Quick product announcements

  • [PostgREST] JWT caching just landed. API requests are about to get 100ms faster. [PR]
  • [Auth] Added a default in-memory storage mechanism to allow using supabase-js in these environments to fall back to use this default storage mechanism now. Upgrade to supabase-js v2.36.0 or gotrue-js v2.54.0 for the latest changes. [PR]
  • [Edge Functions] Supports much simpler API for creating functions Deno.serve(req => new Response("ok")). No http standard library dependency needed. (Thanks eifr for contributing with updated CLI templates. [PR]
  • [Edge Functions] You can manage the secrets for your project's Edge Functions via the dashboard. [Try it now]

Supabase at the AI Engineer Summit

Supabase at the AI Engineer Summit

We’re sponsoring a conference for the first time. We'll be participating in the keynote and hosting a workshop on pgvector. Our team of AI experts will be on hand at booth D2 to introduce you to Supabase Vector (and handing out exclusive swag 🛍️).

Participate both physically and remotely

Made with Supabase

Made with Supabase

Discover the stories of two innovative developers who used Supabase to build AI applications that reached remarkable achievements:

  • 🧠 Quivr: an open source second brain that went viral and became one of the most popular Generative AI projects, launching 5000 databases on Supabase.
  • 💬 Chatbase: an AI chatbot builder that scaled to $1M in 5 months, making it one of the most successful single-founder AI products in the industry.

Extended Community Highlights

Community Highlights

  • Sign in with Apple on Expo React Native. Video
  • Infra & remote working AMA with the Fly team. Twitter Space
  • Supaweek: build a production-ready API backed by Supabase, OpenAI, and Zuplo. Day 1 | Day 2 | Day 3 | Day 4 | Day 5
  • Building a real-time WhatsApp Web Clone with Next.js, Supabase, and Stream. Full series
  • Full Stack Calendly Clone using SwiftUI & Supabase. Video
  • Using Supabase’s vector database with PostgreSQL. Article
  • Build A Complex Supabase App w/NoCode. Video
  • Configuring Office365 as the SMTP Provider in Supabase Auth: A Comprehensive Guide. Guide
  • The Edgiest Stack of 2023: Next.js, ShadCN UI, OpenAI, and Supabase. Article
  • Live coding: Harnessing the Power of Vector Embedding Search with Supabase. Live video
  • Deploying Documenso with Vercel, Supabase and Resend. Article
  • Next x Nest - Using Supabase & Google OAuth in NestJS. Tutorial

We are hiring

Come join one of the fastest-growing open source projects ever 🤗

⚠️ Baking hot meme zone ⚠️

Meme about how developers prepare to write SQL

Share this article

Build in a weekend, scale to millions