Rebuild MS Access Database for surgery data with Vuetify and Django Restframework
Budget: €750 – €1,500 EUR
- I built a MS Access database to collect data about heart patients (ca. 500 columns), see the UI in the attachments. This database should now be rebuilt as a webapp with a Vuetify frontend and a Django Restframework backend. (to see my UI mockup, check the link to Figma)
- The data is gathered because the dataset will then be used to do statistical analysis of the data
- Collecting the data via a webapp should ease data entry to the people entering the data and also avoid problems with e.g. merging multiple excel files coming from different hospitals
- data will be collected from multiple hospitals, from each hospital there can be multiple users responsible for entering the data
- I created a mockup of how the MS Access UI could be implemented using Vuetify components. You can find it here: https://www.figma.com/file/BDsQVXZIU3ZUL4GcWbOsvp/TV-Database-Web?node-id=194%3A3
- I would prefer to stick with Vuetify standards as much as possible to keep the web app flexible and reduce design efforts
- If it can be implemented easily, a light mode/dark mode switch would be nice to have (not neccessary)
BESIDES
the technical skills necessary I put a high value on good verbal and written english communication skills, because I believe good communication is key to building the right product.
## Architecture
The final production architecture/toolstack should look like the following:
- Dockerized: The application should be dockerized such that it can be run locally for testing and development and also deployed in the dockerized version
- Webserver: Nginx
- Frontend: Vue.js (with Nuxt or just Vue.js) with components from Vuetify
- Backend: Django Rest Framework
- Database: MongoDB or Postgres, hosted as a managed database on digital ocean (for development it should be possible to use a local database)
- Authentication: The Vue frontend should authenticate against the Django Rest backend with JWT
- User management: The Django admin area should be usable to users with the is_staff property to manage users and hospitals (see also the "user management and hospital management" section)
## Hosting
- The webapp will be hosted over my digital ocean account
## Deployment
- The deployment can be done by giving you SSH access to an instance or also by myself
# Management of users and hospitals
- The users are created and deleted in the Django Admin area by the superadmin
- The hospitals are created and deleted in the Django Admin area by the superadmin
- Users are associated with hospitals by assigning roles to the users for a given hospital
- The users are given roles in hospitals in the Django Admin area by the superadmin, the same applies for removing roles
- The data is gathered because the dataset will then be used to do statistical analysis of the data
- Collecting the data via a webapp should ease data entry to the people entering the data and also avoid problems with e.g. merging multiple excel files coming from different hospitals
- data will be collected from multiple hospitals, from each hospital there can be multiple users responsible for entering the data
- I created a mockup of how the MS Access UI could be implemented using Vuetify components. You can find it here: https://www.figma.com/file/BDsQVXZIU3ZUL4GcWbOsvp/TV-Database-Web?node-id=194%3A3
- I would prefer to stick with Vuetify standards as much as possible to keep the web app flexible and reduce design efforts
- If it can be implemented easily, a light mode/dark mode switch would be nice to have (not neccessary)
BESIDES
the technical skills necessary I put a high value on good verbal and written english communication skills, because I believe good communication is key to building the right product.
## Architecture
The final production architecture/toolstack should look like the following:
- Dockerized: The application should be dockerized such that it can be run locally for testing and development and also deployed in the dockerized version
- Webserver: Nginx
- Frontend: Vue.js (with Nuxt or just Vue.js) with components from Vuetify
- Backend: Django Rest Framework
- Database: MongoDB or Postgres, hosted as a managed database on digital ocean (for development it should be possible to use a local database)
- Authentication: The Vue frontend should authenticate against the Django Rest backend with JWT
- User management: The Django admin area should be usable to users with the is_staff property to manage users and hospitals (see also the "user management and hospital management" section)
## Hosting
- The webapp will be hosted over my digital ocean account
## Deployment
- The deployment can be done by giving you SSH access to an instance or also by myself
# Management of users and hospitals
- The users are created and deleted in the Django Admin area by the superadmin
- The hospitals are created and deleted in the Django Admin area by the superadmin
- Users are associated with hospitals by assigning roles to the users for a given hospital
- The users are given roles in hospitals in the Django Admin area by the superadmin, the same applies for removing roles