Re: Embeddable databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frans Bouma [C# MVP] (perseus.usenetNOSPAM_at_xs4all.nl)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 22:30:20 +0100

Gerrit wrote:
> 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).

        that's not the purpose of an embedded db I think: the db in an embedded
app is there to support the app, which is ran by the user. If you have
multi-user requirements, I think a normal server database setup would be
more appropriate...

                FB

>
> 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#)
>> ------------------------------------------------------------------------
>
> 

-- 
------------------------------------------------------------------------
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: PostgreSQL and Firebird comparison via digg
    ... Fire 10 large SELECTS in a 24x7 application server and you can see why ... Since when has firebird supported parallel query execution? ... Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & ...
    (borland.public.delphi.non-technical)
  • Re: PostgreSQL and Firebird comparison via digg
    ... "The truth of the matter is, InterBase does not come with a very rich ... around using Firebird as a embedded database, ... One misbehaving thread can bring the whole server crashing down, ... the need for a guardian service on Interbase and Firebird. ...
    (borland.public.delphi.non-technical)
  • Re: Delphi/C++Builder new thing in database area
    ... the database to that server instance, or create the database and all the ... The closest thing you can come to Firebird documentation is the Interbase ... then it's not so: Firebird server supports ...
    (borland.public.delphi.non-technical)
  • Re: Which is the best single-user DB ?
    ... > Firebird is an open source fork of IB 6. ... > version, and with that you get a single user database, without ... > switch to a full featured server, you just replace this DLL with the ... and a server somewhere in the network (could be ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Time to migrate from Access DB to???? ---- Need recommendations
    ... Firebird is the conitinuance of the source from the once greatest ... spinoff is Firebird wich is actually, really a great datbase if costs oare ... However as i said before my main database is SQL 2005, ... i would say go for SQL 2005 as it is in my opinion the dream of every VS.net ...
    (microsoft.public.dotnet.languages.vb)