From: Robert Simpson <*****@*****.com> Rcvd: 2006-06-17 09:57:33 Id: 40886 Subject: [sqlite] SQLite Vs VistaDB - Comparison ??? > -----Original Message----- > From: RohitPatel9999 [mailto:*****@*****.com] > Sent: Friday, June 16, 2006 1:58 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite Vs VistaDB - Comparison ??? Getting back on track ... > VistaDB > HomePage : www.vistadb.com > More Features : www.vistadb.com/features.asp > VistaDB is a commercial embedded SQL database engine (only > for .NET and > Win32) Only supports Win32 desktop. No 64-bit available, no CE support either. OleDB support is missing some features, and the .NET 2.0 provider is a recompile of their 1.1 provider and has almost no support for any of the ADO.NET 2.0 features. > Encryption?: Secure Blowfish encryption and password protection There are several of us providing free SQLite implementations with built-in encryption. > Platforms? : For Different Window Versions Again, only 32-bit desktops. There is a CE provider that lets you connect to a desktop database over the wire, but there's no embedded version of VistaDB for CE. > Fast performance Not. VistaDb is slower than Access/JET in nearly every test I ran, from bulk inserts to simple indexed joins to multi-table joins. Access trounced VistaDb in every category -- and SQLite trounced Access in every category. > International support > Supports C#, VB.NET, Delphi, C++Builder, VB and classic ASP There've been lots of complaints about VistaDb's international support. It has no unicode or UTF8/16 support. > More Features : www.vistadb.com/features.asp > > > Please put forward your views, ideas, thoughts, comparisons > (if any) ??? I > might have missed many points of comparison/similarity. VistaDB's database size is also massive, but its one area that it beat Jet in my tests: http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|