🧑‍💻 My Portfolio

Welcome to My Portfolio — a modern, full-stack personal showcase built with Next.js, styled with Tailwind CSS, and powered by a PocketBase backend. It also integrates OpenAI to enable smart and interactive experiences.

🚀 Features

• ✅ PocketBase Integration for dynamic content (e.g., portfolio images, project data)
• 🤖 OpenAI Integration to support smart interactions (like AI summaries or content generation)
• 🎨 Tailwind CSS styling with custom theming
• ⚙️ TypeScript support for safer, scalable development
• 🔍 Dynamic Search & Filtering for projects
• 🌐 Responsive Design optimized for all devices

🗄️ PocketBase to Neon Migration

This project now includes a safe migration path from PocketBase collections to Neon PostgreSQL.

1. Environment variables

Create/update .env with:

NEON_DATABASE_URL=postgresql://USER:PASSWORD@HOST/DB?sslmode=require&channel_binding=require
POCKETBASE_URL=https://remain-faceghost.pockethost.io
POCKETBASE_ADMIN_EMAIL=
POCKETBASE_ADMIN_PASSWORD=
REVALIDATE_SECRET=
ASSISTANT_REFRESH_SECRET=
OPENAI_API_KEY=
OPENAI_EMBEDDING_MODEL=text-embedding-3-small

POCKETBASE_ADMIN_EMAIL and POCKETBASE_ADMIN_PASSWORD are optional (only required for protected collections).

2. Install dependencies

pnpm install

3. Run migration

pnpm db:migrate:pocketbase-to-neon

4. Verify migrated data

pnpm db:verify

Normalized relational structure

The migration creates a microservice-friendly schema with separate tables and relationships:

• profiles (source: profile collection)
• projects (source: projects collection, linked to profiles)
• project_tools (one-to-many tools for each project)
• project_tags (one-to-many AI/feature tags for each project)
• portfolio_items (source: portfolio_images, linked to projects and profiles)
• portfolio_item_tags (one-to-many tags for each portfolio item)
• migration_runs (audit trail for every migration execution)

To avoid data loss, each core table stores the full PocketBase record in raw_payload (JSONB), in addition to normalized columns.

Runtime data source

The application runtime now reads from Neon (PostgreSQL) via Next.js API routes:

• /api/profile
• /api/projects
• /api/portfolio-items

The AI assistant also builds a database-backed knowledge catalog in Neon:

• assistant_knowledge_documents stores assistant-ready documents derived from profiles, projects, and portfolio_items
• /api/assistant/refresh refreshes assistant knowledge and can optionally sync embeddings when OPENAI_API_KEY is configured
• scripts/verify-neon-data.mjs reports assistant document and embedding counts

PocketBase is now only required for migration workflows (pnpm db:migrate:pocketbase-to-neon) and can be retired after you verify Neon data and app behavior in production.

📄 License

This project is licensed under the MIT License.

🙋‍♂️ Author

Meshack Bwire
Portfolio Website | GitHub