Next.js Portfolio with Blog

Next.js Portfolio with Blog
Type: Code
Framework: Next.js
CSS: Tailwind
Database: PlanetScale

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.

Sign In

Register

Reset Password

Please enter your username or email address, you will receive a link to create a new password via email.