Episode 511: Ant Wilson on Supabase (Postgres as a Service)

Data Paradigms

Ant Wilson, co-founder and CTO of Supabase, discusses the differences between Supabase and Firebase, focusing on their underlying data storage paradigms. Supabase uses PostgreSQL, a relational database, while Firebase employs a NoSQL approach, storing data as JSON objects. This distinction allows Supabase to offer more functionality, although it requires users to create schemas, unlike Firebase's more flexible structure 1. Wilson explains that Supabase aims to provide a similar developer experience to Firebase, with features like real-time streams and authentication, but with the added benefits of a relational database 2.

We brand ourselves as the open source Firebase alternative... the main difference obviously, is that it's relational database and not a NoSQL database.

--- Ant Wilson

Supabase's approach is not a direct replacement for Firebase but rather an alternative that opens the door to more advanced functionalities.

   

Developer Experience

Supabase enhances the frontend developer experience by simplifying backend complexities, much like Firebase. Ant Wilson highlights how Supabase allows developers to communicate directly from the client, handling backend tasks such as authentication and real-time notifications 1. This setup enables frontend developers to focus solely on the client side, as Supabase manages the backend seamlessly. Wilson notes that Supabase draws inspiration from tools like Pgadmin and Airtable to create a user-friendly interface, making database management accessible and intuitive 3.

You can communicate with Supabase directly from the client, which is what people love about Firebase.

--- Ant Wilson

By automating API generation and offering a spreadsheet-like interface, Supabase streamlines the development process, allowing developers to concentrate on building engaging user experiences.