Hello I was just comparing embedded SQL database engines (SQLite Vs VistaDB) for my knowledge. Itmight be of help for someone.
In case, someone might be interested to know and/or add more feature comparisons. SQLite HomePage : www.sqlite.org More Features : www.sqlite.org, www.sqlite.org/docs.html, www.sqlite.org/faq.html SQLite is a free open-source embedded SQL database engine (for multiple platforms) Cost? : Free Version (with no encryption feature, No password protection) Encryption?: Encryption extension is Commercial, need to purchase license Platforms? : For multiple platforms Source Code Available? : Yes, for free version (No Encryption) Size? : Small 250 KB footprint Single-file database format, database files can be freely shared between machines with different byte orders. Multiple threads/processes can have the same database open at the same time Supports concurrancy Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures Zero-configuration - no setup or administration needed. SQL? : SQLite Implements most of SQL92 (standard SQL language). But does omit some features and added a few features of its own. CSV and text file import and export UTF-8, UTF-16 Support Supports C/C++, PHP, Pearl, tcl, Python and many other languages through C or through own wrappers, .NET port available, WindowsCE port available. More Features : www.sqlite.org, www.sqlite.org/docs.html, www.sqlite.org/faq.html 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) Cost? : Need to purchase license, then Royalty free distribution Encryption?: Secure Blowfish encryption and password protection Platforms? : For Different Window Versions Source Code Available? : No Size? : Small 500KB footprint for Embedded Editions Single-file database format Single and Multi-User support Supports concurrancy SQL? : Easy-to-use full featured RDBMS, provides industry support for SQL-92 and powerful Direct Data Access Fast performance No deadlocks - Snapshot Isolation level Transaction Processing SureCommit Row and Table-level locking Automatic Storage Recycling XML Import and Export Automatic data synchronization In-memory databases and tables Write-behind data caching International support Supports C#, VB.NET, Delphi, C++Builder, VB and classic ASP 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. Rohit -- View this message in context: http://www.nabble.com/SQLite-Vs-VistaDB---Comparison-----t1797052.html#a4897159 Sent from the SQLite forum at Nabble.com.
