[ddj] SQL Vs Excel Vs Refine

[Tony.Hirst]

FWIW, there's a sql like language that dangles of the GOogle Spreadsheets API

eg Using Google Spreadsheets as a Database with the Google Visualisation API Query Language http://blog.ouseful.info/2009/05/18/using-google-spreadsheets-as-a-databace-with-the-google-visualisation-api-query-language/

Google Visualization API Query Language https://developers.google.com/chart/interactive/docs/querylanguage


It's one good place to start experimenting with SQL like queries without having to install any.

ANother place to start experimenting with SQLite queries is scraperwiki. If you go to a scraper page on Scraperwiki, then go to the scraper's API page, you can try running SQLite queries over the databases tables associated with that scraper.

tony
________________________________________
Tony Hirst
Personal blog: blog.ouseful.info

Tel/SMS: +44 (0) 1908 652789
Lecturer in Telematics
Dept of Communication and Systems
The Open University
Milton Keynes, MK7 6AA, UK
________________________________________

-- 
The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302).