Using FB in embedded mode? (Re: Embedded into EXE DB systems.)

> 2nd vote for firebird embedded. It works very well and is free.
>
> http://sourceforge.net/projects/firebird

Could you point me towards any more info on using Firebird embedded?

I am a FireBird newbie. I have downloaded and installed an FB 1.5.2 server,
and used it happily with IBExpert as the Enterprise Manager. I'm aware of
tools such as FIBPlus, IBObjects,etc and the Database Workbench.

So, so far all seems great for FB in C/S mode.

What I'm not clear about is how the FB embedded works, or how well it works.
I gather from this ng that there are some units floating around that make it
relatively easy to embed FB by linking the relevant units, but at this stage
it sounds more complex than in NexusDB where you just drop the appropriate
components on the form/datamodule.

Could someone give me a rundown on what's involved using FB embedded, let me
know how it works, what the pros and cons are, what the 'gotchas' to look
out for are, etc, or point me towards any web resources that might be handy.

My initial feeling was that FB (along with NexusDB, MS SQL Server, etc)
seems to be a good choice good for C/S apps but NexusDB seems to be better
architected for embedded apps. But, I need to reserve my judgement till I
actually develop an embedded app (or test app) with FB so I can make an
informed decision.

Basically, I am happy using NexusDB embedded, but would have a preference
for an embedded db server that used a single file for all tables rather than
a file per table. Hence further investigation . . .

Any pointers appreciated.

> > If you mean an embeded Database, Firebird is free:
> > http://firebird.sourceforge.net/
> >
> > But, as far as I know, embeded version is limited to 1 connection.
> > Maybe I'm wrong about that, though.

Why would it need more than 1, if it's embedded? For different threads?

Lauchlan M


.

Relevant Pages

  • Re: Using FB in embedded mode? (Re: Embedded into EXE DB systems.)
    ... > I gather from this ng that there are some units floating around that make ... > it sounds more complex than in NexusDB where you just drop the appropriate ... > My initial feeling was that FB (along with NexusDB, MS SQL Server, etc) ... > architected for embedded apps. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Using FB in embedded mode? (Re: Embedded into EXE DB systems.)
    ... >server, and used it happily with IBExpert as the Enterprise Manager. ... >My initial feeling was that FB (along with NexusDB, MS SQL Server, etc) ... >better architected for embedded apps. ... UIB (fastest IB/FB connection components on Earth. ...
    (borland.public.delphi.thirdpartytools.general)
  • ANN: NexusDB AWE Server Trial now available
    ... NexusDB Server AWE edition brings you the possibilities of 64-bit ... The NexusDB AWE edition is a normal win-32 executable that runs on any ... AWE edition on a 16 gigabytes RAM, 8 core server, and dedicate 12 ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Looking for database that is easy to install
    ... NexusDB will fit your needs here. ... Copy the server exe file onto the designated file server. ... > the single file database and only having to ensure ADO is installed on the ... > acting as a server or their own client machine and have it install the ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ANN: RTC SDK 1.9g > New Message-based Third-party transports
    ... with a ready-to-use set of plugging which allow tunneling of all RTC ... communication through NexusDB components. ... I have done some performance tests with client and server components in one ... Performance gains when using NexusDB transports enormous and I'm starting to ...
    (borland.public.delphi.thirdpartytools.general)