You are viewing fallenpegasus

entries friends calendar user info My Website Previous Previous Next Next
Mark Atwood - Wishlist, web enable pieces of MySQL server and client
fallenpegasus
fallenpegasus
Add to Memories
Share
Wishlist, web enable pieces of MySQL server and client
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.

Tags:
Current Location: Digital Training & Design Inc; 16200 Addison Rd, Ste 200; Addison TX 75001; US

Comments
From: mmmysql Date: December 6th, 2007 10:55 pm (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).
From: erikwett Date: December 8th, 2007 08:56 am (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
2 comments or Leave a comment
profile
Mark Atwood
Name: Mark Atwood
Website: My Website
calendar
Back August 2013
123
45678910
11121314151617
18192021222324
25262728293031
page summary
tags