NextJs data fetching tutorial #part2 using getStaticProps and MYSQL

This is a next.js tutorial on how to fetch data data for a statically generated page using data fetched from a MYSQL data base. The video goes through the steps to setup and fetch data from MYSQL database using queries.

Code on github: https://github.com/ui-code-tv/demo-blog-nextjs-mysql

Prerequisite is that you have a MYSQL database called blog setup already. You can import dummy data using following sql code :

Intro : (00:0:00)
Import dummy data into MYSQL: (00:03:52)
Setup .env.local file for db connection: (00:5:06)
Install serverless-mysql: (00:06:36)
Setup MYSQL helper functions: (00:09:07)
Create end point to fetch data: (00:11:50)
Create a static blog page that fetches data using endpoint: (00:14:24)
How write MYSQL data fecting code directly on the blog page: (00:18:14)

DROP TABLE IF EXISTS `posts`;
CREATE TABLE posts(
title VARCHAR(44) NOT NULL PRIMARY KEY
,content VARCHAR(49) NOT NULL
);
INSERT INTO posts(title,content) VALUES (‘This is all about end points’,’This is all about api end points111′);
INSERT INTO posts(title,content) VALUES (‘How to guide on SSR’,’This is all about server side rendering’);
INSERT INTO posts(title,content) VALUES (‘My first post’,’This is my first post..I have nothing much to say’);
INSERT INTO posts(title,content) VALUES (‘A post’,’Yet another post’);
INSERT INTO posts(title,content) VALUES (‘Last years post’,’This post is from last year’);