Tutorials
How does VistaDB compare to...
Overview
Developers use various database solutions within their dot net applications, including Microsoft Jet/Access, SQL Server, SQL Server Compact Edition (SQL CE), Borland's BDE, XML files, Sqlite, and various ISAM and legacy XBase products. While these products all store and retrieve data, none of them were built with .Net in mind when they were designed.
VistaDB has been specifically engineered to overcome the various deficiencies found in each with an eye specifically to .Net developers unique needs. Why accept an unmanaged code data solution into your application lifecycle? VistaDB's unique single assembly support for Windows 64 bit is vital to your application succeeding on modern operating systems. You cannot build a single exe that supports both 32 and 64 bit and still reference these older unmanaged data engines. Unmanaged code can only be targeted to a single architecture.
Compare VistaDB to other Databases
We feel VistaDB is a great database for desktop and web dot net developers everywhere. But the following comparison pages might help you to see some of the decision points around why to use one database vendor instead of another for a specific project. Obviously a project that needs thousands of concurrent users needs a server to perform well. As with most things in programming, it comes down to applying the right technology for the right task.
Excellent
managed alternative to:
- Microsoft SQL CE (Compact Edition) 3.1 and 3.5
- Microsoft Access and JET (32 bit only)
- Xbase and ISAM (Advantage, CodeBase, dBASE, FoxPro, Paradox)
- XML data stores
- Sqlite
- RDO, DAO, and other older 32 bit data technologies
Possible alternative to:
- MSDE and SQL Server Express
- Midrange databases (Cache, FairCom, MySQL, Pervasive, PostgreSQL, Sybase)
Probably not an alternative to: