Portfolio V5

Hello everyone! 👋

Let me introduce myself, I'm Eki Zulfar Rachman. On this occasion, I'd like to share the portfolio website project that I've developed.

🚀 Live Demo

Website Link: https://www.eki.my.id/

🛠️ Tech Stack

This project is built using modern web technologies:

• ReactJS - Frontend framework
• Tailwind CSS - Utility-first CSS framework
• Supabase - Backend for portfolio data, certificates, and comment system
• AOS - Animate On Scroll library
• Framer Motion - Animation library
• Lucide - Icon library
• Material UI - React component library
• SweetAlert2 - Beautiful alert dialogs

📋 Prerequisites

Before running this project, ensure you have the following installed:

• Node.js (version 14.x or higher)
• npm or yarn package manager

🏃‍♂️ Getting Started

Follow these steps to run the project locally:

1. Clone the Repository

git clone https://github.com/EkiZR/Portofolio_V5.git
cd Portofolio_V5

2. Install Dependencies

npm install

If you encounter peer dependency issues, use:

npm install --legacy-peer-deps

3. Run the Development Server

npm run dev

4. Open in Browser

Access the application through the link displayed in your terminal (usually http://localhost:5173).

🏗️ Building for Production

To create a production-ready build:

1. Run the build command:

   npm run build

2. The build files will be saved in the dist folder. Upload this folder to your hosting server.

⚙️ Configuration (Supabase)

All backend data for this project (portfolio, certificates, and comments) is managed by Supabase.

1. Create Supabase Project

• Go to Supabase and create a new project.
• Keep your Project URL and anon public key handy. You can find them in Settings > API.

2. Setup Database Tables & Policies

Run the following all-in-one SQL script in your Supabase SQL Editor. This will set up all necessary tables, security policies, storage, and also insert one example for each table.

-- ---- TABLE CREATION ----

-- Creates the 'projects' table for portfolio items
CREATE TABLE public.projects (
  id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  created_at timestamp with time zone DEFAULT now() NOT NULL,
  "Title" text,
  "Description" text,
  "Img" text,
  "Link" text,
  "Github" text,
  "Features" jsonb,
  "TechStack" jsonb
);

-- Creates the 'certificates' table
CREATE TABLE public.certificates (
  id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  created_at timestamp with time zone DEFAULT now() NOT NULL,
  "Img" text
);

-- Creates the 'portfolio_comments' table for the comment system
CREATE TABLE public.portfolio_comments (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  content TEXT NOT NULL,
  user_name VARCHAR(255) NOT NULL,
  profile_image TEXT,
  is_pinned BOOLEAN DEFAULT FALSE,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- ---- ROW LEVEL SECURITY (RLS) SETUP ----

-- Enable RLS for all tables
ALTER TABLE public.projects ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.certificates ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.portfolio_comments ENABLE ROW LEVEL SECURITY;

-- ---- POLICY CREATION ----

-- Policy for 'projects': Allow public read access
CREATE POLICY "Public Read Access Policy for Projects"
ON public.projects FOR SELECT TO public USING (true);

-- Policy for 'certificates': Allow public read access
CREATE POLICY "Public Read Access Policy for Certificates"
ON public.certificates FOR SELECT TO public USING (true);

-- Policies for 'portfolio_comments': Allow read for everyone, and insert for everyone (but not pinned)
CREATE POLICY "Allow public read on portfolio_comments"
ON public.portfolio_comments FOR SELECT TO public USING (true);

CREATE POLICY "Allow public insert on portfolio_comments"
ON public.portfolio_comments FOR INSERT TO public WITH CHECK (is_pinned = false);

-- ---- STORAGE SETUP FOR COMMENT PROFILE IMAGES ----

-- Create a public bucket for profile images
INSERT INTO storage.buckets (id, name, public)
VALUES ('profile-images', 'profile-images', true)
ON CONFLICT (id) DO NOTHING; -- Avoid errors if the bucket already exists

-- Policies for 'profile-images' bucket
CREATE POLICY "Allow public to upload profile images"
ON storage.objects FOR INSERT TO public WITH CHECK (bucket_id = 'profile-images');

CREATE POLICY "Allow public to read profile images"
ON storage.objects FOR SELECT TO public USING (bucket_id = 'profile-images');

-- ---- EXAMPLE DATA INSERTION ----

-- Insert one example project
INSERT INTO public.projects ("Title", "Description", "Img", "Link", "Github", "Features", "TechStack") 
VALUES (
    'Example Project Title', 
    'A simple description for this example project, explaining its main purpose and goals.', 
    'REPLACE_WITH_YOUR_PROJECT_IMAGE_URL.png', 
    'REPLACE_WITH_YOUR_LIVE_DEMO_URL.com', 
    'REPLACE_WITH_YOUR_GITHUB_REPO_URL.com', 
    '["Main Feature A", "Core Function B", "Key Ability C"]', 
    '["React", "Supabase", "Tailwind CSS"]'
);

-- Insert one example certificate
INSERT INTO public.certificates ("Img") 
VALUES ('REPLACE_WITH_YOUR_CERTIFICATE_IMAGE_URL.png');

-- Insert one example comment
INSERT INTO public.portfolio_comments (content, user_name) 
VALUES ('Created By Eki Zulfar Rachman', 'ekizr');

3. Enable Realtime (for Comment System)

• Go to Database > Replication.
• Under "Source", click on the "0 tables" text.
• Enable replication for the portfolio_comments table by toggling the switch. This will make the comment section update in real-time.

🔧 Environment Variables Setup

Create a file named .env in the root of your project and add your Supabase credentials.

# Supabase Configuration
VITE_SUPABASE_URL=your-supabase-url
VITE_SUPABASE_ANON_KEY=your-supabase-anon-key

Important:

• All environment variables must be prefixed with VITE_ for Vite to access them.
• Restart your development server after creating or modifying the .env file.
• Never commit your .env file to version control. Ensure it's listed in your .gitignore file.

Configuration File (supabase.js)

Ensure your Supabase client configuration file (e.g., src/supabase.js) uses these environment variables.

import { createClient } from '@supabase/supabase-js'

const supabaseUrl = import.meta.env.VITE_SUPABASE_URL
const supabaseKey = import.meta.env.VITE_SUPABASE_ANON_KEY

if (!supabaseUrl || !supabaseKey) {
  throw new Error("Supabase URL and Anon Key are required. Check your .env file.")
}

export const supabase = createClient(supabaseUrl, supabaseKey)

🚨 Troubleshooting

If you encounter issues while running the project:

• Ensure Node.js is correctly installed.
• Verify you're in the correct project directory.
• Check that all dependencies are installed without errors.
• Make sure your Supabase configuration in the .env file is correct and the server has been restarted.
• Clear your browser cache and try again.

📝 Usage & Credits

We would appreciate it if you decide to use this project. Please include proper credit when using it. Thank you! 🙏

📞 Contact

If you have any questions or need help with the setup, feel free to reach out!

Eki Zulfar Rachman

• Website: https://www.eki.my.id/
• GitHub: EkiZR

---

⭐ If this project helped you, please consider giving it a star on GitHub!