From the course: Master React 19 and Next.js 16 with Hands-On Projects and Real-World Applications

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Database relationships (users + messages)

Database relationships (users + messages)

From the course: Master React 19 and Next.js 16 with Hands-On Projects and Real-World Applications

Start my 1-month free trial Buy for my team

Database relationships (users + messages)

“

Hello, and welcome! In this session, we're going to take our Next.js and SQLite project to the next level. Right now, we have a simple messaging system, but the messages are anonymous. Our goal is to enhance our SQLite setup by introducing a users table, and then creating a relationship between users and messages. This means we'll link each message to a specific user using a foreign key, which is a fundamental concept in database design. By the end, you'll be able to store which user sent which message and display that information in your application. Okay, so we're going to start setting up our database interaction. The first thing we need to do is create a new file. Inside our src slash lib directory, let's create a file called dbsetup.js. This file will contain the logic for setting up our database. Specifically, we'll put the code in here that creates the Users and Messages tables if they don't already exist. So go ahead and create that file and we'll move on from there. Moving to…

Contents