Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can Someone Explain VistaDB Please?

I'm seeing it pop up more and more and not really understanding the purpose of it? Can I only use it when I am developing locally on my desktop?

Or can I put a commercial site on a server with say Win2003 thats using VistaDB? Is it faster than using a SQL DB? Is it secure?

Confused...

like image 815
YodasMyDad Avatar asked May 28 '09 15:05

YodasMyDad


People also ask

How to get data out of a VistaDB database?

If that really is a VistaDB database, it would be VistaDB 2. You can't get that version anymore, but the VistaDB 3 migration wizard can get the data out of it. If this is something you need for your company contact us by opening a support ticket at VistaDB.net.

What is the difference between VistaDB and data builder?

Each database is a single file with your full schema and data. Backup and restore is as easy as copying files. Data Builder is a powerful yet easy-to-use application that lets you visually create and manage VistaDB databases.

Does VistaDB work with Microsoft Visual Studio?

In addition, VistaDB works with various ORMs and other third party tools. VistaDB integrates tightly with Microsoft Visual Studio 2019, 2017, and 2015 so you can create databases and alter their schema, indexes and more directly inside Visual Studio.

What is the VistaDB engine?

The VistaDB engine is a single, small managed assembly you deploy with your app and each database is a single file. No hassles with different versions for x86 versus x64.


1 Answers

VistaDB is a .NET alternative to the lightweight database systems offered by Microsoft: Jet (Microsoft Access), MSDE, Sql Server CE or Sql Server Express. You can use it in any .NET application where you need a database and you don't really want the overhead of having a client/server database.

VistaDB is an embedded database (some other embedded databases are SQLite and FireBird). This basically means that your database is totally "invisible" to your end users. They don't need to install a client/server database like SQL Server for instance. Deploying VistaDB is simple. All you need is the database file and a reference to the VistaDB runtime DLL within your application.

A commercial application that uses VistaDB for it's backend is Graffiti CMS.

like image 94
Praveen Angyan Avatar answered Sep 23 '22 15:09

Praveen Angyan