YQL keeps improving

I missed this yesterday but the YQL team have pushed out a whole heap of changes to their awesome service. A full list of changes can be found in the changelog but my favourites have to be (in no particular order): INSERT/UPDATE/DELETE, post/put/delete and a bug fix allowing remote JSON to have a top-level array.

INSERT/UPDATE/DELETE

Now we can have a full CRUD stack to play with enabling use to write to the web in addition to the reading we’ve had thus far! If you’re failing to see the juiciness, think that you can now do INSERT INTO web.service (a, b, c) VALUES ("a", "b", "c") where web.service can be pretty much any open API (bit.ly and twitter examples are in the documentation) or, to put it plainly, pretty much any web site which accepts user input.

post/put/delete methods on the y.rest() method

A huge thank you for this since, tied into the above on I/U/D, this enables us to push back data to the web. I asked for this back in May since I needed it to log into a website via a POST request, saving cookies for the main request after login.

Json table now accepts top-level arrays.

A small bug fix but particularly useful for me. See my YQL forum post on this bug which arose due to my trying to query a delicious.com JSON feed.