time taken to complete: within 1 day
see live at https://cosenza-bus.onrender.com/
git clone https://github.com/davidepaci/linea138
cd linea138
cd app
yarn install
yarn start
the web app will be available at localhost:3000
the scripts in this folder get data from tables within a pdf, fix it and saves it to sqlite (python, pandas, pdfplumber, sqlite)
the scripts are ran in this order:
- extractsql2.py
- excel2db.py
- save2db.py
simple web app (node, sql, tailwind, js, ejs)
design with https://www.usegalileo.ai/
- imperfect db (needs to be checked for random 00:00 values in stops)
- issues with night routes (a 00:06 stop is listed before a 23:52 stop, logically)
- not showing routes in the correct period
- no option to choose custom date and time to check
- svgs loading too slowly?
- serverless hosting/static website generation are perhaps ideal?
- bad mobile responsiveness