Just released GDataDB 0.2. GDataDB is a database-like interface to Google Spreadsheets for .Net.
This is a maintenance release. Here's the short changelog:
- Andrew Yau implemented deleting tables and databases (which means deleting worksheets and spreadsheets respectively).
- Ryan Farley fixed a bug with read-only and write-only properties in the mapped class.
- Updated to use the latest GData library.
Also, Ryan recently wrote a nice article about GDataDB, check it out.
UPDATE 11/3/2010: Ryan Farley added GDataDB and GDataDB.Linq to the NuGet package repository. Thanks Ryan!
Mauricio,
ReplyDeleteI'm really liking your GDataDB library. I'm currently using it for a website and it provides a very elegant (and testable) extraction to using Google Spreadsheets as a data store.
I had one question about caching. In doing some performance tests, it appears the calls to IDatabaseClient.GetDatabase() and IDatabase.GetTable() are fairly expensive since they make calls over the wire, pulling back schema information. Yet, I make these calls all the time on variation pages in my website, which tends to slow things down quite a bit. How safe is it to cache these objects (IDatabase and ITable) for the life of an application or perhaps an HTTP request? Do they have any multi-threading issues?
Thanks!
~pete
Hi. This is just what I'm looking for. However, I'm completely new to this. Can you give me a very quick overview on how to integrate this? Just so I have a place to start researching. Thanks
ReplyDeleteDavid
@David Wang: See Ryan's article: http://ryanfarley.com/blog/archive/2010/09/24/using-google-docs-as-an-online-database.aspx
ReplyDeleteAlso see the sample app for guidance.