Static Sites with Next.js 9.3 and Prisma

Other Links
----

Me
----

#nextjs #react #prisma

[jeffwebb]

Great videos, I enjoyed watching and learned a lot about next.js, thanks!

[loveanimals-]

It'd be great if you can show how to add a search bar to this site. That's a common use case a lot of people want.

[mohammedg]

Ohh man
You are soo awesome 👌
Keep it up

[khandoor]

Nice tutorial Lee, I wonder about a comparison between Prisma and Strapi for managing the DB. Any thoughts?

[stansuen]

Hi I am totally new to Next.js and Gatsby and even JS too. This is. a great video. Allow me to ask an elementary question: If I run an online media website where editors are uploading news all the time from the CMS backend and to publish the news in real time, is it still structured as a static site? Due to the real time nature and user uploading contents nature, it has got to be a dynamic site right?

[junaidkabani]

Great video and very informative! My question is how does the Prisma Client on the frontend "know" to use the dev.db you created.

[tejassoe]

After deployment, vercel is read-only environment. How does sqlite db helps us here?

Is it possible to use sqlite db, migrate, seed db in vercel??

Please help.

[SeaRich]

really good video, thanks! As a no web experience beginner, would you do more tutorials about Next.js full-stack?

[sreekumarmenon]

what is the headless CMS that you recommend if I have to host my blogs ? my basic requiremwent is to have graphql support, and the content should be editable easily by marketing team . Also in most rich text edtors I see that there is no ability to center a conent inside, for eg, if we type 2 paragraphs and then insert an image followed by 2 more paragraphs and we want the image to be centered, how do we do that inside rich text content?

[shivrajnag]

Will Next.js be a good option to build something like YouTube ?

[jeevanjyotidash]

I am getting this error while calling that song model in getStaticProps:-

Invalid `prisma.song.findMany()` invocation in



Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: { code: Unknown, extended_code: 1 }, Some("no such table: dev.Song"))) })

Please help..

[cmwebcreations]

Is it possible to build a search bar to query the database with these static sites ?

[kgjhctr]

Why is prisma preferred over interacting with db using the traditional way?

[ApoorvMote]

I got couple of questions. I want to add page view count and likes count on my static page just so visitor can use it for sorting articles by most liked and most viewed. Do you recommend scheduled prerendering every 24 hours for sorted pages or make api request for each sort for latest data? Its less than 100 page views per day but hoping to get more over time. Also how did you add page view live count to your blog? And can you simply verify that we can still use MDX for static sites.

[harryzachariou]

If you wanted to search through the My Songs list that page would have to use client side rendering right?

[Wardret]

It may be a dumb question, but does static sites with next js mean that I will build this application via yarn next export instead of yarn build ?

[adamtak]

Is there a way to not have to keep initializing PrismaClient? Does NextJS have some global context you can pull from so you only initialize PrismaClient the once?

[swyxTV]

remember when nextjs 9 was the new hotness