Web Interface to extract MYSQL data

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.


- 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!

Skills: Java, MySQL, PHP, Web Security, Web Services

See more: mysql web service interface, web interface mysql, writing to a file java, writing to a file in java, writing certificate, web service for developers, web interface for postgresql, web developers tools, web developers requirements, web developers list, web developers job, track quotes, track 1 data, tools web to developers, project of web designing, mysql data access, local web developers, java writing to a file, interface security, individual web developers

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #6168225

20 freelancers are bidding on average $799 for this job


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)

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)

Hello, I have read your post and understood your requirement. I have good experience in handling Java/PostGreSQL/Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3/PHP/ Yii framework/Javascript/MySQL/ Kindly go th More

$789 CAD in 10 days
(106 Reviews)

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

$1315 CAD in 21 days
(540 Reviews)

Dear Hiring Manager, We are ready to work with you, Our company is expert in all type of Web Scrap, Data entry and Data Research work in excel, word and csv. which can use various functions like Vlookup, concatenate More

$700 CAD in 14 days
(192 Reviews)

1. Vollks Australian Online Store In these days we are complete re-designing and reimplementing an online store for our Australian client in which we are using X-Cart latest stable release to implement his all require More

$994 CAD in 18 days
(98 Reviews)

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [login to view URL] More

$526 CAD in 10 days
(276 Reviews)

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)

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)

My team is really interested in this project as it is exactly within our scope of expertise: We are WEB application design & development experts. Please kindly visit our website [login to view URL] to learn more about us and More

$2444 CAD in 30 days
(18 Reviews)

We are expert in designing and [login to view URL] have seen the project requirement [login to view URL] want to talk to [login to view URL] have a look at below link. [login to view URL] [login to view URL] http://de More

$833 CAD in 10 days
(107 Reviews)

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)

Hello Sir/Madam, I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for this project. My skills include Web Design, Graphic Design, and Web More

$631 CAD in 10 days
(53 Reviews)

I'll be able to do all your Mandatory Requirements.I'm a php [login to view URL] regarding your Value-add requirements ,Everything that is related to mysql/linux/php,i'll be able to do that except anything abou java.

$700 CAD in 5 days
(7 Reviews)

PHP [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

$550 CAD in 12 days
(15 Reviews)

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)

About Me: • More than 5+ years of experience in object-oriented analysis, development, testing, and integration of scalable, multi-tier distributed enterprise business applications. • Strong knowledge in working with More

$555 CAD in 10 days
(7 Reviews)

Hello Sir, We have 5.5+ years of experience in JAVA/J2EE/PHP. We will complete the project in given time period with great [login to view URL] believe in maintaining long term relation. We will provide 30 days free suppor More

$444 CAD in 10 days
(2 Reviews)

My experience comes from working in projects of medium to large dimension. I coordinated groups of 3 to 12 people in jobs involving web portals and integrations systems,with technologies such as application servers, More

$555 CAD in 10 days
(0 Reviews)

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)