SQLite C# port running in Silverlight

08-10-2009 5:35 AM |

Noah Hart ported SQLite to C#, and I hacked his code to remove the bits that did not work in Silverlight (p-invokes, file locking, replace file i/o with Isolated Storage) and posted a proof-of-concept demo:

http://www.itwriting.com/blog/1695-proof-of-concept-c-sqlite-running-in-silverlight.html

Could be interesting, maybe especially for out of browser apps running offline.

SQLite is a small local database manager that supports SQL, as the name suggests.

Tim

Re: SQLite C# port running in Silverlight

08-10-2009 8:20 PM |

 What this needs is a little CouchDB type love and have REST based syncing with a master database like SQL Server.  I am not sure if SQLLite supports a feature like "pin table to memory" so that expensive queries are not constantly hitting I/O.