Complete This Simple: API to MySQL project

***** IMPORTANT BIDDING INFORMATION: This project is to finish the work that another developer already started. You WILL NOT be building this from scratch. It should be a simple project for any developer that knows how to work with, PHP, get/post APIs, and MySQL. The vast majority of the work is already done, you will be coming in to finalize the code, check that it all works properly, install the script on my server, go through the bug fixing/QA process with me until the script is working properly. The only original work you will have to do is create a very simple HTML front end to use during QA for checking the status of the database. Please bid accordingly ******


Here is a description of the overall project so you understand what the script I have does:

I use an email platform with an API that enables stats to be read from other applications.

This project is to use that API to create a database of various metrics from the email platform over time.

The basic database schema is outlined below. The script is designed to fetch data from the email platform via the API at regular intervals. That data is stored in the database and certain data points will need to be related to each other. Additionally the script should calculate some metrics from the raw data provided by the API. The calculations are all very simple (mostly dealing with averages over time). Once these computed stats are derived they should also be stored in the database.

It is key to understand that this Database is going to be used in a future project (not included in the scope of this project) to create charts and other visualizations of the data over time. So it is key that all the data be stored in well named and well organized tables for easy access and use in the future. This is one of the key areas where you will be working to optimize the current script as I think the naming and organization of the tables is lacking, particularly the time metrics are not present across all tables. When you bid please send me a pm with the first word being "optimize" to indicate you have read and understood this part of the task.

Your task in this project is limited to finishing the script that connects to the API, extracts the data, stores it in the local database, calculates the computed metrics I am looking for, and stores them in the database.

The only part that you will need to build from scratch is a front end development task to create simple HTML pages that display the data from the Database for easy debugging and quality assurance.

The current code is attached. I will provide you with detailed info on the API once you bid but it is very simple. If you need any further information please do not hesitate to ask detailed questions via PM and I will respond accordingly.

*** BONUS: Successful completion of this project on time and on budget will lead to significant amounts of additional work! This project is only phase 1 of a larger project I have planned and I am looking for a partner to move forward with the other phases as soon as this project is done. Consider this an audition and bid accordingly!

Thank you for your time, I look forward to answering your questions via PM, and potentially working with you!


Compétences : Administration de Bases de données, Javascript, MySQL, PHP, Web Scraping

en voir plus : working at the limited, where to look for a php developer, what does php developer do, scope of php developer, scope for php developer, project end time, php intervals, Mysql questions, mysql data access, look for script developer, how to present a bid, how to php developer, how to get organized at work, how to create php pages, how do i get to work from here, charts php developer, part time php, where to work at 15, what is front end development, javascript and mysql, how to be organized at work, look for api developer, how do i install javascript, very simple only task, simple coming soon

Concernant l'employeur :
( 44 commentaires ) San Francisco, United States

Nº du projet : #1678653

Décerné à:


#iambobydigital I am confident I can deliver this, you will not be disappointed! please see PM.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(12 Commentaires)

8 freelance font une offre moyenne de $234 pour ce travail


I am ready to optimize the code

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(112 Commentaires)

Experienced and serious team specialize working in any Open Source like wordpress, joomla, Open Cart etc., latest web trends like RSS, WEB 2.0 standard, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Sym Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(94 Commentaires)

Hi. I understand about the current project status and what to do. Please give me detail. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(132 Commentaires)

Hello, please see the PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(31 Commentaires)

Hello Let me do this project Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(40 Commentaires)

I am new on freelancer but having 5+ years of experience in web development and 2+ years of experience in J2SE/J2ME. If I get this opportunity, you will get work satisfaction and good relationship.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)


%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Custom Software Development - <b><i>Removed by Admin</i></b>

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)