Web frontend for measurement data in MySQL database

IN PROGRESS
Bids
9
Avg Bid (USD)
$261
Project Budget (USD)
$200 - $300

Project Description:
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.

Skills required:
MySQL, Software Architecture, Software Development, Website Design
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 309
in 8 days
$ 250
in 10 days
Hire darkknight2012
$ 200
in 10 days
$ 263
in 12 days
$ 270
in 5 days
Hire anuyadav1
$ 222
in 3 days
Hire atopcoder
$ 277
in 5 days
Hire dataino
$ 333
in 20 days
$ 222
in 8 days