Web frontend for measurement data in MySQL database

Budget $200 - $300 USD
Bids 9
Average Bid $261

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.

Post a Project Like This

This project was awarded to

nitelfreelance

Amazin guy! I didn't trust him at the begining couse, He don't specify that he can code for D3.js on his profile. And I needed help connectinc a chart that usese D3.js code, Mysql, php, and JSON. But he fixed it in no time. And really well documented what changes he has made on the code so you can see and understand what he has changed and why. We keep in touch! Best regards from Barcelona!
About the Freelancer
nitelfreelance Profile Picture

programming

Looking to make some money?

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

Bids on this Project

  • dataino Profile Picture

    dataino

    Finale Ligure,  Italy

    Arduino MQTT MySql PHP Jquery Visual Basic Access

    PHP, ASP, C Programming, and Java

  • atopcoder Profile Picture

    atopcoder

    Cairo,  Egypt

    Expert in C/C++, Java, AJAX, JavaScript, CSS, HTML, I've 3 years of experience in Java and AJAX based applications with GWT/GXT, and some security tricks

    Java, Javascript, XML, and Web Security

  • anuyadav1 Profile Picture

    anuyadav1

    narnaul,  India

    Languages and Technologies - Python, Django Java c# , c++ PHP, HTML , Javascript , CSS Linux Admin Ruby on Rails Raspi Android Application Databases - MySQL, Postgresql, MongoDB, sqlite

    PHP, Perl, C Programming, and Java

  • rsen75 Profile Picture

    rsen75

    Chennai,  India

    15+ years experienced with strong knowledge of API / Payment Gateway integration and php with mysql, Plugin development and designing see my few portfolio **CSM and eCom** Magento / zencart / nopCommerce / drupal/ Shopify /Prestashop / X-Cart /CS-Cart / OpenCart / oscommerce / WooCommerce / CubeCart / WPEC / Virtuemart / WHMCS / A2Billing / wp-invoice / classipress / Wordpress /joomal k2/ ClientExec / Joomla /osclass **Payment Gateway** CCAvenue / BillDesk / EBS / FCMB / Stanbic IBTC/ HDFC / ICICI(PaySeal) / FirstData / Intuit / Alipay / eWay / MIGS / Bitcoins / Stripe / PayU / Payza / Citrus / InterSwitch WebPAY / VoguePay / GTPay / ubawebpay / FXP / billdesk / eComcharge / Passcourses / PXPay / Jambopay / Payex / HiPay / VTN / IecPay / DRS EPP Registrar Module / virtual merchants / sagepayments / checkout.fi / Braintree / ePDQ / 2checkout / saferpay / smoovpay / RDP / poli / CCNow / 2000charge / LLMerchant/ enets / ClickBank / SEYLAN bank / Sampath Bank and etc

    PHP, Perl, ASP, and Javascript

  • darkknight2012 Profile Picture

    darkknight2012

    Hanoi,  Vietnam

    Hello, I have a lot of experience in PHP, MySql, Smarty, HTML, CSS, Javascript, jQuery, Ajax, Joomla and Wordpress.

    PHP, AJAX, Joomla, and Shopping Carts

  • p4provider Profile Picture

    p4provider

    Islamabad,  Pakistan

    We are a software and web development company, established in 2010 with the aim to provide high quality services in all major open source technologies (i.e. Magento, Prestashop, Wordpress, Joomla, Drupal and Php/MySql ) and as well mobile technologies such as iOS ans Android. Our expert services ranges from small to medium and large scale businesses. We have successfully completed 170+ projects for small to medium and large scale organizations/ businesses at freelancer.com with great feedback and ratings. We are top the magento developers among thousands of developers We have dedicated developers and designers for the said technologies. We use core coding/designing standards & techniques and provide 100% quality and productivity work within specified time-frame accordingly. Our consultation services shape an efficient, effective and scalable online presence for eCommerce.

    PHP, Java, Python, and Script Install

  • nitelfreelance Profile Picture

    nitelfreelance

    Sharjah,  United Arab Emirates

    programming

    ASP, Java, Javascript, and XML

  • MCITBEST Profile Picture

    MCITBEST

    Bhopal,  India

    We (MCIT) are a leading web development company providing high quality professional solutions across the globe. we have more then 5 years of experience in Web development. We have expertise in PHP, MYSQL,JAVA, Ajax,Jquery,ASP.Net, My SQL Server and Open Source technologies. We believe in work quality, customer satisfaction and timely delivery of projects for better and long time relationship with customers. You can feel the professionalism on our works.Success is our Vision in implementing the website timely and in a quality manner. in addition to technical skills, we bring an excellent ...

    PHP, C Programming, Java, and .NET