Find Jobs
Hire Freelancers

Secure mySQL connection via webservice

$250-750 AUD

Closed
Posted over 10 years ago

$250-750 AUD

Paid on delivery
I will be writing some Windows software that will connect remotely to a hosted SQL database to send and receive data on a user by user basis. I will use PHP and mySQL on the backend on a normal hosted server (the AWS is in the bid for AWS experts who can do this in AWS). Many users will use the software from many different IP addresses and the mySQL database CANNOT be directly accessed for security reasons. As the mySQL database will not be directly accessible from the web (you will need to set this up on the server also), you need to create/write a web service (JAVA, SOAP, REST, etc -- your choice -- explain the advantages to me of your approach) to connect any desktop application to the mySQL via the webservice. You will have successfully performed this bid when I can test the webservice in my windows program from a number of different IP Addresses and data is sent/received to/from the mySQL server via the webservice (not directly) and (2) the mySQL database is not directly accessible from the web. You can also use JAVA and TOMCAT if you wish (people who know how to do this work, will already understand what I mean here). I look forward to your bids.
Project ID: 5263699

About the project

30 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $519 AUD for this job
User Avatar
A proposal has not yet been provided
$526 AUD in 10 days
5.0 (309 reviews)
7.3
7.3
User Avatar
**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and extensive Website Coding (PHP, MYSQL, .NET, C#, ASP, DRUPAL, JOOMLA, DOTNETNUKE, PERL JAVASCRIPT, CSS, HTML & A LOT MORE!), Website Designing and Graphic Design for ***over 10 years now. After working as a ***top sales and marketing representative for Sears, I began to independently pursue my career. I have experience in do-it-yourself CMS, Logos with flare and flash design to name a few. I went to college for business and marketing so ***I know what it takes to sell. Get it done professionally and get it done right! Thank you, Timothy
$1,030 AUD in 10 days
4.7 (39 reviews)
7.3
7.3
User Avatar
Hello, I will use PHP to complete the work. Need to know the format you want, xml, json or other you need for the windows program, the parameters list and functionalities and logic of the whole system. I will use REST as it's supported by most of the program language and it's very simple to manage.
$526 AUD in 10 days
5.0 (263 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$684 AUD in 12 days
5.0 (106 reviews)
6.9
6.9
User Avatar
skilled java developer. developed lot of system using rest/soap technology. i can do the project for you. skilled java developer. developed lot of system using rest/soap technology. i can do the project for you.
$421 AUD in 5 days
5.0 (153 reviews)
6.9
6.9
User Avatar
please note: AWS doesn't make it any special. the actual cost may depend on the number of tables, queries. so its good if you can give some idea about them.
$309 AUD in 4 days
4.9 (113 reviews)
6.8
6.8
User Avatar
Hello, I can help you with that. I've got rich experience working with different LAMP-applications, running on AWS or not, doesn't really matter (but yes, I have done a lot of projects on AWS and have my own Ubuntu instance running there). So, I offer to use PHP as a layer between your application and MySQL, I don't know reasons why shouldn't you try this way. How big and complex will be your database? Thanks, Alex
$500 AUD in 14 days
4.9 (39 reviews)
5.9
5.9
User Avatar
Hi, I guarantee you that I can easily fulfill your needs with in the time and budget.I will support life time. You would love to work with professional who believe in long term relationships.
$526 AUD in 10 days
4.0 (25 reviews)
4.8
4.8
User Avatar
Hi First of all I'm really shocked regarding the project budget. I guess you're not fully aware of how AWS works. It's quite easy to configure MySQL so that it's not publicly accessible and is only accessed by the web-server instead. So here's how I'll do this. 1. Configure a AWS RDS Instance with MySQL and configure it's security group to be accessed only by the EC2 instance where the web-server resides, & its security group will allow 3306. It's that easy and simple. Overall project fees will be 30 USD. :) Lemme know if you've any doubt or if I'm missing some crucial point. BTW I'm an AWS expert, you can check my profile to see the different project I was involved in. Thanks Joy
$277 AUD in 0 day
5.0 (20 reviews)
4.5
4.5
User Avatar
Aucune proposition n'a encore été fournie.
$631 AUD in 15 days
5.0 (17 reviews)
4.5
4.5
User Avatar
Hello. So you basically just need to be able to send http requests from your software to a PHP page that is available likely using some kind of authentication, then have the PHP do the database query? I would likely use REST as I believe fewer layers and simplicity results in better performance. I am just finishing up an API to connect a Sagemath server via PHP webservice on an AWS server at the moment. Thank you for your time and I look forward to working with you.
$400 AUD in 10 days
5.0 (4 reviews)
2.9
2.9
User Avatar
Hi there ! So you want to create a desktop application that will use data from remote server right ? Web services is for sure good solution as it works from behind firewalls so you will have no trouble accessing it from any environment. You want the web services to be written in PHP and access MySQL - no problem . I've done it many times. The question is : are you looking for generic webservice - one that you will just send an sql query and as results get raw query results ? Or do you need an API . Of course more sens makes to make an API webservice so i.e. you call : [POST]->order with user_id=3, quantity=3, product_id=10 and API crates entry in database . Do you already know how many API endpoints you need ? I mean what kind of operations you need. Or you don't have it planned yet ? Anyway I can help you in whatever you need . It also depends for how many users are you planning this applicaiton for. 10/100/1000/100000 at one time ? Currently everybody is talking about REST or RESTish type of webservices so I would go with it, but actually there is no golden way - it's just the way that works ... I prefer returning JSON results if possible, XML if necessary ... it all depends on the job really . One thing I can assure you - if you pick me I will assist you with all my 'powers' :) . We're in different timezones (i'm in South Africa at the moment ) so we can communicate only by email. Contact me if you need anything else, I'm sure i can help you with this project
$555 AUD in 10 days
5.0 (1 review)
1.8
1.8
User Avatar
A proposal has not yet been provided
$777 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello kps007, I'm developer with 5+ experience in Java(desktop and J2EE/ Servlet ), PHP and Android. I have worked on various api creation and calling i.e. api created in PHP and Java. I have experience on HTTP/ SOAP/ REST api/webservice with response in XML/ JSON. I have gone through all requirement and this is simple work for experienced developer. No upfront payment will be asked(you will have to deposit milestone to freelancer escrow) until work i.e. code is delivered to you and your 100% satisfied with it. Waiting for your positive response and chance for further discussion. Thanks and Regards, Chanchal Shelar
$277 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Tomcat, java, REST(xml) or SOAP, jdbc(for mysql connection ) as option Apache may be added as front end (with AJP)
$597 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience with Java, web services and mySQL. In the pastI have done several integrations using web services (SOAP and REST) with different databases in the backend (Oracle, mySQL, Postgres, ...).
$560 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Ph.D Doctor in Computer Science and have more then 25 years of field experience and also running a software house in which I have done number of projects like this. I a competent team including Ph.D doctors which can handle these projects seriously and efficiently.
$622 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
416
Payment method verified
Member since Feb 21, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.