Your Supabase database has been successfully configured:
- Database migrations have been applied
- Tables created:
repositories - Connection tested and working
When deploying to Vercel, add these environment variables:
DATABASE_URL=postgresql://postgres:Ot4sCnf9ZZ7ZltvN@db.pqkmbseysccyjtbticoj.supabase.co:5432/postgres
CRON_SECRET=bcfb29320a098752e55952c93a3ddf1f49770b69d85e8814e99a65f757468ae2
GITHUB_TOKEN=your_github_token_here
- Go to Vercel Dashboard
- Import your GitHub repository:
tonytangdev/contribute-to-small-projects - Add the environment variables above in the deployment settings
- Deploy!
- Your cron job will automatically fetch repositories daily
- You can manually trigger it with:
POST /api/fetchwith Authorization header - The app will be live and ready to use!
- repositories: Stores GitHub repository data
- id, name, owner, description, language, stars, contributors
- githubUrl (unique), lastUpdated, createdAt, updatedAt
- ✅ Repository discovery with 100-600 stars
- ✅ Search by name/description
- ✅ Filter by programming language
- ✅ Contributors count display
- ✅ Modern responsive UI
- ✅ Server-side pagination
- ✅ Daily auto-updates via cron