New updates and product improvements
Supabase HTTP APIs are no longer using DigiCert as the root CA. This should have no impact on the vast majority of environments, as the other CAs in use are essentially universally trusted.
If your client environment only trusts certificates signed by DigiCert, you could be impacted. We're currently using Cloudflare to serve our HTTP APIs, and recommend ensuring that any client environment that only trusts a specific subset of CAs trusts all of the CAs Cloudflare uses.
In an effort to simplify pricing, we are going to remove usage-based billing for the number of Edge Functions in your projects. Instead, we are going for a bigger quota across all plans at no extra costs. We picked the limits to ensure all customers are benefiting from this change.
Free Plan customers can now create 25 instead of 10 functions without the need to upgrade to a paid Plan.
| Free Plan | Pro Plan | Team Plan | Enterprise Plan | |
|---|---|---|---|---|
| Before | 10 included | 100 included, then $10 per additional 100 | 100 included, then $10 per additional 100 | Custom |
| After | 25 included | 500 included | 1000 included | Unlimited |
This change is effective immediately and in case you were previously exceeding the number of included functions on a paid Plan, you will no longer be charged for it.
These breaking changes are rolling out on July 26, 2024 and affects all organizations that have members assigned either the Developer or Read-Only roles.
All Supabase organizations invite users and assign them to one of the following roles as part of membership to an organization:
Depending on the role, members are authorized to access a specific set of the organization's resources, such as permission to create a new project or change the billing email.
We recently re-evaluated the access that the Developer and Read-Only roles have and decided to implement changes to restrict them on a couple of resources to improve your organizations' security.
On July 26, 2024, we will turn off certain access that the Developer and Read-Only roles currently have to your organization's resources. The following table is to illustrate the breaking changes that will be going into effect:
| Resource | Action | Developer | Read-Only |
|---|---|---|---|
| Integrations1 | |||
| Authorize GitHub | - | ✅ → ❌ | ✅ → ❌ |
| Add GitHub Repositories | - | ✅ → ❌ | ✅ → ❌ |
| GitHub Connections | Delete | ✅ → ❌ | ❌2 |
| Vercel Connections | Update | ✅ → ❌ | ❌2 |
| Delete | ✅ → ❌ | ❌2 |
You can learn more about our Platform Access Control here: https://supabase.com/docs/guides/platform/access-control.
If you have any questions or concerns please contact support.
Jul 15, 2024
api schema for your project#By default, the public schema is used to generate API routes for your database. In some cases, it's better to use a custom schema - this is important if you use tools that generate tables in the public schema to prevent accidental exposure of your data.
The dashboard supports this workflow through 2 options: either at the project creation step under "Security Options", or in the project's API settings after your project has been created. More information about this workflow in our documentation here!
Link: https://supabase.com/dashboard/project/_/settings/api
PR: https://github.com/supabase/supabase/pull/27918
Jul 12, 2024
Supabase support for Postgres 13 is being deprecated as of 15th July 2024, and support for it will be fully removed on 15th November 2024.
All Postgres 13 projects should be upgraded to Postgres 15 before 15th November, 2024.
Any projects still on Postgres 13 after the 15th of November 2024 will be automatically upgraded to Postgres 15. If any Postgres extensions or functions are in use that cause the upgrade process to fail, a backup will be taken instead, and the project will be paused.
Postgres 15 comes with numerous features, bug fixes and performance improvements. Check out the announcement blog posts to find out what each version introduces.
Jul 9, 2024
You can now opt to disable the Data API when creating a new project under a section called "Advanced Options", such that you will only be able to connect to your database via connection string. Note that this setting can be subsequently updated again in the project's API settings if and when you want to connect your project via the client libraries.
PR: https://github.com/supabase/supabase/pull/26809
Link: https://supabase.com/dashboard/new/_
You can now control client access to Realtime Broadcast and Presence by adding Row Level Security policies to the realtime.messages table! Read more about through our documentation here!
PR: https://github.com/supabase/supabase/pull/27362
Link: https://supabase.com/dashboard/project/_/realtime/inspector\
Previously, the Table Editor on the dashboard would run a select count(*) from table query to retrieve the number of rows in the table and display it in the editor (this also supports the pagination logic as well). However, understandably this query can be resource intensive and expensive if the table in question is particularly large. As such, we've chucked some optimizations around this logic to only retrieve the exact row count if the table has less than 50k rows, otherwise we'll retrieve an estimate of the row count instead. You'll still be able to get the exact row count but on demand instead.
PR: https://github.com/supabase/supabase/pull/27612
Link: https://supabase.com/dashboard/project/_/editor
PR: https://github.com/supabase/supabase/pull/27749
Link: https://supabase.com/dashboard/project/_/database/tables
Jun 24, 2024
One of our bigger papercuts in terms of billing is customers not understand compute pricing and that they cannot launch unlimited projects for $25 in total per month. Customers also get confused with "Compute Hours" on their bill. The changes aim to alleviate any "surprise" compute charges and serves as kaizen improvement.
Changes involved are only applicable to paid plan organizations, as it's irrelevant for free plan organizations.
PR: https://github.com/supabase/supabase/pull/27268
Link: https://supabase.com/dashboard/new/_
If you've tried updating a table via the Table Editor without an active sort in place, you'd have noticed that the rows seem to re-sort themselves, specifically the row that you were updating. While this is because rows are returned in an unspecified order without a sort clause from the select query, it certainly must've been a confusing UX. We've alleviated this problem by setting a default sort by clause when reading the table via the Table Editor, which will get overriden once you've set a sort via the UI.
PR: https://github.com/supabase/supabase/pull/27097
Link: https://supabase.com/dashboard/project/_/editor
Jun 24, 2024
This only impacts projects on the Free Plan because projects in any of the paid plans cannot be paused.
Beginning June 24, 2024, we're updating some project pause/restore behavior:
This change is being made to enable us to maintain high development velocity on the platform. Previously, paused projects could be restored indefinitely. That creates the need for the platform to remain fully backwards compatible with outdated versions of Postgres and associated extensions. The update allows us to provide a reasonable pause/restore window while gaining the ability to evolve the platform.
Jun 18, 2024
Supabase Edge Runtime version 1.54 is compatible with Deno 1.43.
Supabase's hosted platform was upgraded to use this release when serving Edge Functions starting today.
If you're using Supabase CLI for local development latest stable release 1.176.10, it adds compatibility for Deno 1.43.
When you run supabase functions serve, it should show the current version of Edge Runtime used (and its Deno compatibility)
_10> supabase functions serve_10_10Setting up Edge Functions runtime..._10Serving functions on http://127.0.0.1:54321/functions/v1/<function-name>_10Using supabase-edge-runtime-1.54.2 (compatible with Deno v1.43.0)
You can check the served_by field in log events to see which Edge Runtime version was used to serve your function
.
We try our best to maintain backward compatibility in these upgrades. If you're experiencing any issues, please feel free to make a support request
Jun 18, 2024
Supabase underwent Consolidation Month™ to focus on initiatives that improve the stability, scalability, and security of our products. We also have exciting product announcements that we can’t wait to share. Let’s dive in!
We kicked off Consolidation Month (no it’s not actually trademarked) during the month of May. During this time, every product team within Supabase addressed outstanding performance and stability issues of existing features. Here’s a small subset of initiatives and product announcements as part of Consolidation Month:
The newly released @supabase/ssr package improves cookie management, developer experience, and handling of edge cases in various SSR and CSR contexts. We’ve added extensive testing to prevent issues that users experienced with the @supabase/auth-helpers package.
pgvector v0.7.0 introduced float16 vectors that further improve HNSW build times by 30% while reducing shared memory and disk space by 50% when both index and underlying table use 16-bit float. The latest version also adds sparse and bit vectors as well as L1, Hamming, and Jaccard distance functions.
The Edge Functions team has significantly reduced the error rate for functions encountering memory issues by implementing better safeguards. This has greatly minimized errors with the 502 status code. Additionally, status codes and limits are now documented separately.
The Supabase Dashboard is now better equipped to handle your projects, regardless of their size. We have implemented sensible defaults for the amount of data rendered and returned in the Table and SQL Editors to prevent browser performance issues while maintaining a snappy user experience.
Realtime now emits standardized error codes, providing descriptions of their meanings and suggested actions. This enhancement improves your error-handling code and helps to narrow down whether the issue lies with the database, Realtime service, or client error.
We’ve improved the prompt and output of our RLS AI Assistant by including best practices found in our RLS docs and upgrading to OpenAI’s newest GPT-4o. We’ve also introduced numerous test scenarios to make sure you’re getting the right security and performance recommendations by comparing parsed SQL with the help of pg_query.
[Functions] JSR modules are supported in Edge Functions & Edge Runtime [Announcement]
[Functions] Debug Edge Functions with Chrome DevTools [Docs]
[Functions] Use HonoJS web Framework with Edge Functions [Docs]
[Analytics] Log Drains is in Private Alpha [Announcement]
[Realtime] Realtime Authorization Early Access [Announcement]
[Docs] SQL to PostgREST API Translator [Docs]
[Client libs] Supabase JavaScript SDK Sentry Integration now supports Sentry SDK v8 [Commit]
Apr 6, 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.
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.
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.
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.
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.
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.
Mar 1, 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.
We've improved the UX of our Dashboard with sidebars in every section, including the Table view, the Auth section, and the SQL Editor.
Writing SQL just got 10x easier. We added autocomplete to the SQL editor, including table & column suggestions.
Redirect your users to specific route within your site on signIn() and signUp().
We've released a new Resources section in our docs, as well as two new Auth modules: GoTrue Overview and Google OAuth.
Launch your database in South Africa.
Feb 2, 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.
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.
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.
We have exposed the audit trail directly in the dashboard, as well as the GoTrue logs. Great for security and debugging.
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.
auth.email() function#We added a helper function for extracting the logged in user's email address.
Launch your database in London or Sydney!
You can now copy SQL results as Markdown - super useful for adding to blogs and issues.
If you're excited by React Server components then check out the Supabase + Server Components experimental repo. https://github.com/supabase/next-server-components
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:
Jan 3, 2021
After 10 hectic months of building, Supabase is now in Beta.
This is also available as a blog post and a video demo.
We spent months working on Performance, Security, and Reliability. Read more on our Beta Page.
Add comments and descriptions to your Tables directly from our auto-generated docs.
Any updates that happen to your database are reflected in the Table View immediately.
Our table view now has pagination - better for working with large data sets.
We raised $6M from Y Combinator, Mozilla, and Coatue. You can read more on TechCrunch.