Home
November 2009   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Wishlist, web enable pieces of MySQL server and client

Posted on 2007.12.06 at 10:26
Current Location: Digital Training & Design Inc; 16200 Addison Rd, Ste 200; Addison TX 75001; US
Tags:
SELECT OUTFILE should be able to write to a popen pipe. And it should be able to write to a URL. And it should be able to do XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

LOAD DATA INFILE should be able to read from an popen pipe. And it should be able to read from a URL. And it should be able to understand XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

In the MySQL command line client, it should be able to source a URL on the command line. Inside the MySQL command line client, it should be able to source from a URL and from a popen, and tee to a URL and a popen.

Comments:


[info]mmmysql at 2007-12-06 22:55 (UTC) (Link)

LOAD DATA INFILE

The JDBC driver and the "mysqli" PHP interface allow URLs for LOAD DATA LOCAL INFILE. I'd love to see it for libmysql (as long as it can be disabled for security reasons as well).

The C API itself already has hooks for LOAD DATA LOCAL INFILE to let you plug in a custom stream, so from the client side, using this with popen() should be trivial.

I know this doesn't help from the server side, but most applications can find a way to make this work (other than the parsing of xml, json, etc).
[info]erikwett at 2007-12-08 08:56 (UTC) (Link)

LOAD XML

Hi Mark,
In MySQL 6.0 (or 5.2??) there is actually a LOAD XML command, so a small part of your wishlist is already in place. But there is still the problem of reading form something other than a file, which is needed to make it really useful. I hope to have the time to implement some of this in the future. Check out http://eriksdiary.blogspot.com/2007/12/web-enabling-mysql.html
Previous Entry  Next Entry