Get up and running with Nhost and React

Create Project

If you haven’t, please create a project through the Nhost Dashboard.

Setup Database

Navigate to the SQL Editor of the database and run the following SQL to create a new table movies with some great movies.

CREATE TABLE movies (
  id SERIAL PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  director VARCHAR(255),
  release_year INTEGER,
  genre VARCHAR(100),
  rating FLOAT
);

INSERT INTO movies (title, director, release_year, genre, rating) VALUES
  ('Inception', 'Christopher Nolan', 2010, 'Sci-Fi', 8.8),
  ('The Godfather', 'Francis Ford Coppola', 1972, 'Crime', 9.2),
  ('Forrest Gump', 'Robert Zemeckis', 1994, 'Drama', 8.8),
  ('The Matrix', 'Lana Wachowski, Lilly Wachowski', 1999, 'Action', 8.7);

Caution

Make sure the option Track this is enabled

Permissions

Select the new table movies just created, and click in Edit Permissions to set the following permissions for the public role and select action.

Setup the Application

Create the application using standard tooling:

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

Install the Nhost package

Navigate to the application and install @nhost/nhost-js.

npm install @nhost/nhost-js

Configure the Nhost client and fetch the list of movies

./src/lib/nhost.js

    import { NhostClient } from "@nhost/nhost-js";

    // Replace <subdomain> and <region> with your project's values
    export const nhost = new NhostClient({
      subdomain: "<subdomain>",
      region: "<region>",
    })

./src/App.jsx

    import { useEffect, useState } from 'react'
    import { nhost } from './lib/nhost'
    import './App.css'

    function App() {
      const [movies, setMovies] = useState([])
      const [loading, setLoading] = useState(true)
      const [error, setError] = useState(null)

      useEffect(() => {
        const fetchMovies = async () => {
          try {
            const resp = await nhost.graphql.request({
              query: `query GetMovies {
                movies {
                  title
                  director
                  release_year
                  genre
                  rating
                }
              }`,
            })

            setMovies(resp.body.data.movies || [])
          } catch (err) {
            setError('Failed to fetch movies')
          } finally {
            setLoading(false)
          }
        }

        fetchMovies()
      }, [])

      if (loading) return <div>Loading...</div>
      if (error) return <div>Error: {error}</div>

      return (
        <div>
          <h1>Movies</h1>
          <table>
            <thead>
              <tr>
                <th>Title</th>
                <th>Director</th>
                <th>Release Year</th>
                <th>Genre</th>
                <th>Rating</th>
              </tr>
            </thead>
            <tbody>
              {movies.map((movie, index) => (
                <tr key={index}>
                  <td>{movie.title}</td>
                  <td>{movie.director}</td>
                  <td>{movie.release_year}</td>
                  <td>{movie.genre}</td>
                  <td>{movie.rating}</td>
                </tr>
              ))}
            </tbody>
          </table>
        </div>
      )
    }

    export default App

The end

Run your project with npm run dev and navigate to http://localhost:5173 in your browser.