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
Reader Comment - Brenton House says,
"What about Sql Server Everywhere Edition? I don't think it's out yet,
but it probably is going to ship with SQL Server 2005 SP1. It doesn't
require any kind of an install.
http://www.microsoft.com/sql/letter.mspx
http://pluralsight.com/blogs/jimw/archive/2006/04/06/21167.aspx"
Reader Comment - Jeff Lewis says,
I'm using sqllite on an Windows Mobile smart client app and it rocks.
All of the other db's I tried were too slow in this low memory
environment, but with sqllite, I was able to get reasonable query times
for the very large db that the app uses.
Reader Comment - Catherine Devlin says,
"
I've never used VistaDB, but I really love SQLite. It's just so ridiculously incredibly easy...
It's
a problem if you want multiple processes to make updates at once,
however, because it does lock the entire file for update.
Also,
I've seen the query performance become disappointing when the file size
grows beyond a couple GB. You need a lot of data to get it there,
though, because it's very low-fat (unlike, say, Oracle, which wants
about a GB before you add a single row of your own data)."
![]()