Re: Embeddable databases

From: Gerrit (msng1_at_newsgroups.nospam)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 21:00:23 +0100

It looks like when using the embedded Firebird engine, only one user can
access the database file at the time. Do you know if this is true? Only one
user will write to the database, but it may happen that multiple users will
read from it at the same time (even though that is unlikely).

Gerrit

"Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xs4all.nl> wrote in message
news:uxOsq05DFHA.4052@TK2MSFTNGP15.phx.gbl...
> Gerrit wrote:
>> Hi.
>>
>> I'm looking for a relational and embeddable "file system based"
>> (non-client/server) database engine for .NET applications. Microsoft
>> JET (Access) is not an option, as it looks like it is being quietly
>> phased out without a replacement. So far I have found these three that
>> seem to be worth considering:
>> SQLite: http://www.sqlite.org
>> Firebird (embedded): http://www.dotnetfirebird.org
>> VistaDB: http://www.vistadb.net
>
> Firebird's embedded server is OK, however some very complex queries might
> fail. (8 joined tables or more). but then again, it's free and works OK.
> Also an advantage: a lot of tools support firebird, and with Carlos'
> excellent .NET provider for Firebird, you can develop against the firebird
> server, and move your code to an embedded situation with just a change in
> the connection string.
>
> Frans
>
> --
> ------------------------------------------------------------------------
> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------

Relevant Pages

  • Re: Embedded Interbase?
    ... If I didn't use a database for the app. ... BTW, with Firebird embedded, best part is this: you can change it in 2 ... Once you have everything running with the embedded server, ... just need to install the server (easy to download, ...
    (borland.public.delphi.non-technical)
  • Re: Embeddable databases
    ... Gerrit wrote: ... > It looks like when using the embedded Firebird engine, ... > access the database file at the time. ... I think a normal server database setup would be ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Embeddable databases
    ... Gerrit wrote: ... > JET is not an option, as it looks like it is being quietly ... > phased out without a replacement. ... Carlos' excellent .NET provider for Firebird, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: firebird embedded database
    ... >binding the lot to textfields and so on. ... I assume you are using the Firebird .NET provider 1.6 ... (1.5 doesn't work with the embedded server) ...
    (microsoft.public.dotnet.framework.adonet)