Web frontend for measurement data in MySQL database

  • Status Completed
  • Budget $200 - $300 USD
  • Total Bids 9

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.

Get free quotes for a project like this
Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online