Web Interface to extract MYSQL data

Closed Posted Jul 9, 2014 Paid on delivery
Closed Paid on delivery

SKILLS/TOOLS: PHP, Java, Web Security, Web Services, MySQL, POSTGRESQL, DEBIAN

The project requires an individual with expert PHP and a solid grasp of designing/writing secured Web services. Please read an understand my requirements before saying "you can do it". Anyone who does not read will be ignored.

Background

- An open source server application running on Debian is written in Java and uses MySQL.

- A web service using a PHP SLIM framework exposes data directly my the MySQL Database.

- A client application written in PHP polls this web service to receive the data and stores in appropriately in a POSTGRESQL db.

Mandatory Requirements

1. Modify PHP SLIM service to extract a larger set of data from MySQL database. A list will be provided.

2. Create a business rule that either on server side that prevents extraction of the data unless a "flag" is on. This flag is also stored in the MySQL db.

3. Ensure that the service is secured and cannot be penetrated by common security threats.

4. Document all changes and provide testing support.

The mandatory requirements should be quick and I can provide remote support 24/7.

Value-add requirements (Billing & Monitoring)

1. Rewrite the PHP slim service in Java.

2. Allow this interface to be tokenizable and licensable. e.g. I can distribute the API and enable to API by issuing a time-limited certificate.

3. Allow remote disabling of web services if license is revoked or expired.

4. Allow local and remote tracking of the number of times each web service is called. The tracking can be in the form of a text file that can be retrieved via SSH. Must track token ID, date of issue, date of expiry, number of times web service has been called, number of times web service is successful / fails. Write access by only authorized users.

5. Create an auto-deployment package for the web service in a Debian environment.

6. Ensure that the service is secured and cannot be penetrated by common security threats.

7. Document all changes and provide testing support.

I would like to get two quotes. One for the mandatory requirements and another for the value-add. I expect the effort to be small for the mandatory. I prefer expert level skills who are highly available and can complete the job in a matter of days.

No shops who have developers that work around the clock. Terrible experiences with you guys!

Java MySQL PHP Web Security Web Services

Project ID: #6168225

About the project

20 proposals Remote project Active Aug 15, 2014

20 freelancers are bidding on average $799 for this job

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$773 CAD in 10 days
(161 Reviews)
9.3
rajeshsonisl

Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wron More

$1473 CAD in 7 days
(918 Reviews)
8.5
rabbul

Hi I am confident to do this job. ========================================================================= thanks

$1315 CAD in 21 days
(540 Reviews)
8.3
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 CAD in 5 days
(252 Reviews)
7.3
IMSeriousBidder

Hello Sir, I am a Java/Php developer with high skills, I have checked your requirement, My quote is 800 for the basic version and 600 for the value-add version Please let me help you. Thanks Bing

$800 CAD in 10 days
(110 Reviews)
7.3
shenchilang

Hi, I'm an experienced java developer, and I'm interested in your project. I've worked on similar project that synchronizes MySQL tables via HTTPS/JSON data to client side Derby database. Hope that I can help. T More

$450 CAD in 10 days
(86 Reviews)
6.5
msteidley

I would love to continue working on this project. How did it work out with the other freelancer to modify the api?

$450 CAD in 10 days
(5 Reviews)
3.8
J2eeWSDeveloper

Hi Interested to work with you and looking forward to hear from you. Details about my skills and experience : Having 10 years of experience in the field of Software Development. Good command on the Software More

$750 CAD in 10 days
(0 Reviews)
0.0