Next.js CMS Project: PlanetScale + Kysely, Content Layer, EditorJS TypeScript - Live Coding #2

Today, I'm trying to figure out how to connect PlanetScale database with Kysely in Next.js.

Next.js CMS Project

This project is aimed to create a CMS with the latest Next.js stack, including the following technologies.

1. Next.js 13 App Directory + PNPM
2. Database: PlanetScale + Kysely
3. Auth: Clerk
4. UI: Shadcn UI + Tailwind
5. Editor: Editor.js
6. Search: FlexSearch
7. ContentLayer

Steps

Aug 17: I followed Dave Gray's tutorial to [build a basic blog](   • Next.js Blog Website | How to Build a Blog...  .

Aug 18: Add PlanetScale and Kysely

Todo List:

1. Move blog posts from local to PlanetScale and fetch them through Kysely
2. Create a site settings table in PlanetScale to the basic info of the CMS, e.g. the site name...