Skip to content
Avatar of leerobleerob/leerob.io

Next.js Portfolio with Blog

Easily create a portfolio with Next.js and Markdown.

Framework
Use Case
Database
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
bun install
bun run setup # Remove all of my personal information
bun 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 bun run setup.

leerob.io
Avatar of leerobleerob/leerob.io

Next.js Portfolio with Blog

Easily create a portfolio with Next.js and Markdown.

Framework
Use Case
Database

leerob.io

Running Locally

This application requires Node.js v18.17+.

git clone https://github.com/leerob/leerob.io.git
cd leerob.io
bun install
bun run setup # Remove all of my personal information
bun 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 bun run setup.

Unleash New Possibilities

Deploy your app on Vercel and unlock its full potential