Building a Real-time Portfolio with Next.js, Node.js, and PostgreSQL

A full walkthrough of how I built my developer portfolio from database schema to a live, dynamic frontend — with no static JSON files. Most developer portfolios are just static JSON files masquerading as a database. Mine used to be the same — a hardcoded array of projects in a .js file that I had to manually edit and redeploy every time I added something new. I decided to rebuild it properly: a real backend, a real database, and a frontend that fetches live data on every request. Here's exactly how I did it. The Stack Frontend: Next.js (App Router, Server Components) Backend: Node.js + Express Database: PostgreSQL Deployment: (your hosting choice here) The architecture is intentionally simple. No GraphQL, no ORM, no microservices. Just clean REST endpoints backed by SQL queries. Database Schema The first step was designing the database. I kept it flat and simple sql — no over - engineering . -- Profile CREATE TABLE profile ( id SERIAL PRIMARY KEY , name VARCHAR ( 200 ) NOT NULL , title