tag:blogger.com,1999:blog-9144505959002328789.post5726721856572102799..comments2024-03-28T11:39:50.622+01:00Comments on Karlsson on databases and stuff: Some JSON pleaseKarlssonhttp://www.blogger.com/profile/04874338187076980133noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9144505959002328789.post-6212081898665394442012-05-31T11:24:06.011+02:002012-05-31T11:24:06.011+02:00Yepp, I've seen that. Stewarts work is great, ...Yepp, I've seen that. Stewarts work is great, curl to access MySQL is a real cool idea. As for JS in the server, again, this is brilliant.<br /><br />What I am aiming for is slightly different though, so we can all play. My idea was to allow JSON data to be imported and exported to / from MySQL. In the process, I want to massage the data so as to, as far as possible, break up a JSON Object structure into traditional SQL TABLE format.<br /><br />My think is more for those that have a JSON data source or target and want to exchange data with MySQL.<br /><br />All this said, I'll sure have a closer look at what Drizzle does in this area and give it a shot. And I'll do some more JSON and JavaScript blog posts.<br /><br />/KarlssonKarlssonhttps://www.blogger.com/profile/04874338187076980133noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-87611330714090727582012-05-30T20:53:52.651+02:002012-05-30T20:53:52.651+02:00Hi Anders
I agree, JSON is the new XML. I've ...Hi Anders<br /><br />I agree, JSON is the new XML. I've been exploring this area last year in the form of a Drizzle plugin. You've probably noticed it in my blog http://openlife.cc/category/topic/drizzle The plugin will get some serious love this Summer in the form of a GSoC project.<br /><br />Anyway, we've been focused mostly on actually providing JSON based access over HTTP. Stewart implemented and API where you use SQL and get the result set as a JSON array. Me and Mohit are working on a key-value kind of API which somewhat resembles CouchDB and MongoDB.<br /><br />I've often thought that this plugin could be backported to MySQL too. I'm happy to help if that would be interesting to you.<br /><br />Otoh, if you're mainly interested in JSON as an export/import format, then it is maybe not what you were looking for. In that case you might be interested in lib_mysqludf_json http://www.mysqludf.org/lib_mysqludf_json/index.php (...or not, I've always found them a bit lacking in terms of actual usefulness / ease of use)hingohttps://www.blogger.com/profile/09201666166374161923noreply@blogger.com