1. 4
    Query Data From Supabase Using Next.js
    2m 21s

Query Data From Supabase Using Next.js

Jon Meyers
InstructorJon Meyers
Share this video with your friends

Social Share Links

Send Tweet
Published 3 years ago
Updated 3 years ago

supabase-js is a JavaScript library that makes interacting with your Supabase database simple!

In this video, we install the package with npm using npm i @supabase/supabase.js. We then create a reusable Supabase client that can be used throughout our application.

Additionally, we create environment variables for the Supabase URL and key, which are available in our Next.js client. Exposing these values to the client is not a security risk, as we will be enabling Row Level Security in a future lesson.

Lastly, we tell Next.js that we would like to pre-render our landing page at build time, by exporting out a getStaticProps function. This ensures that our lesson data is only fetched once - when we rebuild our application - rather than each time to user visits the page.

Instructor: [0:00] Let's display our Supabase lessons in our Next.js application. The first thing we need to do is install the supabase-js library. Now, let's create a file to initialize our Supabase client. We're going to put this in a utils folder.

[0:12] Now, we can import { createClient } from '@supabase/supabase-js' and export out a new variable for our Supabase client. This function takes two parameters, a URL and a key. Let's get those from Supabase.

[0:23] Let's go to Settings and then API. First, let's grab our URL. Back over in our Next.js application, let's create a .env.localfile. We're going to declare a variable for NEXT_PUBLIC_SUPABASEURL, and we're going to paste that URL from Supabase. Let's do the same for our Supabase key. We're going to use the anon key.

[0:49] Now, we can restart out development server to read in those environment variables. Back in our Supabase.js file, we can read in those values by saying process.env.NEXT_PUBLIC_SUPABASEURL and NEXT_PUBLIC_SUPABASE_KEY. Now, we can import our Supabase client in our index.js file and start querying our database.

[1:12] Because this lesson data is entirely public, we can tell Next.js that it can pre-render this at build time by exporting out a getStaticProps() function. Here, we can use the Supabase client to query all of the lessons from the Lesson table.

[1:27] We also declare which columns we would like to select. In this case, we want all of the columns. This is going to give us back some data. This will be a collection of all of our lessons, which we can then return as our props, which will pass it into our component. We can console log out our lessons here to see what this contains.

[1:49] Now, when we refresh our application and open the console, we'll see that we have our array of lessons coming from Supabase. Let's iterate over our array of lessons and display them in our web app. We can say lessons.map over each lesson, and for each of those lessons, we want to render a paragraph tag with the lesson's title.

[2:09] We also want to set a key on a paragraph tag to be lesson.id. When we Save, we'll see those lessons are displaying in our web app with data being loaded from our Supabase database.

waynehee
waynehee
~ 2 years ago

Hi, i failed to fetct data from supabase

error - pages/index.js (15:34) @ getStaticProps error - TypeError: Cannot read properties of undefined (reading 'from') at getStaticProps (webpack-internal:///./pages/index.js:25:92) at Object.renderToHTML (/Users/waynehee/the-book/node_modules/next/dist/server/render.js:386:26) at runMicrotasks (<anonymous>) at processTicksAndRejections (node:internal/process/task_queues:96:5) at async doRender (/Users/waynehee/the-book/node_modules/next/dist/server/base-server.js:669:38) at async cacheEntry.responseCache.get.isManualRevalidate.isManualRevalidate (/Users/waynehee/the-book/node_modules/next/dist/server/base-server.js:778:28) at async /Users/waynehee/the-book/node_modules/next/dist/server/response-cache/index.js:80:36 { page: '/' } 13 | 14 | export const getStaticProps = async () => {

15 | const { data: lessons } = await supabase.from("lesson").select("*"); | ^ 16 | 17 | return { 18 | props: {

waynehee
waynehee
~ 2 years ago

sorry i missed out the following:

14 | export const getStaticProps = async () => {

15 | const { data: lessons } = await supabase.from("lesson").select("*"); | ^ 16 | 17 | return { 18 | props: {

waynehee
waynehee
~ 2 years ago

problem solved. Thanks

Mike Frazier
Mike Frazier
~ a year ago

The npm command is incorrect. The package name is @supabase/supabase-js.

Markdown supported.
Become a member to join the discussionEnroll Today