Bug #8250 Simple XML-RPC interface
Submitted: 2 Feb 2005 1:48
Reporter: Brian McConnell Email Updates:
Status: Open Impact on me:
Category:MySQL Server: XML functions Severity:S4 (Feature request)
Version: OS:Any (cross platform)
Assigned to: CPU Architecture:Any

[2 Feb 2005 1:48] Brian McConnell
I am looking for a simple xml-rpc interface for mysql. I am currently working on a project in Python, and 1) need to eliminate any platform specific code or C source that needs to be compiled to allow for trivial installation, 2) make the application as small and simple as possible.

If enabled, MySQL would act as an http/https server on a given port, and would listen for XML-RPC requests. A simple interface that allows the user to submit SQL expressions and receive message or XML recordset in response would suffice.

A minimal interface would expose three methods: open(username, password, table, optional params) ... responds with hex session key, exec(sessionkey, sql_expression) ... responds with XML recordset, close(sessionkey).

I believe that this would be a generally useful feature, as it would substantially reduce the amount of code required to talk to MySQL. While it wouldn't do everything, it would work well enough for many situations.

This could be simplied further to a simple http/https POST transaction with specified parameters. The MySQL server would reply with an XML document. (I am not hung up on XML-RPC, just want a minimal embedded http/s server within MySql.

NOTE: this could just as easily be applied to other rdbs, call it SQL-RPC, simpleSQL or something like that. 

Thank you.

How to repeat:
see above

Suggested fix:
see above
[14 Feb 2014 9:19] Daniƫl van Eeden
Related: There now is a memcached interface available.

This could be implemented as a daemon plugin. (See http://www.packtpub.com/mysql-51-plugin-development/book)