Node.js API with Prisma, TypeScript, and PostgreSQL
Setup Node.js API with Prisma, TypeScript, and PostgreSQL
In this comprehensive article, you'll learn how to set up a Node.js API Project with ExpressJs, Prisma, PostgreSQL, Redis, and Docker-compose. The API will run on an Express server and use Postgres for data storage.
- Initialize a Prisma Project with Express.js
- Generate a database schema with the Prisma CLI
- Defining the User Model with Prisma
- Database Migration with Prisma
- Connect the ExpressJs App to the Redis Server
- Connecting to PostgreSQL and Redis with MySQL VS Code Extension
Read the entire article here: https://codevoweb.com/api-node-typescript-prisma-postgresql-project-setup
Node.js + Prisma + PostgreSQL: Access & Refresh Tokens
In this article, you’ll learn how to implement JWT authentication with access and refresh tokens using Node.js, ExpressJs, Prisma, PostgreSQL, Redis, and Docker-compose.
- JWT Authentication Example with Node.js, Prisma, and PostgreSQL
- User Login and Registration Flow with JSON Web Tokens
- Create the User Model with Prisma
- Create Validation Schemas with Zod
- Create Middleware to Parse Zod Schema
- Password Management with Bcryptjs
- Create Services to Interact with the Database
- Authentication with JSON Web Tokens (JWT)
- Create Authentication Controllers
- Create User Controller
- Create Authentication Middleware
- Create Authentication Routes
- Create User Routes
- Add the Routes to the Middleware Stack
- Database Migration with Prisma
- Testing the JSON Web Token Authentication REST API
Read the entire article here: https://codevoweb.com/node-prisma-postgresql-access-refresh-tokens
CRUD API with Node.js and PostgreSQL: Send HTML Emails
In this article, you'll learn how to send HTML Emails with Node.js, Nodemailer, Prisma, PostgreSQL, Express, and Docker-compose. We'll create a generic class that can be used to send single or multiple emails at once by chaining the methods together.
- Send Emails with Node.js, Nodemailer, Prisma Overview
- Setting up ExpressJs Templating Engine with Pug
- Create a Utility Class to the Send Emails
- Get the Nodemailer Credentials
- Define the Email Class Attributes
- Create a Nodemailer Transporter
- Create a Method to Generate the Email Templates
- Create a Method to Send the Emails
- Creating the Email Templates with Pug
- Run Prisma Migration to Update PostgreSQL Schema
- Update the User Registration Controller to Send the Emails
- Create a Route Handler to Verify the Email
- Update the Login Controller
Read the entire article here: https://codevoweb.com/crud-api-node-js-and-postgresql-send-html-emails
API with Node.js, Prisma & PostgreSQL: Forget/Reset Password
In this article, you'll learn how to implement forget/reset passwords with Node.js, Prisma, PostgreSQL, Nodemailer, Redis, Docker-compose, and Pug. Also, you will learn how to dynamically generate HTML Email templates with Pug and send them via SMTP to the user's Email inbox.
- Forget/Reset Password Flow in Node.js
- Update the Prisma User Model
- Run the Prisma Migration Command to Update the Database
- Update the Zod User Schema
- Create Services to Query and Mutate the Database
- Create a Utility Class to Send Emails
- Create Controllers
- Forgot Password Controller
- Create the Password Reset Controller
- Add the Routes to the Middleware Pipeline
Read the entire article here: https://codevoweb.com/crud-api-node-prisma-postgresql-reset-password
gem-hunter