Đang Thực Hiện

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!

-Bobby

Kỹ năng: Quản trị cơ sở dữ liệu, Javascript, MySQL, PHP, Web Scraping

Xem thêm: working limited, scope php developer, project end time, php intervals, mysql questions, mysql data access, look script developer, present bid, get organized work, create php pages, charts php developer, part time php, organized work, look api developer, simple coming soon, simple api work, qa project, optimize mysql, metrics, get project, extracts, email api, database calculations, data visualizations, building simple

Về Bên Thuê:
( 44 nhận xét ) San Francisco, United States

Mã Dự Án: #1678653

Đã trao cho:

csolutionsuk

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

$160 USD trong 5 ngày
(12 Đánh Giá)
4.6

8 freelancer đang chào giá trung bình $234 cho công việc này

srinichal

I am ready to optimize the code

$325 USD trong 5 ngày
(112 Đánh Giá)
7.3
webedeveloper

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 Thêm

$500 USD trong 10 ngày
(94 Đánh Giá)
6.8
keiespro

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

$250 USD trong 5 ngày
(132 Đánh Giá)
6.4
ooctavianus

Hello, please see the PMB

$200 USD trong 4 ngày
(31 Đánh Giá)
5.7
KRodri

Hello Let me do this project Thanks

$70 USD trong 2 ngày
(40 Đánh Giá)
5.7
pyxisadler

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.

$150 USD trong 3 ngày
(1 Đánh Giá)
1.8
Angelinarock

HELLO SIR PLEASE CHECK PMB

$220 USD trong 3 ngày
(0 Đánh Giá)
0.0
GfJMN3r80

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

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0