Use Supra with SolidJS

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

Set up a Supra project with sample data

Create a new project in the Supra Dashboard.

After your project is ready, create a table in your Supra 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');

Create a SolidJS app

Create a SolidJS app using the degit command.

Terminal


_10npx degit solidjs/templates/js my-app

Install the Supra client library

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

Navigate to the SolidJS app and install supra-js.

Terminal


_10cd my-app && npm install @supra/supra-js

Query data from the app

In App.jsx, create a Supra client using your Project URL and public API (anon) key.

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

src/App.jsx


_21  import { createClient } from "@supra/supra-js";
_21  import { createResource, For } from "solid-js";
_21
_21  const supra = createClient('https://<project>.supra.co', '<your-anon-key>');
_21
_21  async function getCountries() {
_21    const { data } = await supra.from("countries").select();
_21    return data;
_21  }
_21
_21  function App() {
_21    const [countries] = createResource(getCountries);
_21
_21    return (
_21      <ul>
_21        <For each={countries()}>{(country) => <li>{country.name}</li>}</For>
_21      </ul>
_21    );
_21  }
_21
_21  export default App;

Start the app

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

Terminal


_10npm run dev

Edit this page on GitHub

SupraDOCS

Use Supra with SolidJS

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

Set up a Supra project with sample data

Create a SolidJS app

Install the Supra client library

Query data from the app

Start the app