Copasetic Flow

One of the first things I always find myself doing when writing an application using the Google Visualization API Query Language is writing a simple application framework to test out my data models and queries. Rather than re-inventing the wheel on every project, I decided to just implement a simple tester here where, hopefully, everyone else can benefit from it as well. To use it, simply place the datasource URL you intend to use as well as the query string in the appropriate blanks below. Then click, 'Test Query' to see the results of the query. For example, you can try the datasource URL and a query string from the Hierarchical Chooser post. datasource URL: http://spreadsheets.google.com/pub?key=pvFXGB-79Kl2d6jU-_m44ZQ&gid=0&pub=1 Query String: Select A, B, C Datasource URL Query String

Updated March 26, 2008 12:37 PM CMT I'm coming up to speed on the new Google Visualization APIs this week like a lot of other people. As I'm working through my new application that uses this API and Google Docs spreadsheets, I'm running into some issues that aren't covered in the online documentation for the API . I'll post those issues along with their resolution here, so if you run into problems, this is a good place to look. If you run into problems that aren't covered, please add them to the comments section. Of course, the first place to look if you run into issues is on the Google Visualization API Group . Column labels don't work like you might think they should Throughout the Query Language Reference the examples use the labels from the following table: name string dept string lunchTime timeofday salary number hireDate date age number isSenior boolean seniorityStartTime datetime John Eng 12:00:00 1000 2005-03-19 35 true 2007-12-02 15:56:...

The bill summary pages are a new project on Renaissance Adventures that utilizes Google Docs and the Google Visualization API. The summary pages provide readers interested in these bills with a links to government data, news stories, and blog entries related to the bills. And, readers can update the links themselves, so that everyone can benefit from the research of the entire readership! To add a link to any section, simply use the form below each section: Clicking 'Submit' will add a new page address and title to the database. Clicking 'View Updates' will update the table above with the link you just submitted. Look for new features to be added soon like sorting by submission date and title. If you have any ideas, I'd love to hear them, please add them to the comments below. Better yet, if anyone would like to help develop this, it would be a fun open source project. Keep checking back for updated information. Also, there will be an article or two in the nea...