DEV Community 👩‍💻👨‍💻

Cover image for Static playlist website with Next.js and Prisma
Chris Bongers
Chris Bongers

Posted on • Originally published at daily-dev-tips.com

Static playlist website with Next.js and Prisma

By now, we had a good play with Prisma and created an application that can load a person's Spotify playlists.
On click, the person can add this playlist to our Postgres database.

Today, we'll be looking at creating static pages from this data for a blazing fast website.

For those willing to work alongside us. Take the following GitHub branch as your starting point.

Creating the list of playlists

Once you have filled your database with some playlists, go ahead and open up the existing pages/index.js file and change it to show the database playlists.

To get started, I renamed the existing index.js file to new.js because we want to use this as a separate page.

Then create the new index.js page and follow the following boilerplate.

export async function getStaticProps() {

}

const Index = ({ playlists }) => (

);
export default Index;
Enter fullscreen mode Exit fullscreen mode

The first thing we need to do is import the Next.js link and the Prisma client.

import Link from 'next/link';
import { PrismaClient } from '@prisma/client';
Enter fullscreen mode Exit fullscreen mode

Then in our getStaticProps we can leverage this Prisma client and retrieve all playlists.

export async function getStaticProps() {
  const prisma = new PrismaClient();
  const playlists = await prisma.playlist.findMany();
  return {
    props: {
      playlists,
    },
  };
}
Enter fullscreen mode Exit fullscreen mode

This will query our database and return all the playlists as props to our page.

In the meantime, I've added Tailwind to this Next.js project to make it look a bit fancier.

Inside our template, we render a grid of playlists, each link to its individual page.

const Index = ({ playlists }) => (
  <ul className='grid grid-cols-2 max-w-xl'>
    {playlists.map((playlist) => (
      <li key={playlist.id} className='rounded-xl shadow-lg m-4'>
        <Link href={`/playlist/${playlist.id}`}>
          <a>
            <img
              src={playlist?.image}
              className='object-cover w-full rounded-t-xl'
            />
            <h3 className='text-2xl m-4'>{playlist.title}</h3>
          </a>
        </Link>
      </li>
    ))}
  </ul>
);
Enter fullscreen mode Exit fullscreen mode

Next.js Prisma static generated overview page

Creating the individual playlist pages

Once we have our index file setup, we can go ahead and move to the individual pages.

We created links to these pages as playlist/[id], so that's what we'll have to make.

Create a new file pages/playlist/[id].js.

For this file, we will use the following boilerplate.

export async function getStaticProps({ params }) {

}

export async function getStaticPaths() {

}

const Playlist = ({ playlist }) => (

);
export default Playlist;
Enter fullscreen mode Exit fullscreen mode

The main difference here is that we need both getStaticProps and getStaticPaths.

The getStaticPaths function will create single pages for a whole collection, as where the getStaticProps will find the details for one of these items.

In this file, we also need our Prisma client.

import { PrismaClient } from '@prisma/client';
Enter fullscreen mode Exit fullscreen mode

Then let's first work on the getStaticPaths function to build all the individual pages.

export async function getStaticPaths() {
  const prisma = new PrismaClient();
  const playlists = await prisma.playlist.findMany();

  return {
    paths: playlists.map((playlist) => ({
      params: {
        id: playlist.id.toString(),
      },
    })),
    fallback: false,
  };
}
Enter fullscreen mode Exit fullscreen mode

Here we use the same query to retrieve all our data and pass this on as unique paths based on the ID.

We can then use this ID in our getStaticProps function to get a single record.

export async function getStaticProps({ params }) {
  const prisma = new PrismaClient();
  const playlist = await prisma.playlist.findUnique({
    where: {
      id: Number(params.id),
    },
  });

  return {
    props: {
      playlist,
    },
  };
}
Enter fullscreen mode Exit fullscreen mode

This will return a single playlist to the page.
In which we will render a simple UI with a button to Spotify.

const Playlist = ({ playlist }) => (
  <div className='rounded-xl shadow-lg'>
    <img src={playlist?.image} className='object-cover w-full rounded-t-xl' />
    <div className='m-4'>
      <h1 className='text-4xl'>{playlist.title}</h1>
      <a className='underline mt-4 block' href={playlist.uri}>
        Open on Spotify
      </a>
    </div>
  </div>
);
Enter fullscreen mode Exit fullscreen mode

Next.js static generated Prisma detail page

And that's it. We now have a static generated Next.js website based on data from our Postgres database.

You can find the complete code on GitHub.

Thank you for reading, and let's connect!

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter

Top comments (0)

🌚 Life is too short to browse without dark mode