How to Build a Full Stack Next.js, FastAPI, PostgreSQL Boilerplate Tutorial

In this tutorial, I will show you how to set up a basic full stack boilerplate with Next.js, FastAPI, and PostgreSQL. Each framework and library was handpicked for its amazing DX (Developer Experience). This is how I would build a web app today if I were to start from scratch.

Table of Contents

1. Full Stack Next.js, FastAPI, PostgreSQL Tutorial
2. How to Build a Full Stack Next.js, FastAPI, PostgreSQL Boilerplate Tutorial
3. How to Deploy Next.js, FastAPI, and PostgreSQL with Shell Scripts
4. How to Develop a Full Stack Next.js, FastAPI, PostgreSQL App Using Docker
5. How to Build a User Authentication Flow with Next.js, FastAPI, and PostgreSQL
6. How to Test an API with Pytest and Requests

This tutorial was developed on a Macbook, so the tools may be different depending on your OS.

First, if you don’t already have Node.js, Python, and PostgreSQL installed, I recommend the following tools to install and manage different language and database versions on your machine.

• https://github.com/nvm-sh/nvm
• https://github.com/pyenv/pyenv
• https://postgresapp.com/

This tutorial is using:

• Node 16.13.0
• Python 3.9.6