Web frontend for measurement data in MySQL database
$200-300 USD
Paid on delivery
We're looking for a web developer to design and implement a web frontend that shall present measurement data stored in a MySQL database. The measurement data is from a wireless sensor system that samples data from "endpoints" with certain intervals, this system is already in place and data is present in the MySQL database. As a proof of concept we have written a simple web frontend that you can use as a reference if you wish, this web frontend consists of a backend perl cgi script that query the SQL database for data based on a URL and sends this data over to the browser in JSON format. Finally the browser uses the Google visualization API to present an "Annotated Timeline" graph to the user.
Data in the SQL database is stored in a relational manner where information about the endpoints location, how many sensors that are present on each endpoint as well as sensor type is present.
This project is about redesigning the web frontend to meet the following criteria;
1) No dependencies on any web technology that doesn't work across a standard Android, iOS and Linux/Windows desktops. Googles "Annotated Timeline" uses Flash for example which is not acceptable.
2) Ability to select which endpoints data that shall be visible. Here I'd like to have a front page where I can get an overview (maybe using gauges and bars that shows the last measurement from a selectable set of sensors). We also need the ability to "dig deeper" and graph sensor data as a function of time for a selectable number of sensors per graph. The timespan needs to be selectable as well.
3) It shall be possible to maintain and/or extend this web application using a simple text editor, ie no dependencies on commercial IDEs. Use standard techniques such as javascript, perl, python, ruby, PHP etc etc.
4) The web application needs to work on a standard Linux apache webserver, no Microsoft or commercial software dependencies allowed.
Finally it is also possible to send data to the endpoints through a socket connection with an access point "server". This is not part of this project but the design shall not prevent such extensions in the future.
Bidders, please present an idea of how you would solve this task (not just "I can do it"). You will get access to a dump of the MySQL database as well as existing "proof of concept" web frontend.
Project ID: #4973422
About the project
Awarded to:
Hi. I can do this project using python and a framework like FLASK. For the charts the canvasjs can be used. We need to talk about your clients browser becuase most of the IE versions have problems showing such featur More
8 freelancers are bidding on average $260 for this job
We have all the required designers and developers according to your project and we can allocate dedicated resources to your project. You will be very happy and satisfied with our services.
hello mr dninl, I am very interested in your project but I am not sure I understand your requirements so far. Please explain it, I will sent you a demo link. Give me a chance you won't regret it. Thanks and regar More
Hello dnil, I have read your requirements and I am very confident to do this project. I guarantee complete satisfaction before payment. Please check PM for more details, Thank you!
can we use django for front end and backend python script. no flash required and no any other dependency..