use sqlalchemy queries instead of mysql views
update bootstrap, strip out what we dont need
update templates