DEV Community: Supabase

Supabase October 2021 Updates

Supabase — Mon, 08 Nov 2021 13:24:40 +0000

Three new Auth providers, multi-schema support, and we're gearing up for another Launch Week.

Let's dive into what's been happening at Supabase during the month of October.

Quick Demo

Slack, Spotify, and MessageBird logins

Thanks to @HarryET and our friends at MessageBird
we have 3 new Auth providers this month: Slack, Spotify, and MessageBird phone logins.

Multi-schema support

Dashboard

Browse data in any database schema using the Schema switcher in the Dashbaord.

API

You can access any schema with your API, after enabling access in the Dashboard.
Docs.

Fresh Docs and Guides

We have a TON of new guides, with videos too.

Database Functions

Learn about PostgreSQL Functions. Docs.

Auth Overview

Learn about all the exciting feature of Auth within Supabase. Docs.

API Features

Learn more about the power of PostgREST for RESTful APIs. Docs.

And more

Redwood Quickstart: https://supabase.io/docs/guides/with-redwoodjs
Expanded Self-hosting: https://supabase.io/docs/guides/hosting/overview
Expanded Auth Reference docs with serverside functions.
"Before you launch" checklist: https://supabase.io/docs/going-into-prod

Community

There was a lot of activity this month.

Supabase at Jamstack conf

Supabase attended the Jamstack conf. Watch us catch up with Matt, the cofounder of Netlify (minute 8).

Supabase at Next.js conf

And Jon made a guest appearance at this year's amazing Next.js Conf.

Community Highlights

Vue 3 | Workout Tracker App - John Komarnicki video
Adalo + Supabase - Flywheel Media video
Nuxt 3 Beta + Supabase - BenCodeZen video
Made With Supabase (now on Nuxt 3) - Zernonia site
Nuxt 3 + Tailwind + Supabase - Ekene Eze video
SQL Functions - Răzvan Stătescu article
supabase-py v0.0.3 released - repo
nuxt-supabase v2.2.1 released - repo
vue-supabase v2.2.3 released - repo

GitHub

We hit 20K stars!! 21,268 to be exact: github.com/supabase/supabase

Source: repository.surf/supabase

Check out some of our other community stats in our latest Series A Blog Post.

Coming Next: Launch Week III

We had Launch Week numero uno in March, and the sequel "Launch Week II: the SQL" in July.

Now we're going even bigger with the third instalment: Launch Week III: The Trilogy. Join us on 29th November on our Discord.

Supabase June Release 2021

Supabase — Wed, 07 Jul 2021 09:31:12 +0000

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 integration

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

Discord logins are now available

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.

New Guides

We spent the month building up a new Guides section in our Docs. Here are a few highlights:

Postgres Full Text Search

Ever wanted to build a Search Engine? We just released a guide which shows you how to implement
Full Text Search using Postgres.

OAuth Guides

We released step-by-step guides to help you set up OAuth with
Apple, Bitbucket, Facebook, GitHub, GitLab, Google, and Twitter.

Javascript + Postgres

Did you know that you can use Javascript inside your Postgres database? Here's how, with the plv8 extension.

Public Storage Buckets

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.

Storage upserts

Supabase Storage now supports upsert. Shoutout to @ankitjena for this Pull Request.

Server restarts

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.

Policy editor

We added a new Table Policy Editor which makes Row Level Security even easier. We even included a few templates to get you started.

Build in Public

We run a weekly 1-hour live stream where we build in public.

Build in Public 003: Redwood PR, GitHub Discussions, Pricing Pages, Postgres Policies, Styling docs
Build in Public 004: Svelte Quickstart, new supabase-js release, monthly GitHub release
Build in Public 006: Supabase Studio
Build in Public 007: Supabase Studio - API Docs

Community

@dabit3 released a complete guide to Supabase on FreeCodeCamp. Twitter | Blog
@raddevon built a social network using Supabase and Vue3. Twitter | YouTube
@JonoYeong built live with Supabase + SvelteKit. Twitter | Twitch

If you want to keep up to date, make sure you subscribe to our YouTube channel or follow us on Twitter.

External contributions

PostgREST

Primarily for Prisma users, we patched PostgREST openapi-mode to ignore anon privileges for the OpenAPI output. Credit to @steve-chavez.
We added better PostgREST logging to include timestamps for every error Credit to @steve-chavez.

Auth0

We fixed a XSS bug in the Auth0 Next.js library. GitHub Credit to @inian and Ishan Patel (a Supabase community member)

Coming Next

Launch Week!! Remember that time we did a Launch Week? Well we're doing it again at the end of July.
Strap in, because we're shipping one thing every day for a week.

Let's goooooo.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Subscribe to our YouTube channel
Become a sponsor

Angels of Supabase

Supabase — Fri, 26 Mar 2021 07:46:52 +0000

Supabase is an open source Firebase alternative. We're on a mission to build an incredible developer experience around
the world's best open source tools.

To build an amazing developer experience, we need developers to guide us. So after finishing Y Combinator, we took a
deliberate approach to fundraising. We loaded our Seed round with developers, technical founders, and developer advocates:
CTOs who have seen scale, community managers, and hackers. We amassed over 20 angel investors - almost all technical.

The Supabase Team is at full capacity preparing for Launch Week and since we're all short on time we decided -
why not ask our Angels to write a fundraising post with us?

So here is our unconventional fundraising announcement, written with a few of the Angels of Supabase.

Mike Krieger (Instagram)

Cofounder & CTO of Instagram. @mikeyk

How many hours per week do you spend coding?

~30 these days

Why did you invest in Supabase?

Supabase is building tools that are foundational to almost any interactive, modern app, and doing so in a way that's
really aligned with how I think of building tech stacks. For example, choosing Postgres (and deeply understanding
Postgres' features) as the underlying datastore.

Do you write SQL in uppercase or lowercase?

Uppercase but I'm coming around to lowercase!

What was the first program you wrote and what was it written with?

A website that I built so I could skip out on writing a school paper instead — HTML and Image <map>s for interactivity.

What's the worst programming error you've ever made?

On launch day for Instagram, the site was down for a good chunk of time because we hadn't set a favicon.ico and
we had Django set up to email us on all errors. Cue storm of email sends every time someone loaded our homepage…and a very unhappy web server.

If you could only use one programming language for the rest of your life, what would it be?

Python — though I am very intrigued by Rust.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Stay curious and don't feel like everything you build has to be "the next big thing"; so many times I've worked on a
fun side project or exploration and ended up learning something I applied to more "serious" work.

Cassidy Williams (Netlify)

Principal Developer Experience Engineer at Netlify. Outside of that, makes memes, classes, talks, and content for
developers. @cassidoo

How many hours per week do you spend coding?

Probably around 20, depending on the week. Sometimes more!

Why did you invest in Supabase?

It's a good tech stack and a tool that I think fills a need for a lot of folks.

Do you write SQL in uppercase or lowercase?

Uppercase!

What was the first program you wrote and what was it written with?

I started making websites as a teenager, and programmed my graphing calculator with good ol' BASIC!

When was the first time you used a computer and what did you do with it?

Oh I was a kid, and definitely used it only for CD-ROM games in those dial-up days.

Would you rather fight 100 duck-sized horses or 1 horse-sized duck?

100 duck-sized horses, because I'm a weakling and could probably do better with the smaller things as long as
they aren't too organized.

If you could only use one programming language for the rest of your life, what would it be?

Probably JavaScript. It's gotten to that level of power that I could apply it to almost anything.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Get a calendar you'll actually use and stick to your to-do lists!

Thorsten Schaeff (Stripe)

Helps developers grow the GDP of the Internet as a Developer Advocate at Stripe. @thorwebdev

How many hours per week do you spend coding?

Really depends on the projects I'm working on. Sometimes I spend a good amount of time making videos.

Why did you invest in Supabase?

The team | The Culture | The DX

Do you write SQL in uppercase or lowercase?

lowercase - I prefer not to scream at my DB.

What was the first program you wrote and what was it written with?

My first proper project was probably at uni, building an app to alert wind surfers of great wind conditions.
Was built with Python on a Raspberry Pi, jQuery and PhoneGap

When was the first time you used a computer and what did you do with it?

When I was 9 years old my dad signed me up for an HTML summer camp. That's how it all started :D

Would you rather fight 100 duck-sized horses or 1 horse-sized duck?

I think there's a market for duck-sized horses. Would capture and sell them. Also duck's have some nasty claws,
wouldn't be a good idea to make them bigger!

If you could only use one programming language for the rest of your life, what would it be?

I'd do anything and everything in TypeScript if I could!

If someone wanted to do what you do, what's a piece of advice you'd give them?

Get involved with and start contributing to open-source. Start creating content about your open-source contributions,
and I'm certain that it will pay off!

Brian Douglas (GitHub)

Staff Developer Advocate at GitHub. @bdougieyo

How many hours per week do you spend coding?

~10 hours a week.

Why did you invest in Supabase?

Supabase is scratching an itch for me as a developer. I see the value of having a manageable database based on SQL,
but I don't only have limited time to code during the week and I don't want that to get sucked into the maintenance
and management of that data. I also was a big Firebase fan, and love the developer ergonomics if offered to me as an early user.

Do you write SQL in uppercase or lowercase?

Always uppercase, but don't ask me what the acronym stands for.

What was the first program you wrote and what was it written with?

The first function programming was an Android app in Java that was just a picture of a cat. When you pet the cat it purred,
it was part of an Android tutorial when I thought I wanted to be an Android dev. I later got an iPhone and decided to never
write Java again when I found Ruby on Rails. I built a Yelp clone for churches, but bailed on that when I took a full time dev role.

When was the first time you used a computer and what did you do with it?

My first time using a computer was in second grade and it was to play wolfenstein. We had a computer that we could use in
the office of the apartment complex I grew up in. One of the older kids installed the game and showed the other kids how
to run in from powershell. Probably not the best game to introduce to a 7 year old, but here we are.

If someone wanted to do what you do, what's a piece of advice you'd give them?

I would tell them to start with creating short form content every day. It easier to make content on things you just
learned, so do that. It is also easier to get hired when you already have content.

Justin Gage (Retool)

Growth at Retool. Writes a newsletter that helps people understand software engineering and tech.
@itunpredictable

How many hours per week do you spend coding?

It depends – some weeks I’m mostly writing and coordinating, other weeks I’m writing a lot of code. Lets say 20 hours on a good week :)

Why did you invest in Supabase?

I had been working on the Firebase integration at Retool for a bit, and kept wondering why it was (a) closed source
and (b) NoSQL only. Over the span of a week, something like 5 or 6 of my developer friends asked me what I thought
about Supabase, so I checked it out – after using the product for a side project, investing was an easy decision.

Do you write SQL in uppercase or lowercase?

Lowercase, obviously. I wrote thousands of queries when I worked at DigitalOcean, and we didn’t have time to capitalize things.

If you could only use one programming language for the rest of your life, what would it be?

SQL (particularly standard Postgres syntax) is the best language on the planet. Fight me.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Eh, I can’t really give advice, I haven’t figured anything out myself yet!

Iheanyi Ekechukwu (PlanetScale)

Senior Software Engineer at PlanetScale. @kwuchu

How many hours per week do you spend coding?

Pretty much, the majority of my week is spent coding. I'd say realistically, around 30-ish hours a week or so.

Why did you invest in Supabase?

The tagline about Supabase being an "open-source Firebase alternative" had me intrigued. As I looked more deeply into
the product, I was impressed by the well-thought out design and also how easy it is to use the product as well.

Do you write SQL in uppercase or lowercase?

Uppercase.

When was the first time you used a computer and what did you do with it?

During summers as a child, my dad would take me to work with him at the community college he taught at. I'd be sitting
in his office while he was in lectures and actually just use his computer to play that 3D Space Pinball game. I think
I was 5 or 6 years old at the time.

If you could only use one programming language for the rest of your life, what would it be?

Honestly, I would probably choose Go. It's a pretty dope language for building out systems.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Always be learning. There's so many things to learn as an engineer and the job is constantly about learning new things.
Never settle, never get comfortable, learn as much as you can consistently.

Zach Waterfield (On Deck)

Engineer at OnDeck, Network Leader at Village Global, Founder of Kopa (W19). @zlwaterfield

How many hours per week do you spend coding?

Anywhere from 10 to 50 depending on the week

Why did you invest in Supabase?

I have many ideas, and spinning up a backend, db, etc., is so daunting, so I started using Firebase, but it was very
frustrating. When I saw Supabase I instantly knew that was the solution. The ability to use Postgres directly from the
client with authentication built-in was a game-changer. I think it could become the go-to that early-stage companies
build on to simplify their MVPs.

Do you write SQL in uppercase or lowercase?

UPPERCASE

When was the first time you used a computer and what did you do with it?

Weirdly enough, I didn't own a computer until I was in grade 12 and didn't learn to code until I was in University.
I was the only one in a class of 400+ freshman engineers that had never coded before.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Network, network, network. Everything I do and all my successes are based on my network. Whether that be from YC, my
university peers, OnDeck, Twitter, etc. Focus on building your network, and good opportunities will start to pop up.

Shawn Wang (Temporal)

Head of Developer Experience at Temporal. @swyx

How many hours per week do you spend coding?

Why did you invest in Supabase?

I was extremely impressed by the founders and love the idea of offering a beautiful, integrated developer experience atop
of proven, scalable, open source foundations.

Do you write SQL in uppercase or lowercase?

Uppercase if formal, lowercase if lazy!

What was the first program you wrote and what was it written with?

We had a computer class in middle school and we were assigned to write a pancake stacking program in BASIC. I was really
obsessed by it and was the only person to submit this assignment complete with a graphical user interface (in BASIC!).
Sadly I didn't see myself as a programmer until 20 years later.

If someone wanted to do what you do, what's a piece of advice you'd give them?

Learn in Public :)

By the way

We raised a $6M seed
round led by Coatue, Mozilla, and YC.

Next week is Launch Week and we'll be launching one new thing every day for a week.

Check it out!

Supabase: ten months of building.

Supabase — Sun, 03 Jan 2021 18:22:39 +0000

Supabase is an open source Firebase alternative. We're building the features of Firebase using enterprise-grade open source tools.

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.

Community

We were featured on the GitHub release radar. Link
@kiwicopple appeared on Open Core Summit
@aaronksaunders created a video series on Supabase + Vue. Link.
@CodeByCorey tracks realtime page views using Supabase. Link.
@ffbass started working on gotrue-java. Link.
We've grown more than 50% (GitHub star count) since moving into Beta. Link

If you want to keep up to date, make sure you subscribe to our YouTube channel or follow us on Twitter.

Coming next

We've go a lot of exciting things planned for Q1 2021. We're already planning out Supabase Storage and a Supabase CLI for better local development. Let us know if there's something you want us to release as a priority!

We also have something exciting planned with Vercel and Stripe ... stay tuned.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Supabase: nine months of building.

Supabase — Tue, 01 Dec 2020 04:01:44 +0000

Supabase is an open source Firebase alternative. We're building the features of Firebase using enterprise-grade open source tools.

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.

Community

We had a crazy month during Hacktoberfest. In case you missed it, here are some of the highlights:

We have an exciting Vercel x Stripe x Supabase collaboration underway.
@elrhomariyounes started helping @acupofjose with the postgrest-csharp extension
@duncanhealy is updating the Redwood example to work with Supabase.js v1.0

If you want to keep up to date, make sure you subscribe to our YouTube channel or follow us on Twitter.

Coming next

Look out for a big announcement on December 3rd. We'll also be presenting in the Open Core Summit on the 16th of December.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Supabase: eight months of building.

Supabase — Tue, 03 Nov 2020 05:38:45 +0000

Supabase is an open source Firebase alternative. We're building the features of Firebase using enterprise-grade open source tools

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.

Community

We had a crazy month during Hacktoberfest. In case you missed it, here are some of the highlights:

@kiwicopple chatted to Jeff on the Software Engineering Daily podcast.
Tezos started using our PostgREST libraries for their blockchain API: https://pro.tzkt.io/
Supabase hosted a Hacktoberfest meetup.
@kiwicopple appeared on the Open Sauced channel with @bdougieYO
@thorwebdev shows the Engineers.sg group how to build a realtime Slack clone with Supabase

If you want to keep up to date, make sure you subscribe to our YouTube channel or follow us on Twitter.

Coming next

Our focus is still moving from Alpha to Beta and we'll be improving stability, reliability, and performance. Our Supabase.js 1.0 launch was part of that, and we've created a Benchmarks repository where we'll be measuring the performance of all the open source tools we use.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Subscribe to our YouTube channel
Become a sponsor

Supabase: seven months of building.

Supabase — Thu, 08 Oct 2020 05:29:49 +0000

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 into supabase-js
We migrated our postgrest-js library to TypeScript, and it will soon be bundled into supabase-js

From the community

@kiwicopple appeared on GitHub's Twitch channel for Open Source Friday with @mishmanners
@kiwicopple discussed pricing for Open Source with GitLab CEO Sid Sijbrandij
@thorwebdev presented Supabase Auth at the SingaporeJS meetup
realtime-py is underway thanks to @lionellloh & @j0
postgrest-dart was shipped by @phamhieu
postgrest-csharp is being implemented by @acupofjose

Hacktoberfest

There's been plenty of drama during Hacktoberfest, but Supabase is committed to helping new contributors get started with open source. We've already seen a lot of issues closed by new members to our community and first-time contributors. If you're looking for ways to get involved, read our Hacktoberfest blog post, check our our live stream, and then dive into our project board.

Coming next

Our focus now is to move from Alpha to Beta and we'll be improving stability, reliability, and performance. We've create a Benchmarks repository, where we'll be measuring the performance of all the open source tools we use.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Supabase: six months of building.

Supabase — Mon, 07 Sep 2020 03:45:17 +0000

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.

Easily create tables

Set up tables and columns directly from the table view.

Invite your team

You can now invite team members to your organisation.

Auth: Email Confirmations

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.

Typescript support

The biggest communty contribution to date, @thorwebdev added Typescript support to Supabase. He even live streamed the process.

Kaizen

We have a number of small improvements:

supabase-js now has UMD support
We significantly improved our docs. Try out the new search!
All of our awesome sponsors are now listed on our OSS page.

From the community

The release of Auth last month accelerated our community growth, based on Orbit Levels.

We received our first enterprise sponsor. Thanks to @briannekimmel from @WorkLifeVC for becoming an Enterprise Sponsor.
@amorriscode added Redwood support! [Pull Request]
@swyx trying out Supabase with Color Search Engine with Supabase [Live Stream]
Python Support: @lqmanh has agreed to lead the python support. He's already deployed postgrest-py which is the first step towards a functioning supabase-py client lib.
@phamhieu built a Live Map Tracker App using Supabase + Leafletjs

Coming next

Our focus now is to move from Alpha to Beta. This involves stabilising our Auth API, improving dashboard performance, and benchmarking all of our systems. This could take more than one month, as we have a number of company-related activities to wrap up (we just finished YC!).

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Quick Demo! Five months of building.

Supabase — Wed, 05 Aug 2020 10:50:45 +0000

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.

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 add Auth to your own apps, 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.

Table Editor

We've made some massive improvements to our Table Editor that we're excited to share.

Relationship drill down

Last month we made it easy to drill into your table relationships. This month, we make it possible to drill multiple levels deep.

Add, delete, and download rows

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.

New Postgres Extensions

If you launch a new Supabase project, you'll have access to several new Postgres extensions:

pgsql-http: HTTP client for PostgreSQL, retrieve a web page from inside the database.
pgjwt: PostgreSQL implementation of JSON Web Tokens
plpgsql_check: a linter tool for language PL/pgSQL
pljava: write Java in your stored procedures, triggers, and functions

Kaizen

We have a number of small improvements:

Added Auth documentation to the auto-generated docs in each project
Added a new or filter to the client library
Table View now remembers which tabs you had open.
We have released a lot of new functionality to pg-api, a server for for managing Postgres internals via a REST interface.
Performance: the "flash of black" which was appearing on page transition is now gone

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Create a Slack clone with Next.js and Supabase

Supabase — Fri, 31 Jul 2020 07:35:41 +0000

In this post we're going to show you how to deploy a fully functional Slack clone in less than 2 minutes.

See the final result here: https://supabase-slack-clone.vercel.app/

(☝️ You should probably use a fake email when you sign up)

Intro

The video shows all the steps so in case you haven't already watched it, here's what you need to know!

This is a real-time Slack clone built with Postgres' Row Level Security. It's a simple POC, and you can deploy your own, which takes a few minutes. The database, auth, real-time, and APIs are handled by Supabase, which is an open source Firebase alternative. The front end is built with Next.js, deployed on Vercel.

Show me how

You can also find these instructions in the project repo.

1. Create new project

2. Run "Slack Clone" Quickstart

Once your database has started, run the "Slack Clone" quickstart.

3. Get the URL and Key

Go to the Project Settings (the cog icon), and find your API URL and anon key.

4. Deploy the front end

Click this button to deploy the front end:

You will be asked for a NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_KEY. You can use the keys in step 3.

Conclusion

Congrats! You just deployed a functioning Slack clone, without writing a line of code. Feel free to hack the frontend and share your own slack URL in the comments.

Quick Demo! Four months of building.

Supabase — Thu, 02 Jul 2020 02:10:50 +0000

This is also available as a full blog post with videos.

We're now 4 months into building Supabase, which means another major update. Let's check out a few thing we think you'll love in this release.

View relational data

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.

Manage JSON 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!

Choose your region

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.

Backups

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.

Get started

Start using Supabase today: app.supabase.io
Make sure to star us on GitHub
Follow us on Twitter
Become a sponsor

Quick Demo! Three months of building.

Supabase — Mon, 01 Jun 2020 11:24:37 +0000

It has been a monster month at Supabase and we're back with a video update. It's a longer video this month because we have a couple of housekeeping items.

Housekeeping

We got into Y Combinator 🎉. The cohort has just started and it's fully remote so it will be a unique experience, even by normal YC standards.

Normally we wouldn't mention this until our official YC launch in September but the cat's out of the bag since @vira28 posted about us on Hacker News.

We've seen a huge response from the tech community. We're still 'very alpha' so the attention may have been better in September but everyone has been patient with the bugs and instability. It just goes to show: ship early and often because nobody knows when you might get picked up.

Updates

OK now for the important part - as promised, we will continue to release our updates here in the DEV community first. Skip to 1m18s in the video if you just want to see what we've been up to.

Fresh UI

We've revamped the UI to fit in some more features that we're building.

Table View

This one is still very unstable, but we wanted to ship it anyway. It's a little hidden away so you'll have to hunt for it :). Give us a couple of months and we promise this will be as good as (better than?) Airtable.

And more

⚡ Realtime listeners! Subscribe to your database just like you would with Firebase.
🤖 Instant RESTful APIs that update when you update your schema. Supabase introspects your schema and updates your API and documentation.
📓 Auto-documentation for your APIs and Postgres schema. What's better than documentation? Documentation that you don't have to manually keep up to date.

We'll announce all our future features with more freebies here on DEV first. Follow us so that you don't miss out.

And make sure to star us on github!
https://github.com/supabase/supabase