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 β¦