The open source Firebase alternative.
APACHE-2.0 License
Bot releases are visible (Hide)
Published by kiwicopple about 3 years ago
Did you know it's been 2 years since the first commit to Realtime, our real-time engine for Postgres? Before we even existed as a company!
We spent this month improving docs and content content, improving UX, and onboarding Developer Advocates!
To kick off Hacktoberfest, another Supabase Hackathon is happening right now. You've got another 7 days to be in to win a limited edition t-shirt.
We added support for AbortController in our Javascript library so that you can abort long-running queries. [Docs]
We've made a number of changes to the Dashboard to expose some great features of PostgreSQL including:
We've improved the column Type field so that it supports your custom types.
We've made it simple to add a unique constraint.
By popular request, you can now view all columns in a table at a glance and edit them in bulk.
We updated our grid to support relationships across multiple schemas.
We've revamped the Auth docs - The docs are now broken down into Authentication and Authorization, and organized alongside our Deep Dive series.
Low Code demo, Using Supabase with Clutch.io - @_dijonmusters ran a session at General Assembly showing how to use these two tools together to create apps using a low code approach.
Published by kiwicopple about 3 years ago
We've raised $30M and shipped a bunch of features. Let's dive into what's been happening at Supabase during the month of August.
This is also available as a blog post and a video demo.
We raised our Series A.
We'll use the funds to do more of the same - ship features and hire open source developers.
We'll release more details soon. Read more on TechCrunch.
If you've been waiting for Row Level Security to land in Postgres subscriptions,
then you're going to love our new repo:
Write Ahead Log Realtime Unified Security (WALRUS).
The name might be a bit forced, but the security design is deliberate.
It's not in production yet, but we're making the repo public for comments using an
RFC process.
If you're using SMS login in Auth v2, you can now customize the SMS which is sent to your users. Read more in the docs.
Thanks entirely to @dshukertjr, we now have in-depth reference Dart documentation for CRUD, Auth, Realtime and more!
We added another region for those wanting to host their data and APIs in Seoul. We now have 12 regions to choose from
You can now create columns while creating your table. We've also added improvements for composite primary keys and foreign key creation.
Our previous importer would choke on CSV files which were too large. Not any more!
We now provide a handy copy utility for various database connection strings because we were so tired of looking them up on Stack Overflow.
RLS can be a bit foreign for developers getting started with Postgres.
This video by @_dijonmusters demystifies it. If you find the video a useful medium for learning, consider subscribing to our channel.
https://www.youtube.com/watch?v=Ow_Uzedfohk
Published by kiwicopple about 3 years ago
Supabase is gearing up for another Launch Week on July the 26th. Until then, here's a few new things to try.
This is also available as a blog post and a video demo.
Following the success of our first Launch Week in March, we finished the July with "Launch Week II: The SQL".
The community has been sieving through a slew of bad puns and retro memes to discover the new feature announcements.
Your users can now log in with SMS based mobile auth! We have a Twilio integration (Guide Here) and will be adding more providers soon.
Other Auth updating include, Twitch logins, and the ability to generate invite, recovery, confirmation, and magic links via the API,
for people who want more control over the email templating flow. Read the blog post here.
Storage updates include Media Streaming, Public Buckets, Directory Uploads, and a Performance Improvements.
Streaming Media in particular opens up a whole new host of potential use cases, learn more about the updates here.
We made some major new additions to the dashboard including usage statistics, a new project home, and tons of database insights.
Check the post here on what you get and how we built it.
All new Supabase projects will be launched with PostgreSQL 13.3, and we're working on a migration path for old projects.
This gives you looooaads of new stuff out the box.
We worked with our friends at PostgREST to make some huge improvements.
For those of you who don't know, every Supabase instance comes with a dedicated PostgREST server by default,
which provides the auto-generated CRUD API that we wrap with supabase-js
.
Our community driven libs for the fasted growing mobile and web framework are now in beta. Learn more by following the Quickstart guide.
We made an announcement on the progress of functions, and even shipped a few preliminary components, try them out and give us feedback as we continue to move towards this next major milestone.
Read the latest updates here.
Published by kiwicopple over 3 years ago
Supabase is gearing up for another Launch Week on July the 26th. Until then, here's a few new things to try.
This is also available as a blog post and a video demo.
Vercel just released their new integrations, which means you can now deploy a Postgres database on Supabase directly from your Vercel account.
Check it out! vercel.com/integrations/supabase
Building a community? There's almost no better tool than Discord (we're even trialling it ourselves).
If you're building a community product, Discord logins are the perfect option.
We spent the month building up a new Guides section in our Docs. Here are a few highlights:
Ever wanted to build a Search Engine? We just released a guide which shows you how to implement
Full Text Search using Postgres.
We released step-by-step guides to help you set up OAuth with
Apple,
Bitbucket,
Facebook,
GitHub,
GitLab,
Google, and
Twitter.
Did you know that you can use Javascript inside your Postgres database? Here's how, with the
plv8
extension.
Want to share all your favourite memes? Now it's even easier with Public Storage Buckets. Simply mark a bucket as
"Public" and the content will be accessible without a login.
Supabase Storage now supports upsert
. Shoutout to @ankitjena for
this Pull Request.
When things go wrong, sometime the best thing you can do is reboot. We released a restart button in the Dashboard,
the first of many debugging tools we'll be releasing over the next few months.
We added a new Table Policy Editor which makes Row Level Security even easier. We even included a few templates to get you started.
Published by kiwicopple over 3 years ago
Apple & Twitter Logins, Supabase Grid, Go & Swift Libraries. Lots of great stuff to try out this month.
This is also available as a blog post and a video demo.
Did you know: if you ship an app to the App Store with any third-party logins, you're required to enable Apple logins as well? Now you can with Supabase Auth.
You can also use Twitter as an OAuth provider with Supabase Auth. Twitter has a very archaic OAuth impletementation, so this one took awhile.
We shipped a new Policy Editor for managing Row Level Security on your Storage. We provide some templates to simplify the process for new developers.
We are still working on Open Sourcing our Dashboard, and took another step closer by publicly releasing a new Supabase Grid. It's not ready to use outside of the Supabase ecosystem, but over time we hope to make it usable with any Postgres Database.
There are a huge number of Supabase developers in Japan and China, and at their request we've launched Tokyo as a region.
You can now retrieve your data as Comma Separated Values. Thanks to @andreivreja for the awesome PR.
The community started developing the Go libraries. postgrest-go is completed, @Yusuf_Papurcu and @muratmirgun are working on the remaining libraries.
The community started developing the Swift libraries too. @satishbabariya is making huge progress on storage-swift
, gotrue-swift
, realtime-swift
, and supabase-swift
.
Published by kiwicopple over 3 years ago
This month was a "gardening" month for Supabase. The team focused on stability, security, and community support.
Check out what we were working on below, as well as some incredible Community contributions.
This is also available as a blog post and a video demo.
We're a developer tool, which means that Dark Mode is extremely popular.
While Dark mode is great, for some people it's not an option. Dark Mode is difficult to use for developers with astigmatisms,
or even just working in brightly-lit environments.
So today we're shipping Light Mode. Access it in the settings of your Dashboard.
With the help of the community, we started internationalizing our main repository:
We released Storage Api docs built using OpenAPI (swagger).
We open-sourced a server which keeps any Postgres database in sync with Stripe.
This is experimental only. We're evaluating other tools such as Singer,
which provide a more general solution (but are less "realtime"), and we're opening it up here to gather feedback.
Published by kiwicopple over 3 years ago
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.
Published by kiwicopple over 3 years ago
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.
Published by kiwicopple over 3 years ago
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()
functionWe 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:
Published by kiwicopple almost 4 years ago
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.
Published by kiwicopple almost 4 years ago
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.
You can now add users manually from your dashboard.
You can also perform admin functions on existing users - send password reset emails, magic links, and delete users.
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.
We added a Status Page which tracks the uptime and latency of the Supabase platform.
Published by kiwicopple almost 4 years ago
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.
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.
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.
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.
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.
Published by kiwicopple about 4 years ago
This is also available as a blog post.
We've released OAuth logins! You can now enable third-party logins on your app for Bitbucket, GitHub, GitLab, or Google.
You can duplicate your tables, just like you would inside a spreadsheet.
Extensions are easier to use. You can enable Postgres extensions with the click of a button.
The SQL editor now stores your query history in your browser. You can also save your favorite queries to run later!
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.
gotrue-js
TypeScript library for interacting with Netlify's GoTrue server. This will soon be bundled into supabase-js
postgrest-js
library to TypeScript, and it will soon be bundled into supabase-js
Published by kiwicopple about 4 years ago
This is also available as a blog post.
We're 6 months into building our hosted database platform and we've made some major improvements to our auth system and table view.
Set up tables and columns directly from the table view.
You can now invite team members to your organisation.
You can now enable Email Confirmations for new users. This can be toggled on or off and the template for this email can be edited via the dashboard.
The biggest communty contribution to date, @thorwebdev added Typescript support to Supabase. He even live streamed the process.
We have a number of small improvements:
Published by kiwicopple about 4 years ago
This is also available as a full blog post with videos.
After 5 months of building, we're releasing one of our most anticipated features: Supabase Auth.
This month, we're ecstatic to announce a feature we think you'll love: Supabase Auth. It's too big to fit into a monthly update so look out for a full update in the next few days.
We want to make it easy to get started adding Auth to your app, so we've released a simple example and a video tutorial which shows you how to implement a basic auth system using PostgreSQL's Row Level Security.
We've made some massive improvements to our Table Editor that we're excited to share.
Last month we made it easy to drill into your table relationships. This month, we make it possible to drill multiple levels deep.
We're making it easier to manipulate your data. Next month, you'll be able to add and remove columns directly from the Table view.
If you launch a new Supabase project, you'll have access to several new Postgres extensions:
We have a number of small improvements:
or
filter to the client library
Published by kiwicopple over 4 years ago
This is also available as a full blog post with videos.
We're now 4 months into building Supabase, which means another major update. Here's a few things we think you'll love in this release.
We're sometimes asked how we will make Postgres as simple as Firebase, since Postgres is a relational database. This month we're making our first steps to prove that relational databases can be even easier to use than document stores. We're releasing an excel-like editing interface which can drill down into your relational data.
Postgres is an amazing database, giving the flexibility of a document store with the power of a RDBMS. If you use JSON
data in Postgres, then we want to make that easy too. Supabase detects when your column is JSON
or JSONB
, and provides an easy way to edit and view your data. More improvements coming soon for this feature!
If you noticed a bit of latency on Supabase, it's because your projects were previously set up in Singapore. It was always our intention that you'd be able to choose your database region, and this month we've delivered it. In the next releases we'll even allow you to go multi-region, instantly replicating your database close to your customers.
A guiding principle at Supabase is zero lock-in. So this month we are exposing your daily database backups on the dashboard, giving you a simple way to migrate off Supabase. We have a lot more to build in this space (WAL-G!
), so watch this space.