blackray12/midori-portfolio

🟢 Midori's portfolio built with Next.js, Tailwind, and Postgres. Continuously updated...

Introduction

This is Midori's online portfolio, Continuously updated.

Tech stack

Category	Technology
Framework	Next.js
Database	Postgres
Authentication	NextAuth.js
Deployment	Vercel
Styling	Tailwind CSS

Running Locally

This application requires Node.js v18.17+.

git clone git@github.com:midori-profile/midori-portfolio.git
cd midori-portfolio
pnpm install
pnpm run start

Create a .env.local file similar to .env.exampleand follow the comments to set up your environment variables.

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 comments (
  id SERIAL PRIMARY KEY,
  url VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  body TEXT NOT NULL,
  created_by VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL,
  updated_at TIMESTAMP
);

CREATE INDEX idx_comments_url ON comments (url);

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

Thanks

Feel free to use my portfolio as a template, but please remove my personal posts and content.

Thanks to https://github.com/leerob/leerob.io for the inspiration.