JoblessYu

Discordgo - Job announcer bot. WIP

Get Started with Neon

This repo can now save scraped jobs to Neon using DATABASE_URL.

1) Set your Neon connection string

Your local .env is already gitignored. Add:

DATABASE_URL=postgresql://<user>:<password>@<host>/<database>?sslmode=require

2) Install Python dependencies

From the project root:

source .venv/bin/activate
pip install pandas python-jobspy "psycopg[binary]"

3) Run the scraper

cd Python-Jobspy
python JoblessYu.py

4) Verify jobs in Neon

The script creates a jobs table automatically and upserts records by (site, job_url).

Example SQL:

SELECT site, title, company, location, fetched_at
FROM jobs
ORDER BY fetched_at DESC
LIMIT 20;