Prepare for the PgBouncer and IPv4 deprecations on 26th January 2024

Getting Started

Framework Quickstarts

Use Supabase with React

Learn how to create a Supabase project, add some sample data to your database, and query the data from a React app.

1

Set up a Supabase project with sample data

Create a new project in the Supabase Dashboard.

After your project is ready, create a table in your Supabase database using the SQL Editor in the Dashboard. Use the following SQL statement to create a countries table with some sample data.

SQL_EDITOR

_10
-- Create the table
_10
CREATE TABLE countries (
_10
id SERIAL PRIMARY KEY,
_10
name VARCHAR(255) NOT NULL
_10
);
_10
-- Insert some sample data into the table
_10
INSERT INTO countries (name) VALUES ('United States');
_10
INSERT INTO countries (name) VALUES ('Canada');
_10
INSERT INTO countries (name) VALUES ('Mexico');

2

Create a React app

Create a React app using a Vite template.

Terminal

_10
npm create vite@latest my-app -- --template react

3

Install the Supabase client library

The fastest way to get started is to use the supabase-js client library which provides a convenient interface for working with Supabase from a React app.

Navigate to the React app and install supabase-js.

Terminal

_10
cd my-app && npm install @supabase/supabase-js

4

Query data from the app

In App.jsx, create a Supabase client using your project URL and public API (anon) key:

Project URL
Anon key

Add a getCountries function to fetch the data and display the query result to the page.

src/App.jsx

_27
import { useEffect, useState } from "react";
_27
import { createClient } from "@supabase/supabase-js";
_27
_27
const supabase = createClient("https://<project>.supabase.co", "<your-anon-key>");
_27
_27
function App() {
_27
const [countries, setCountries] = useState([]);
_27
_27
useEffect(() => {
_27
getCountries();
_27
}, []);
_27
_27
async function getCountries() {
_27
const { data } = await supabase.from("countries").select();
_27
setCountries(data);
_27
}
_27
_27
return (
_27
<ul>
_27
{countries.map((country) => (
_27
<li key={country.name}>{country.name}</li>
_27
))}
_27
</ul>
_27
);
_27
}
_27
_27
export default App;

5

Start the app

Start the app, go to http://localhost:5173 in a browser, and open the browser console and you should see the list of countries.

Terminal

_10
npm run dev