Monday, 17 June 2019
Main Menu
Web Links
Blog Links
Musical Links
Nerdery Links
Other Neato Links
VistaDB 2.1 database for .NET has been released...
User Rating: / 1
Written by WATYF on Monday, 31 October 2005 (12360 hits)
Category: .NET Programming

VistaDB just put out a new version of their .NET embedded database. Here's the blurb from their site:

This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio .NET 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, data management and data migration tools. Free trial is available for download.
- Learn more about VistaDB
- Repost this to your blog and receive a FREE copy of VistaDB 2.1!

I'm still running into problems with the integrity of SharpHSQL, and even though I had trouble with the trial version of VistaDB in the past, I am looking forward to trying to integrate this new version into TaskRunner. The instabilities of #HSQL are getting to the point where I can't even code enough to account for them all, so it's time to take a serious look in another direction, and hopefully, VistaDB will be it...

One of the interesting things to note in that press release is the mention of a free, 2-user server using TCP/IP. One of the (main) reasons I abandoned being able to run TR as a service (along with the windows UI) was due to the fact that embedded databases are made to be accessed exclusively by one process. But if this new release allows me to setup a server to listen to requests to/from the windows app, then I may be able to work out a way to run both the service and the app at the same time. Obviously a change like that won't be happening in the first 3.0 release... but at least it gives me something to look forward to in the future, assuming that VistaDB ends up meeting my needs.

Either way... I will post an update on my progress once I get the new version and try it out.



< Prev   Next >


You must javascript enabled to use this form

Thanks for posting Jason. Ii just wanted to comment on how our VistaDB Server works so you gauge things better. VistaDB supports both embedded mode (via an unmanaged flat .DLL) and we create a VistaDB Server that is actually an application that is built using our VistaDB embedded engine (this is an .EXE). The VistaDB Server can run as a Windows service or as a console app -- both console app and service listen on a port and provide high-speed TCP/IP connectivity to your .VDB databases.

You have total control over how the VistaDB embedded engine works. You can open the .VDB database in shared mode or exclusively, or in read-only mode which is needed for CD-ROM apps. The thing to note is that the VistaDB Server opens the .VDB exclusively and efficiently manages each connection and request to hit the data (updates and reads). The key to achieving speed is to open the .VDB exclusively -- that's why we do that. We had older technology that would open the database in shared mode and would launch each connection in a thread but the performance wasn't there. So, thats the story. Your idea to allow shared access to the file from the server is interesting. I mean, keeping our same architecture and not resorting to threads again. Let me ask my guys and see what they think. If it can be done easily, we'll try to get it into 3.0 due out the middle of 2006.

Thanks again for your support.

Anthony Carrabino

Posted by Anthony Carrabino, whose homepage is here on 10/31/2005 at 07:59

Thanks for clearing that up Anthony. I will be trying out VistaDB first thing tomorrow, so I'll let you know how it works out. As for the multi-process issue... basically, I have a heavily multi-threaded app, and I've gotten a few requests to convert the app to a service. But I also need a windows GUI portion of the app. So both the service and the windows app would need to be able to hit the DB synchronously. Up to this point, I've just decided to forego running it as a service, because of the inherent limitations of embedded db's, but I will look into your server service and see if I can integrate that in the future. It may not be possible, because it looks like the service locks the DB with each transaction (yes? no?), so my multi-threading will (as usual) cause me problems there... but at least it gives me a new avenue to explore. WATYF

Posted by WATYF, on 10/31/2005 at 08:39

this was really helpfull thank for this code. pl post something related to this with a rollback transaction

Posted by john, on 03/25/2007 at 20:07

Page 1 of 1 ( 3 Comments )
©2007 MosCom


© 2019 Musical Nerdery
Joomla! is Free Software released under the GNU/GPL License.