Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

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