In Progress

Web frontend for measurement data in MySQL database

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: MySQL, Software Architecture, Software Development, Website Design

See more: mysql web frontend, which graph to use for data, where do you get a python, where can i get python, where can i get a software developer, we looking for sql server developer, website database design software, web script editor, web page design application software, web frontend developer, web for android design, web developer sql, web developer python, web developer overview, web developer microsoft, web developer extensions, web developer android, web design software with database, web design software windows, web design software for android, web design overview, web design for windows, web database design software, web application system architecture, we a looking for ruby developer

About the Employer:
( 2 reviews ) Torslanda, Sweden

Project ID: #4973422

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

$250 USD in 10 days
(14 Reviews)

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.

$309 USD in 8 days
(64 Reviews)

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

$200 USD in 10 days
(21 Reviews)

hi, i'm 14+ experienced with strong knowledge of API integration for many CMS see my few portfolio **WooCommerce Payment Plugins ccavenue wolrd / paypal pro /SEYLAN bank /libertyreserve/perfectmoney **Wo More

$263 USD in 12 days
(20 Reviews)

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!

$270 USD in 5 days
(25 Reviews)

can we use django for front end and backend python script. no flash required and no any other dependency..

$222 USD in 3 days
(4 Reviews)

I can help you implementing this front-end with cheapest cost, good quality of work, and within a short time limit. I'll use GXT or Vaadin as a web technology, with highcharts as a visualization library, because it' More

$277 USD in 5 days
(1 Review)

Hello, We have Experienced Professionals with 12 years of Web Development & Designing, Application Development, Desktop Application, ERP Software, Android App. Development. I-phone Development expertise. We have worked More

$222 USD in 8 days
(0 Reviews)

Hello this is my project (developed in php and jquery) for the acquisition of data from sensors with Arduino or other equipment [[url removed, login to view]], is a generic system for creating database and store data via HTTP-GET in More

$333 USD in 20 days
(0 Reviews)