Re: Which is the best single-user DB ?

From: Andrea Raimondi (rainaple_at_tin.it)
Date: 10/26/04


Date: Tue, 26 Oct 2004 17:19:32 +0200

N.D. van Bochove wrote:

> Well, others will disagree, I suppose, but I'm a great fan of Firebird.
> Firebird is an open source fork of IB 6. Firebird has an embedded
> version, and with that you get a single user database, without
> installing servers or other stuff. The only thing you need is a DLL in
> the same directory as your application. If (in the future) you want to
> switch to a full featured server, you just replace this DLL with the
> normal Firebird client, and a server somewhere in the network (could be
> your local machine, though).

Please *do* be aware of a little thing: Firebird Embedded won't
allow you to have more than ONE instance of an application using one
database file. Thus, if for whatever reason you need to run multiple
instances on the same computer pointing to the same database, you
ought to go with the full fledged server.

Apart from that, I fully second this choice.

> Regards, Diederik

Best Regards,

Andrew

--
Online thoughts blog
http://araimondi.blogspot.com


Relevant Pages

  • 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)
  • [opensuse] stunnel certificates
    ... I want to secure access to a databese server (Firebird). ... I want to do this with stunnel. ... #sign server certificate ...
    (SuSE)
  • Re: ANN: NexusDB v2 Client/Server database - DCU ONLY version 50% introductory offer
    ... You can use their server, or its really easy to do your own. ... The server can also be inside your app (like the Firebird embedded version but without a dll). ... but I gather its easier and more powerful in Nexus. ... Generally a bit better 3rd party support. ...
    (borland.public.delphi.thirdpartytools.general)
  • 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: 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)