[Gtk-sharp-list] Embedded DB or Cached Dataset

[Adam Tauno Williams]

On Thu, 2010-09-23 at 23:48 -0400, Aaron Radich wrote:
> I'm creating an embedded Mono GTK# application that needs to maintain  
> a single table with 100K records in it.  What's the best way to go  
> about doing this?  Can you save a DataSet to disk and then load it  
> when the application starts up?  Or, would it be better to install a  
> DBMS on the computer that will run the embedded application?  The  
> computer will have access to the internet, but it may be intermittent  
> and i therefore want to persist the 100K record table with the  
> application.  Any suggestions would be greatly appreciated.

I've used DB4o with some luck in the past.  It is simple to use, quite
fast, and doesn't create any dependencies beyond the required assembly.
One can specify that DB4o databases are entirely in memory [ and thus
transient] or persisted on disk.
-- 
Adam Tauno Williams <awilliam at whitemice.org> LPIC-1, Novell CLA
<http://www.whitemiceconsulting.com>
OpenGroupware, Cyrus IMAPd, Postfix, OpenLDAP, Samba