8000 GitHub - davidepaci/linea138: web app to query Cosenza bus timetable
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

davidepaci/linea138

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 

Repository files navigation

time taken to complete: within 1 day

see live at https://cosenza-bus.onrender.com/

how to run

git clone https://github.com/davidepaci/linea138
cd linea138
cd app
yarn install
yarn start

the web app will be available at localhost:3000

data

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

app

simple web app (node, sql, tailwind, js, ejs)

image

design with https://www.usegalileo.ai/

issues

  • 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
0