This post originated from an RSS feed registered with .NET Buzz by James Avery. Original Post: VistaDB or Sqlite Feed Title: .Avery Blog Feed URL: /blog/Install/BlogNotConfiguredError.aspx Feed Description: .NET and everything nice Latest .NET Buzz Posts Latest .NET Buzz Posts by James Avery Latest Posts From .Avery Blog

I am thinking about smart client architecture and trying to decide what the best local data store would be, either VistaDB or Sqlite. I thought about SQL Server 2005 Express, but the install requirements put it at a severe disadvantage to either of these super light databases.

Anyone out there have any experience with either of these databases? What about using NHibernate with them? I am leaning towards sqlite, especially after I looked at these benchmarks and the fact that there is already a nhibernate dialect for sqlite. (not to mention it’s free, open source, and has a very high space limitation)

-James