Interfacing with MySQL Database via HTTP

Question

I'm working on a project that involves linking my C# application to a MySQL server. The server is running cPanel and the company does not allow all IPs to connect to it (although you can add host IPs to the remote list). The application will be running on Windows 8 Tablets on a 3G connection, so obviously I will not know the IPs if the devices to be able to add them to the list.

A collogue of mine has told me of a system, API or something like that that will allow me to interface with the Database via HTTP effectively bypassing this restriction.

I can provide more information if needed.

Does anyone know of anything similar to this or any way around this?

Didn't that colleague mean "Write a web service that talks to the database and let your app talk to the web service"? — CodeCaster
– CodeCaster, Commented Feb 4, 2015 at 22:26

Icemanind · Accepted Answer · 2015-02-04 22:24:10Z

2

If you are using MySql 5.7 or higher, there is an experimental "lab" for allowing direct access to MySQL via a REST over HTTP interface, eliminating the need for a middle-tier server or database specific drivers.

You can download the plugin at the MySql Labs site. From the dropdown, select "MySQL HTTP Plugin" and you should be good.

Keep in mind that its part of the "MySql Labs" project, which means its experimental, probably buggy and should be used at your own risk. Think twice before using them on any kind of production server.

answered Feb 4, 2015 at 22:24

Icemanind

48.9k52 gold badges182 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Interfacing with MySQL Database via HTTP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related