Use Supabase with SolidJS

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

Create a Supabase project

Go to database.new and create a new Supabase project.

When your project is up and running, go to the Table Editor, create a new table and insert some data.

Alternatively, you can run the following snippet in your project's SQL Editor. This will create a instruments table with some sample data.

1
2
3
4
5
6
7
8
9
10
11
12
13
-- Create the tablecreate table instruments (  id bigint primary key generated always as identity,  name text not null);-- Insert some sample data into the tableinsert into instruments (name)values  ('violin'),  ('viola'),  ('cello');alter table instruments enable row level security;

Make the data in your table publicly readable by adding an RLS policy:

1
2
3
4
create policy "public can read instruments"on public.instrumentsfor select to anonusing (true);

Create a SolidJS app

Create a SolidJS app using the degit command.

1
npx degit solidjs/templates/js my-app

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 SolidJS app.

Navigate to the SolidJS app and install supabase-js.

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

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 getInstruments function to fetch the data and display the query result to the page.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
import { createClient } from "@supabase/supabase-js";  import { createResource, For } from "solid-js";  const supabase = createClient('https://<project>.supabase.co', '<your-anon-key>');  async function getInstruments() {    const { data } = await supabase.from("instruments").select();    return data;  }  function App() {    const [instruments] = createResource(getInstruments);    return (      <ul>        <For each={instruments()}>{(instrument) => <li>{instrument.name}</li>}</For>      </ul>    );  }  export default App;

Start the app

Start the app and go to http://localhost:3000 in a browser and you should see the list of instruments.

1
npm run dev