Using Supabase for Your Project

If you ask any software developer what makes an amazing app for production, you'll probably get an exceptional answer every time. They will mention some parts more frequently than others. Still, on the top of those lists, you’ll possibly pay attention to report storage, scalability, analytics, authentication, backend, frontend, cache, or a database. As you may have already observed, that listing may be lengthy.

Supabase; Reference: Github

Then, it’s no marvel that their laziness pushes them to look for gear to speed up their process. One category of such tools is Backend as a Service(BaaS) structures. In this article, we’ll discuss two of them – Supabase and Firebase.

What is Supabase used for?

Focusing most effectively on the imperfections of Firebase, humans began looking for an opportunity. And we hit a goldmine! Let us introduce: Supabase, an open-source alternative to Firebase.

Features of Supabase; Reference: DEV Community

The organization raised over $116 million in investments. Some of the arena’s leading buyers resolved to support it, consisting of Y Combinator, Coatue, Mozilla Corporation, and Felicis. Then there are many lone investors too. The Supabase community grows rapidly, achieving nearly 50 000 starts and over 80 000 registered developers on Supabase GitHub at the time of writing.


Supabase gives manufacturing-grade cloud storage that scales to infinity and integrates well with the rest of the environment.

The latest addition to Supabase is serverless side capabilities that scale automatically. Supabase now has nodes in 29 regions worldwide to execute functions toward the customers. Functions runner is created using Deno, a Node.Js alternative, permitting developers to apply JavaScript,  Supabase TypeScript, and WASM.


Supabase is one of the only corporations imparting a PostgreSQL relational database with PgBouncer integrated free of charge. Postgres is one of the world’s most scalable databases, depending on the aid of hundreds of thousands of builders.

Built-in Postgres mechanism, or Row Level Security, is used for access problems and connecting to an authentication machine furnished through Supabase. Supabase additionally offers data-trade listeners over WebSockets to enable subscriptions in real-time.

Local development

Supabase comes with a command line interface (CLI) that uses Docker beneath the hood to bring the equal experience you get from their internet platform to your nearby dev environment. The CLI continues to be under improvement. However, it includes all of the functionalities that had to be implemented along with your Supabase initiatives and the Supabase platform.

The most favored characteristic of the CLI is generating  Supabase TypeScript sorts for the whole database with just one command:

supabase gen types typescript --local > lib/database.types.ts

The  Supabase TypeScript/JavaScript SDK is currently up to date to V2, making improvement easier by offering higher APIs and typings. You can use the supabase-js library to:

  • engage along with your Postgres database,
  • pay attention to database adjustments,
  • invoke Deno Edge Functions,
  • construct login and consumer control functionalities,
  • and manipulate large documents.


Every Supabase project has an entire consumer management device that works with no additional tools. User information is saved to your database in a separate schema, so you never need to worry about third-party privacy problems. Supabase also allows social logins and has an equipped Supabase React native issue library for building consumer authentication interfaces.

What is the distinction between Supabase and Firebase?

Now that we’ve defined how Firebase and Supabase work individually, let us dissect and evaluate each technology and consider whether we should use Supabase over Firebase.

Supabase vs Firebase; Reference: Supabase

Importing preexisting information

With Supabase, we can import a CSV or copy and paste a spreadsheet to kickstart the assignment without difficulty. This is great if we’re migrating information from another platform to Supabase.

Firebase doesn’t provide inbuilt offerings that allow us to add bulk data immediately. The best we can do is find a third-party node script or something comparable which appears hackish. Plus, we must convert our CSV (or any format) to JSON before doing anything.

Supabase Pricing

Supabase is an open-source product, meaning it’s currently accessible. The Supabase pricing team plans to charge fees for website hosting when it's launched. There are also contribution plans for individuals and corporations to help sponsor the product.

Firebase, then again, is not free. The free Spark plan is beneficial, making it an excellent match for side initiatives that don’t generate any severe traffic. Enterprise packages could want to get on the Blaze plan (pay-as-you-go) to get admission to the entire offering, which includes Firebase extensions and extra space for a database and storage.

Relational database vs. NoSQL database

Firebase is a NoSQL database, whereas Supabase is a relational database. The most appropriate database for your project relies on what kind of app you’re building.

Relational databases are useful when data is related, inflexible, and needs to be consistent on every occasion. On the other hand, it is better to apply NoSQL if we've got flexible statistics with unique data types and need to move fast.

Both database kinds have their pros and cons. For instance, NoSQL databases might be repetitive; however, querying the database is fast. That’s why it’s used for search engines like Google and social media feeds. Consistency and overall performance are two massive factors.

Firebase extensions

Firebase gives legit extensions that can assist us in integrating immediately with different relevant offerings like Stripe, Google Play, Algolia, Twilio, Mailchimp, and many others.

Direct integrations like this assist us in limiting paintings and summarizing certain functionalities we’d have needed to implement ourselves if we used Supabase.

Data migration

Information migration is usually a priority when coping with enterprise applications, mainly because the organization scales.

Data migration on a NoSQL database without schema or an ORM, including Firebase, should show hard compared to using a relational database; that's to be had with Supabase. It’s even more difficult while we’re already in manufacturing.

You can download all your data and schema as a .sql file in Supabase from the backup section on the dashboard. Alternatively, you can unload the state-of-the-art information from the command line using pg_dump.

Choosing the proper BaaS heavily depends on your assignment’s functional necessities and increased ability. If you’re constructing a massive assignment, you should do your research to understand the constraints related to each BaaS platform. By doing this, you can avoid technical debt in the future.

Scalability and protection

Considering the above points, both services are relatively scalable. Scalability in this context will now be closely dependent on the design of the app’s statistics structure. Although, the upside that Supabase has, in this case, is mainly across the reality that it uses the Postgres database and its facts migration steps.

Supabase Pricing: Is Supbase free?

This platform is a Firebase alternative that gives many functions, which we advise you to check out on their website as their free plan offers you access to 10 GB of database storage, 10 GB of record storage, and 1 GB of bandwidth every month.

Can I use Supabase as a backend?

Supabase is a serverless, open-source alternative to Firebase constructed on top of the PostgreSQL database. It offers all the backend services needed to create full-stack software.

Open Source Supabase; Source: Marcin Skrzynski’s Blog

As a developer, you can control your database from the Supabase interface, ranging from growing tables and relationships to writing your SQL queries and actual-time engine on top of PostgreSQL.

Supabase has excellent features that make your complete-stack software improvement even less complicated. Some of those capabilities are:

  • Supabase UI – Supabase has an open-source Supabase user management starter library to create applications speedily and efficiently
  • Row-level security (RLS) – Supabase comes with the PostgreSQL RLS feature that permits you to restrict rows in your database tables. When you create guidelines, you create them without delay with SQL.
  • User authentication – Supabase creates an authentication customer's desk as quickly as you create your database. When you create software, Supabase will assign a user and ID when you register at the app that can be referenced within the database. For log-in strategies, there are unique ways you may authenticate customers, inclusive of email, password, magic hyperlinks, Google, Supabase, GitHub, and more.
  • Real-time database – Supabase has a replacement feature on the PostgreSQL database that may be used to listen to real-time changes
  • Edge features are Supabase TypeScript functions disbursed globally at the brink, close to users. They may perform functions, integrate with third-party events, or listen to WebHooks.


It's no secret that the Supabase team built it as an alternative to Firebase; however, as a developer thinking about the usage of Supabase, it's vital to remember its capacity beyond being the “subsequent quality aspect.” If you want to settle for Supabase, it's possibly not the best fit. In truth, Supabase is trying hard to set itself apart.  

As the development crew placed it, “We started Supabase because we love the capability of Firebase; however, we encountered the scaling issues many others experienced. We aim to make Postgres as easy to apply as Firebase, so you should not choose between usability and scalability”. Fortunately, the team isn't always simply replicating what Firebase is doing; they're additionally including a handful of features that Firebase would not have. Plus, it is excellent to see that the crew is relatively lively and asks customers to vote, like for new languages. Still, Supabase is an open-source solution, and it is in its infancy.

How much is a great User Experience worth to you?

Browsee helps you understand your user's behaviour on your site. It's the next best thing to talking to them.

Browsee Product