A database in the clouds¶
Using the Google Spreadsheets API¶
- Lots of Python community support
- http://docs.google.com/Present?docid-dcmg89gw_70g6ct9jcz
- http://spreadsheets.google.com/ccc?key-pKq0CzjiF3YnZ5oeOipDoEA&hl-en&pli-1
Why?¶
- Server-side - streaminline server
- Portable
Challenges¶
- Might be slower
- Requires internet connectivity
- Caching helps and gives you best of both words
Why google spreadsheets?¶
- Free
- Available anywhere
- Scalable
- Restful API
- Nice UI
GoogleSpreadsheet API¶
- Web service based on AtomPub
- Series of related Atom Feeds
What sort of Database¶
- Non relational
- Supports queries
- Multiple concurrent users
- access controls
Simplified Interface¶
- gdata.spreadsheet.text.db
- Keep it simple
- for mashups
- text data only
Searches¶
- Ranges, equals, and more fun