Releases: supabase/supabase
Developer Updates - April 2024
Here’s everything we shipped during our GA week:
Day 1 - Supabase is officially launching into General Availability (GA)
Supabase has moved to General Availability (GA) with over 1 million databases under management and over 2,500 databases launched daily. We’ve been production ready for years and now we are fully confident that we can help every customer become successful, from weekend projects to enterprise initiatives at organizations like Mozilla, 1Password, and PwC.
Full announcement | Video announcement | X space
Day 2 - Supabase Functions now supports AI models
Supabase Functions has added a native API that makes it easy to run AI models within your functions while removing nasty cold starts. You can use the gte-small
embedding model to generate text embeddings or bring your own Ollama server to tap into many more embedding models and Large Language Models (LLMs) like Llama3 and Mistral. Soon we’ll provide hosted Ollama servers so you won’t have to manage them yourselves for a more seamless experience.
Blog post | Video announcement | X space
Day 3 - Supabase Auth now supports Anonymous sign-ins
Supabase Auth heard your requests and went to work building anonymous sign-ins which enable you to create temporary users that have yet to sign up for your application. This lowers the friction for visitors to use your application while making it easy to convert them to permanent users once they’re hooked.
Blog post | Video announcement | X space
Day 4 - Supabase Storage now supports the S3 protocol
Supabase Storage already has standard and resumable uploads and now supports the industry standard S3 protocol enabling multipart upload and compatibility with a myriad of tools such as AWS CLI, Clickhouse, and Airbyte for a wide array of use cases.
Blog post | Video announcement | X space
Day 5 - Supabase Security & Performance Advisor
Supabase has managed over 1 million databases over the last four years and has seen all manner of use cases with common pitfalls that we’re helping our customers address with our Security, Performance, and Index Advisors. These Advisors will help to surface and fix insecure database configurations and recommend database and query optimizations to keep your database secure and performant for your mission critical workloads.
Blog post | Video announcement | X space
GA Week Hackathon Winners
We are delighted that so many high quality projects were submitted but in the end there could only be one Best Overall Project. The decision wasn’t easy but the Supabase panel of judges chose vdbs (vision database SQL) for the honorific. Congratulations 👏 to @xavimonp who will receive the prize of Apple AirPods.
Full list of winners | All the submissions
One more thing from GA Week
Just kidding, there’s always more than one. Here’s more awesome things we shipped:
- Supabase on the AWS Marketplace
- Database branching is now Publicly Available
- Supabase Bootstrap: the fastest way to launch a new project
- Supabase Swift officially supported
- Oriole, table storage extension for Postgres, joins Supabase
- Fly Postgres, a managed offering from Supabase, is available to everyone for testing
- Supabase GA Week meetups in 27 cities around the world
- Join our upcoming Meetup in SF at the a16z office with friends from Ollama and Fly.io
Community Highlights
- Changing Databases 5 Times in 48 Hours Boosted Our Launch to 35,000 Views [Article]
- Crazy new Supabase feature: Understand and learn about anonymous users [Video]
- Support unstructured data in Postgres with JSON columns [Video]
- Build an AI-powered blogging platform (Next.js, Langchain & CopilotKit) [Article]
- How to Secure Your Supabase Database and Storage [Blog post]
- Self-host Protomaps PMTiles on Supabase Storage [Video]
- Supabase Realtime - How to deal with multiplayers in Next.js [Blog post]
- The Hard Parts of Building an Application, Made Easy with Supabase [Article]
Platform Updates: March 2024
Join us for a Special Announcement April 15-19
We’re making a Special Announcement on April 15th with a few more surprises throughout the week. Claim your ticket today so you don’t miss out and enter for a chance to win a set of AirPods Max.
Increased Supavisor connection pooler limits
We’ve increased the Supavisor client connection limits, the number of concurrent clients that can connect to your project’s pooler, for projects on Small, Medium, Large, and XL compute instances while pricing remains unchanged.
Conversational AI assistant now available in SQL Editor
Introducing a conversational AI assistant in the SQL Editor to help you write and iterate on your queries. This is currently under a feature preview and can be enabled with instructions here.
Supavisor pooler port 6543 is transaction-mode only
We’re simplifying Supavisor connection pooler ports and modes so that port 6543 is only transaction mode and port 5432 continues to be only session mode. If you have pool mode set to session we recommend you switch to pooler port 5432 and set the mode to transaction.
Migration to v2 platform architecture
You may have noticed improved performance from your database over the last couple of weeks. We made some architectural changes to free up resources for your Postgres instance by removing Storage, Realtime, and Pgbouncer from your instance and each are replaced with an equivalent multi-tenant solution, including our new Supavisor connection pooler.
Implementing semantic image search with Amazon Bedrock and Supabase Vector
In this post we'll be creating a Python project to implement semantic image search featuring Amazon Bedrock and Amazon Titan’s multimodal model to embed images and Supabase Vecs client library for managing embeddings in your Supabase database with the pgvector extension.
Quick Product Announcements
- [Postgres Tooling] vector (pgvector) upgraded to v0.6.2 enables faster HNSW index builds using more parallel workers [Commit]
- [Postgres Tooling] pg_cron upgraded to v1.6.2 enables sub-minute schedules [Pull request]
Made With Supabase
- location-tRacer - Supabase Realtime live location sharing app [GitHub]
- Talk to your docs - An example agent providing help on your GitHub documentation [GitHub]
- Feedbase - Open-source solution for collecting feedback & communicating updates [GitHub]
- Wacky Wordcraft - Create wacky stories with some help from AI [Twitter]
- Capgo - Instant updates for Capacitor apps. Ship updates, fixes, changes, and features within minutes [Website]
Community Highlights
- Building an Investor List App with Novu and Supabase [Blog post]
- 3 reasons you should use Postgres Functions and Transactions [Video]
- Add image support to Flutter web application with Supabase Storage [Video]
- How to set up a secure Supabase project [Blog post]
- Dynamic Role and Permission Management in Supabase: Enhancing Security and Flexibility [Blog post]
- Simulate Supabase Postgres RLS (Row Level Security) [Blog post]
- Monitor Supabase databases and Edge Functions [Blog post]
Platform Updates: February 2024
Matryoshka Embeddings: Faster OpenAI Vector Search Using Adaptive Retrieval
Learn about how OpenAI’s newest text embeddings models, text-embedding-3-small and text-embedding-3-large, are able to truncate their dimensions with only a slight loss in accuracy.
Easily Connect to Supabase Projects From Frameworks and ORMs of Your Choice
Connect to Supabase from any framework or ORM with our new “Connect” panel in Studio. This displays simple setup snippets that you can copy and paste into your application. We’ve started with a selection of popular frameworks and ORMs and you can request more by feature request or pull request.
PostgREST Aggregate Functions
PostgREST v12 has been released, and with it, comes the release of the highly requested aggregate functions, avg()
, count()
, sum()
, min()
, and max()
, that is used to summarize data by performing calculations across groups of rows.
Terraform Provider to Manage Resources on Supabase Platform
We’ve created an official Supabase Provider for Terraform to version-control your project settings in Git. You can use this provider in CI/CD pipelines to automatically provision projects and branches and keep configuration in code.
Support for Composite Foreign Keys in Table Editor
We've shifted the management of foreign keys into the Table Editor’s side panel so you can easily see all foreign keys pertaining to a table as well as referencing columns to composite foreign keys.
Build a Content Recommendation App With Flutter and OpenAI
Learn about how we built a movie listing app that recommends another movie based on the movie that a user is currently viewing built with Supabase, Flutter, and OpenAI.
Load Testing Supabase
Performance testing evaluates a system's compliance with its performance requirements. It reveals your app’s ability to handle user load, unexpected spikes, or recover from stressful workloads. In this blog post you will learn about how we automated our performance testing.
More Studio Updates
- Collapsible main sidebar navigation [PR]
- Create charts from SQL Editor [PR]
- Resizable main tabs in Table Editor and SQL Editor [PR]
- View user metadata from the dashboard [PR]
- Bulk delete SQL Editor snippets [PR]
- Query Performance updates [PR]
- Choose a compute option when creating a project (Paid organizations only) [PR]
- Logs Explorer facelift [PR]
Quick Product Announcements
- [Auth] Require AAL2 to enroll additional factors for MFA enrollment [PR]
- [Storage] Increased maximum file upload size to 50GB for paid plans [PR]
Made With Supabase
- Inkvestigations is a webgame using LLM technology (currently GPT) to create interactive mystery games [GitHub]
- MathPuzzles- a multiplayer game to outsmart your friends [GitHub]
- Create a recipe app with Nowa [Article]
- Open-source AI wearable device that captures what you say and hear [GitHub]
- Brick yourself - turn yourself into a mini-figure [Website]
Community Highlights
- SupaVlog: Vlog Application Starter Kit Built with Supabase, Stream, Hookdeck, and Next.js [Article]
- Chat with Supabase PostgreSQL using AI [Article]
- How to implement Google sign-in on Flutter with Supabase on iOS, Android and the Web [Video]
- They're Making Supabase Better... [Video]
- How to send welcome emails with Supabase edge functions and database triggers [Article]
- How to Create Email Signup and Login Screens in React Native (Expo), ExpressJS, and Supabase [Article]
- Integrating Supabase with Flutterflow [Video]
- Join the #SupaBuilders movement and never get your project paused again!
March Beta 2021
Launch week, Storage, Supabase CLI, Connection Pooling, Supabase UI, and Pricing. Here's what we released last month.
This is also available as a blog post and a video demo.
Supabase Storage
Need to store images, audio, and video clips? Well now you can do it on Supabase Storage. It's backed by S3 and our new OSS storage API written in Fastify and Typescript. Read the full blog post.
Connection Pooling
The Supabase API already handles Connection Pooling, but if you're connecting to your database directly (for example, with Prisma) we now bundle PgBouncer. Read the full blog post.
React UI Component Library
We open sourced our internal UI component library, so that anyone can use and contribute to the Supabase aesthetic. It lives at ui.supabase.io . It was also the #1 Product of the Day on Product Hunt.
CLI
Now you can run Supabase locally in the terminal with supabase start
. We have done some preliminary work on diff-based schema migrations, and added some new tooling for self-hosting Supabase with Docker. Blog post here.
OAuth Scopes
Thanks to a comunity contribution (@_mateomorris and @Beamanator), Supabase Auth now includes OAuth scopes. These allow you to request elevated access during login. For example, you may want to request access to a list of Repositories when users log in with GitHub. Check out the Documentation.
Kaizen
- You can now manage your PostgREST configuration inside the Dashboard.
- Our website has been redesigned. Check out our new Homepage and Blog, and our new Database, Auth, and Storage product pages.
- We refactored some of our Filter methods to make them even easier to use. Check out the Full Text Search refactor.
- We have added several new sections to our Docs including: Local Dev, Self Hosting, and Postgres Reference docs (all still under development).
February Beta 2021
Supabase is an open source Firebase alternative. We've now been building for one year. Here's what we released last month.
This is also available as a blog post and a video demo.
Dashboard Sidebars
We've improved the UX of our Dashboard with sidebars in every section, including the Table view, the Auth section, and the SQL Editor.
SQL Autocomplete
Writing SQL just got 10x easier. We added autocomplete to the SQL editor, including table & column suggestions.
Auth Redirects
Redirect your users to specific route within your site on signIn()
and signUp()
.
Learning Resources
We've released a new Resources section in our docs, as well as two new Auth modules: GoTrue Overview and Google OAuth.
New Region
Launch your database in South Africa.
Kaizen
- We filled up our Examples page with a lot of new content.
- We released a Docker Compose file for running Supabase locally. This will be used in our upcoming CLI.
- We have a couple of pending RFCs which you may want to participate in:
January Beta 2021
New year, new features. We've been busy at Supabase during January and our community has been even busier. Here's a few things you'll find interesting.
This is also available as a blog post and a video demo.
Count functionality
Anyone who has worked with Firebase long enough has become frustrated over the lack of count
functionality. This isn't a problem with PostgreSQL! Our libraries now have support for PostgREST's exact, planned, and estimated counts. A massive thanks to @dshukertjr for this adding support to our client library.
New Auth Providers
We enabled 2 new Auth providers - Facebook and Azure. Thanks to @Levet for the Azure plugin, and once again to Netlify's amazing work with GoTrue to implement Facebook.
Auth Audit Trail
We have exposed the audit trail directly in the dashboard, as well as the GoTrue logs. Great for security and debugging.
Auth UI widget
In case our Auth endpoints aren't easy enough already, we've built a React Auth Widget for you to drop into your app and to get up-and-running in minutes.
New auth.email()
function
We added a helper function for extracting the logged in user's email address.
New Regions
Launch your database in London or Sydney!
Copy rows as Markdown
You can now copy SQL results as Markdown - super useful for adding to blogs and issues.
React server components
If you're excited by React Server components then check out the Supabase + Server Components experimental repo. https://github.com/supabase/next-server-components
Learn
We know that Auth can be a bit daunting when you're just starting out, so we have created some intro videos to get you up to speed in no time:
- Supabase Auth Deep Dive Part 1: JWTs
- Supabase Auth Deep Dive Part 2: Restrict Table Access
- Supabase Auth Deep Dive Part 3: User Based Access Policies
Kaizen
- Performance: We migrated all of our subdomains to Route53, implementing custom Let's Encrypt certs for your APIs. As a result, our read benchmarks are measuring up 12% faster.
- Performance: We upgrade your databases to the new GP3 storage for faster and more consistent throughput.
December Beta 2020
After 10 hectic months of building, Supabase is now in Beta.
This is also available as a blog post and a video demo.
Supabase is now in Beta
We spent months working on Performance, Security, and Reliability. Read more on our Beta Page.
Improve your docs inline
Add comments and descriptions to your Tables directly from our auto-generated docs.
Table View now has realtime changes
Any updates that happen to your database are reflected in the Table View immediately.
Table Pagination
Our table view now has pagination - better for working with large data sets.
Supabase raised a Seed Round
We raised $6M from Y Combinator, Mozilla, and Coatue. You can read more on TechCrunch.
Kaizen
- Supabase is now 26% faster in regions which support Graviton (1460 reqs/s up from 1167 reqs/s)
- We launched a new region in Sao Paulo.
- Postgres Array Support. You can now edit Native Postgres array items in the grid editor or the side panel.
- We added better support for your custom Database Types.
- Fixed some buggy keyboard commands. We're continuously improving key commands in the Table editor.
Alpha November 2020
We've been building for 9 months now, are we're getting even closer to Beta.
This is also available as a blog post and a video demo.
Add users
You can now add users manually from your dashboard.
User admin
You can also perform admin functions on existing users - send password reset emails, magic links, and delete users.
Even more powerful SQL Editor
Last month we announced an improved SQL Editor, and this month we've taken it even further. The SQL Editor is now a full Monaco editor, like you'd find in VS Code. Build your database directly from the browser.
Status page
We added a Status Page which tracks the uptime and latency of the Supabase platform.
Kaizen
- We completed a security audit by DigitalXRAID.
- Email confirmations now enabled by default for signups.
- Updated Benchmarking Suite to include more realistic workloads, on various different servers (results published soon).
- You can now set/edit/remove Foreign Keys via the table editor.
Alpha October 2020
We're now 8 months into building Supabase. We're focused on performance, stability, and reliability but that hasn't prevented us from shipping some great features.
This is also available as a blog post and a video demo.
Supabase.js 1.0
In the lead-up to our Beta launch, we've released supabase-js
version 1.0 and it comes with some major Developer Experience improvements. We received a lot of feedback from the community and we've incorporated it into our client libraries for our 1.0 release.
Check out the blog post to learn more.
More powerful SQL Editor
Although it was only intended to be a temporary feature, the SQL Editor has become one of the most useful features of Supabase. This month we decided to make give it some attention, adding Tabs and making it full-screen. This is the first of many updates, we've got some exciting things planned for the SQL Editor.
Keyboard shortcuts for Power Users
For the heavy table editor users, we've gone ahead and added a bunch of key commands and keyboard shortcuts so you can zip around and manipulate your tables faster than ever.
Magic Links
One of the most requested Auth features was the ability to send magic links that your users can use to log in. You can use this with new or existing users, and alongside passwords or stand alone.
Kaizen
- We have new and improved docs.
- We converted realtime-js to TypeScript.
- Dashboard Performance: we heavily optimised our dashboard routes.
- With the help of the community, we closed a lot of issues during Hacktoberfest.
- We have started benchmarking all the open source tools we use. We'll publish the results this month.
Alpha September 2020
This is also available as a blog post.
Third-party logins
We've released OAuth logins! You can now enable third-party logins on your app for Bitbucket, GitHub, GitLab, or Google.
Clone tables
You can duplicate your tables, just like you would inside a spreadsheet.
Enable and disable extensions
Extensions are easier to use. You can enable Postgres extensions with the click of a button.
Save your favorite queries
The SQL editor now stores your query history in your browser. You can also save your favorite queries to run later!
GitHub Discussions
Supabase was given access to GitHub Discussions! This is the place for you to ask questions or show off what you've built with Supabase.
Kaizen
- Our dashboard now uses Next.js automatic static optimization - so it should be noticeably more responsive.
- We created an Isomorphic
gotrue-js
TypeScript library for interacting with Netlify's GoTrue server. This will soon be bundled intosupabase-js
- We migrated our
postgrest-js
library to TypeScript, and it will soon be bundled intosupabase-js