Science Hack Day, Mendeley YQL Tables

It’s been a long time since my last post, I’ve mostly been busy down in London working at Mendeley and it’s gone very quickly. This has recently lead me to the Science Hack Day last weekend where I met some great people, learnt many things and hack on some YQL tables for Mendeley’s new api for their research data.

YQL is quite a cool piece of technology which basically lets you treat the web as a big SQL table, so you can effectivly join twitter to a google search, then grab some usage statistics from the Mendeley api for example.

I’ve put the Mendeley YQL tables up online here to play with in the YQL console here. With this you can do queries like :-

SELECT * FROM mendeley.search WHERE query = “information retrieval”

And then start joining our different api calls together like this :-

SELECT title, year, stats FROM mendeley.details WHERE id IN (select id from mendeley.tags(50) where tag = “genetics”) | sort (field=”year”, descending=”true”)

I’m trying to get them in the community tables in github soon so that they can be more easily used by everyone, and I don’t have to keep them up on dropbox (even how amazing that is for rapid prototyping of YQL tables).

About these ads

1 Response to “Science Hack Day, Mendeley YQL Tables”


  1. 1 blogger-newbie June 22, 2010 at 10:36 am

    nice thread, thanks . i like ur weblog


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




About Me

I'm a student at Edinburgh University studying Artificial Intelligence. Find out more about me and my projects on my website

Twitter Updates

  • @npowerhelp Thanks for sorting the problem, if only the rest of NPower support was as efficient as their twitter team... 1 week ago
  • @npowerhelp Thanks that's great. Far easier to wait in a twitter queue then a phone queue! 3 weeks ago
  • @npowerhelp sure will DM now. 1 month ago
  • @npowerhelp your service is diabolical. Its taken over 6 months to try and close an account. You better sort this when you phone back in 1h. 1 month ago
  • RT @StevenLDN: UKIP spokesman "We don't tend to do well in London because it's cultural, educated and young" doesn't that say it all? .@yun2 months ago

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: