Supabase is an open source Firebase alternative. A service to:

- Listen to database changes.
- Query your tables, including filtering, pagination, and deeply nested relationships (like GraphQL).
- Create, update, and delete rows.
- Manage your users and their permissions.
- Interact with your database using a simple UI.

Supabase is not a 1-to-1 mapping of Firebase. Most notably, Supabase uses Postgres rather than a NoSQL store. 

supabase

Learn Supabase

[Supabase](http://supabase.com?utm_source=egghead&utm_campaign=remix) is a collection of open-source tools that wrap around a PostgreSQL database. In this course, we look at building a realtime chat application with Remix, using Supabase for db hosting, authentication, authorization and subscribe to realtime db events - updating the UI as the database changes.

We will learn about:

- loaders and actions in Remix
- querying and mutating data with Supabase
- authentication with GitHub
- authorization with RLS
- merging client and server state with realtime events
- deploying a Remix app to Vercel

This course is 100% TypeScript, however, don't stress if you don't have any experience with TS, as Supabase does most of the heavy lifting here! 🎉

TypeScript is a typed superset of JavaScript that compiles to plain JavaScript.

typescript

Build a Realtime Chat App with Remix and Supabase

The “Edge” is where you write and store your code where your data is being produced. This allows for a quick and efficient data transfer, eliminating or severely reducing lag. 

Supabase is a suite of open-source tools wrapping a PostgreSQL database. It provides the building blocks of an app - database hosting, auth, file storage, real-time, and edge functions - so we can focus on what makes our app unique.

Cloudflare Workers are serverless functions that run at the Edge! In this course, we will use the Wrangler CLI tool for interfacing with your Cloudflare account and creating or publishing your Workers.

KV Storage is a cache that Cloudflare makes available to our Workers. It replicates across multiple CDN nodes, making it super performant to cache data.

Combined, these three things give you the benefits of that reduced lag in a smooth and streamlined process. 

Throughout this course, Jon will teach you how to create a small blog that hits the key points of how to:

- Query Supabase from Cloudflare Workers
- Read and write KV Storage cache from Cloudflare Worker
- Cache Supabase response at the Edge with KV storage

And more! 

Cloudflare secures and ensures the reliability of your external-facing resources such as websites, APIs, and applications. It protects your internal resources such as behind-the-firewall applications, teams, and devices. And it is your platform for developing globally-scalable applications.

cloudflare

Cache Supabase data at the Edge with Cloudflare Workers and KV Storage

For your frontend, this application will be using Next.js and Tailwind CSS. You will learn how to maneuver around an app and build a strong static pricing page. 

For your backend AND authentication, we will make use of Supabase. Supabase is open source and is all of the backend services that you will need to build your site. It includes a dedicated and scalable Postgres database and user management with Row Level Security! 

Lastly, for payments, you will be using Stripe. It will be an individual payment checkout system that will create and update users' subscriptions. 

Jon will take you through all of this and more in just 1 hour and 10 minutes!

Build a SaaS product with Next.js, Supabase and Stripe

Supabase is an open-source tool for rapidly building application backends with real-time data and authentication. In this course, you'll learn the fundamentals of Supabase. You'll learn how to model complex data using PostgreSQL and SQL, build authentication flows with Oauth, and add real-time data to a Next.js application to build a fully-featured chat application, similar to Discord.

The chat app will have different "channels," which will be powered by data inside of Supabase. Users can visit these channels and write messages, which will be sent in real-time to other current users of the platform.

After this course, you will be able to model real-world scenarios in actual relational databases, understand how to manage real-time data, and leverage key functionality provided by Supabase, such as authentication, instant APIs, and real-time subscriptions.

Build a Real-Time Data Syncing Chat Application with Supabase and Next.js

In this lesson, we'll use Cloudflare Workers to deploy a serverless workflow using Supabase. In doing so, we can query and update our data via the Supabase API separately from our client application.

Building Supabase Serverless Workflows with Cloudflare Workers

In this lesson, we'll deploy our final application to Cloudflare Pages, and show how to correctly configure your Supabase application to be used by real users in a production environment.

Deploy a Supabase Application to Production with Cloudflare Pages

Using the previous implementation, in this lesson we will retrieve the user name for each message as needed in our user interface and subscribe to updates. 

Retrieve and Displaying User Details with User Subscriptions

As you add to your application, you'll begin to build complex state representations that need to be managed. In this lesson, we'll manage a user store representing all the users in our chat application.

Request User Details for a Given User Using Supabase's API

In this lesson, we'll take everything we've learned about querying, inserting, and updating data in our Supabase project and apply it to a fully-featured application: a chat service similar to Discord.

Keep Track of the Current User Using Next.js with Supabase

In this lesson, we'll learn how to insert new data into our Supabase database. To do this, we'll allow user data to be submitted from our chat application, which will be sent to Supabase via the API.

Insert Submitted Data to Supabase Tables

In this lesson, we'll look at patterns for enabling real-time on individual tables using the supabase_realtime publication function. 

Enable Realtime Only for Individual Tables using supabase_realtime

In this lesson, we'll improve on our simple API request to Supabase by turning it into a subscription: a live-updating query that automatically subscribes to any new or changed data in our database. 

Subscribe to Database Changes using Supabase's Realtime Client

In this lesson, we will run raw SQL in supabase over the user table to understand the relationship between users and other information captures from the authorization in our user's table.

Executing Raw SQL using Supabase's Interface

In this lesson, we'll integrate the GitHub provider to allow the users to log in with their GitHub credentials. We'll also build the UI for this authorization, which will take us to the third-party provider.

Set up GitHub Authorization with Supabase

In this lesson, we'll integrate supabase into a traditional frontend application, where we'll use it to set up a new authorization as well as building a basic login page with Next.js and Supabase's `auth.session()`. We'll use react hooks such as useEffect and useState to manage the state. 

Set up a Login Page in Next.js with Supabase's auth.session()

In this lesson, we'll create a new Next.js application, and add the Supabase client to our project. We'll also look at how Supabase authorizes applications using client keys, and cover some things you need to know about securely using Supabase in your applications.

Set up a Supabase Client in Next.js

In this lesson, we'll make our first API request using Supabase, to retrieve data from our database. We'll see the power of Supabase's API documentation and easily find an example for retrieving all of the rows in our table.

Retrieve Data with a Supabase API Request

**Documentation on creating public user tables has been [moved here](https://supabase.io/docs/guides/auth/managing-user-data)**. Supabase has also removed triggers from this doc but you can still use them.

In this lesson, we'll use Supabase's triggers functionality to automatically update data in our application when a user creates an account. Triggers are a powerful functionality of relational databases that allow us to minimize the amount of manual development work we need to do to build applications.

Use Triggers to Automatically Update Supabase Tables

In this lesson, we'll add support for "Login with GitHub" by using Supabase's auth functionality. We do that by setting up a new GitHub application. Supabase's [Auth documentation](https://supabase.io/docs/guides/auth#third-party-logins) has the URI that GitHub requires.

Configure Supabase Auth to Allow Users to Login with GitHub

Supabase's admin interface is where we can explore data, create new tables, and configure our project. In this lesson, we'll walk through the admin interface and the available options for your Supabase application.

We'll explore the following pages and their features
- Table Editor
- Authentication
- Storage
- SQL
- API
- Database


Navigate the Supabase Admin Interface

In this lesson, we create a new [Supabase account](https://supabase.io/) and initialize our first project. We see how Supabase generates a database and an API for us.

Supabase

Search Results