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
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!
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.
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.
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:
_10select * from my_airtable_table;_10# data from Airtable
Read the Airtable Wrapper docs Learn about Wrappers
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
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.
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-jsin 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")). Nohttpstandard 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
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
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
- 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 🤗