Skip to content
Community

Next.js Portfolio with Blog

Easily create a portfolio with Next.js and Markdown.

Framework
Use Case
Database
Publisher Lee Robinson
leerob.io

leerob.io

Running Locally

This application requires Node.js v18.17+.

git clone https://github.com/leerob/leerob.io.git
cd leerob.io
pnpm install
pnpm run setup # Remove all of my personal information
pnpm dev

Create a .env.local file similar to .env.example.

Database Schema

CREATE TABLE redirects (
  id SERIAL PRIMARY KEY,
  source VARCHAR(255) NOT NULL,
  destination VARCHAR(255) NOT NULL,
  permanent BOOLEAN NOT NULL
);

CREATE TABLE guestbook (
  id SERIAL PRIMARY KEY,
  email VARCHAR(255) NOT NULL,
  body TEXT NOT NULL,
  created_by VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL,
  updated_at TIMESTAMP
);

CREATE TABLE views (
  slug VARCHAR(255) PRIMARY KEY,
  count INT NOT NULL
);

License

  1. You are free to use this code as inspiration.
  2. Please do not copy it directly.
  3. Crediting the author is appreciated.

Please remove all of my personal information (blog posts, images, etc.) by running pnpm run setup.

leerob.io
Community

Next.js Portfolio with Blog

Easily create a portfolio with Next.js and Markdown.

Framework
Use Case
Database
Publisher Lee Robinson

leerob.io

Running Locally

This application requires Node.js v18.17+.

git clone https://github.com/leerob/leerob.io.git
cd leerob.io
pnpm install
pnpm run setup # Remove all of my personal information
pnpm dev

Create a .env.local file similar to .env.example.

Database Schema

CREATE TABLE redirects (
  id SERIAL PRIMARY KEY,
  source VARCHAR(255) NOT NULL,
  destination VARCHAR(255) NOT NULL,
  permanent BOOLEAN NOT NULL
);

CREATE TABLE guestbook (
  id SERIAL PRIMARY KEY,
  email VARCHAR(255) NOT NULL,
  body TEXT NOT NULL,
  created_by VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL,
  updated_at TIMESTAMP
);

CREATE TABLE views (
  slug VARCHAR(255) PRIMARY KEY,
  count INT NOT NULL
);

License

  1. You are free to use this code as inspiration.
  2. Please do not copy it directly.
  3. Crediting the author is appreciated.

Please remove all of my personal information (blog posts, images, etc.) by running pnpm run setup.

Unleash New Possibilities

Deploy your app on Vercel and unlock its full potential