GDataDB
GDataDB copied to clipboard
mausch
A database-like interface to Google Spreadsheets for .Net
GDataDB
GDataDB is a database-like interface to Google Spreadsheets for .Net.
It models spreadsheets as databases, worksheets as database tables, and rows as records.
A few articles documenting it:
- http://bugsquash.blogspot.co.uk/search/label/gdatadb
- http://ryanfarley.com/blog/archive/2010/09/24/using-google-docs-as-an-online-database.aspx
Google has changed the authentication scheme since those articles were written. Now it requires OAuth2.
To set this up visit http://console.developers.google.com , create a new project, enable the Drive API, create a new client ID of type "service account" and download the P12 key. Use the service account email address and the P12 key as shown in this example .
If you want to access any documents from your personal gmail account, share them (edit permissions) with the service account email address (the one that looks like "[email protected]") and make sure that they're in the root folder of Drive.
Original idea for GDataDB borrowed from https://github.com/google/gdata-python-client/blob/master/src/gdata/spreadsheet/text_db.py
mausch