Using Google Spreadsheets as a Database with the Google Visualis. Wouldn’t it be handy if we could treat all the public spreadsheets uploaded to Google docs as queryable tables in a database? Well, it appears that you can do so, at least at an individual spreadsheet level: Introducing the Google Visualization API. Over the weekend, I started exploring the Google Visualisation API Query Language, which is reminiscent of SQL (if that means anything to you!). This language provides a way of interrogating a data source such as a public online Google spreadsheet and pulling back the results of the query as JSON, CSV, or an HTML table.
Got that? Google query languages are defined on a spreadsheet in the following way: Although defined, by default, to return JSON data from a query, wrapped in a pre-defined (and fixed?) Using the Guardian datastore’s MPs expenses spreadsheet 2007-8 as an example, we can write quite a wide variety of queries, which I’ll show below in their ‘HTML preview’ form. So here we go: to give this: With YQL Execute, the Internet becomes your database (Yahoo! Dev. Photo credit to events.india Now that HackU has reached Kharagpur for the 3rd year in a row, students are able to identify technical challenges facing the Web industry (e.g., Local, Social, Media, Commerce, Connections, and Content platforms). This breakthrough has resulted in a significant fraction of hacks around topics especially relevant to Yahoo!’ S core business [...]
This post originally appeared on the Yahoo! Accessibility blog. ARIA is a W3C specification that can be used to dramatically improve the accessibility of custom widgets, especially for users of screen readers. For those unfamiliar with ARIA this article aims to explain the unfamiliar through the lens of the familiar: existing HTML widgets. Coming Soon To The UK: Yahoo!’ This post originally appeared on the Yahoo! Every Thursday is Tech Thursday where we share a random assortment of technical links we found and liked.
This post originally appeared on the Yahoo! Query Language. Beautiful Forms - Design, Style, & make it work with PHP &am. Mar 09 2009 Forms needs a solid visual structure, a profound hierarchy of form elements (Fields and Labels), powerful techniques and Functionality (AJAX) to make the form look and work creatively. There is a great bunch of creative, outstanding and individually designed from scratch forms. Thanks to AJAX, we can provide real-time feedback to our users using server-side validation scripts and eliminate the need for redundant validation functions and processing data. Today we wanted to share with you some great steps to get the perfect form: we will go through designing and usability you need to keep in mind, styling your form, spicing it up with some nice javascript effects, validating user’s input and finally getting it to work using PHP and Ajax. 1.
Designing & Planning out your Form Fancy Form Design Using CSS A very useful CSS tutorial for making fancy forms with good usability. Web Application Form Design Web Form Design Patterns: Sign-Up Forms Sensible Forms: A Form Usability Checklist 2. Video Demonstration: Creating Web Input Forms with Google Spread.