ScholarPath Africa
# ScholarPath Africa 🌍
A full-stack scholarships discovery platform for African students — built with Next.js, SQLite, and Tailwind CSS.
## Features
- 🔍 **Search & filter** scholarships by country, type, degree level, and funding
- 🌐 **Country pages** with visa information and scholarship listings
- ✍️ **Tools suite** — SOP generator, CV guide, motivation letter guide, application checklist, visa tips, recommendation letter templates
- 📰 **Blog** with scholarship tips and guides
- 📧 **Email capture** for scholarship alerts
- 🔧 **Admin panel** — add/edit/delete scholarships, CSV bulk import, stats dashboard
- 📊 **SEO-ready** — schema.org markup, dynamic sitemap, meta tags
- 💰 **AdSense-ready** — placeholder ad units throughout
---
## Quick Start (Local Development)
### 1. Prerequisites
- Node.js 18+
- npm or yarn
### 2. Clone & Install
```bash
git clone
cd scholarpath-africa
npm install
```
### 3. Environment Variables
```bash
cp .env.example .env.local
```
Edit `.env.local`:
```env
DATABASE_PATH=./scholarpath.db
JWT_SECRET=your-super-secret-jwt-key-change-this
ADMIN_EMAIL=admin@scholarpathAfrica.com
ADMIN_PASSWORD=your-strong-admin-password
NEXT_PUBLIC_SITE_URL=
localhost
```
### 4. Initialise Database
```bash
node scripts/init-db.js
node scripts/seed.js
```
### 5. Run Development Server
```bash
npm run dev
```
Open
localhost
Admin panel:
localhost
---
## Deployment on Vercel
### 1. Push to GitHub
```bash
git init
git add .
git commit -m "Initial commit"
git remote add origin
github.com
git push -u origin main
```
### 2. Import to Vercel
1. Go to vercel.com → New Project
2. Import your GitHub repository
3. Framework preset: **Next.js** (auto-detected)
### 3. Environment Variables on Vercel
In Vercel Dashboard → Settings → Environment Variables, add:
| Variable | Value |
|---|---|
| `DATABASE_PATH` | `/tmp/scholarpath.db` |
| `JWT_SECRET` | `your-secret-ke …