FB embedded cons vs pros

[Hugo Larson]

Hello,

What are the cons and pros of running FB in embedded mode on a server where all connections are localhost?

Are there limitations? I read that embedded mode can handle multiple connections.

Thanks,
Hugo

[Steve Naidamast]

I don't know why you would want to run a Firebird Server in "embedded" mode.  This mode is used for databases local to an application that can also be distributed with it.

Steve Naidamast

Sr. Software Engineer

[Mark Rotteveel]

Firebird Embedded cannot accept remote connections, it can only accept
in-process connections (that is, only within the application). Within an
application you can create multiple connections to the database. If you
want multiple applications to connect to the same database, you need to
ensure that the server mode is configured appropriately
(ThreadedShared), and that all applications have access to the shared
lock directory and its files.

The following is my opinion, and might miss some things

Cons of embedded:
* No user authentication
* Filesystem level access to the database is required for the database
* (possibly) higher chance of corruption, if applications are
killed/terminated incorrectly
* Harder/impossible to use additional tools on the database if
server-mode is configured wrong (this applies both to the app config, as
the tool config), or if tools expect to use a TCP/IP connection

Pros of embedded:
* No server running
* No user authentication (yes, I'm listing it as both a con and a pro)
* Slightly faster than TCP/IP over localhost

Mark
--
Mark Rotteveel

[Dimitry Sibiryakov]

Mark Rotteveel wrote 30.10.2022 9:36:
> Cons of embedded:
> * No user authentication
> * Filesystem level access to the database is required for the database
> * (possibly) higher chance of corruption, if applications are killed/terminated
> incorrectly
> * Harder/impossible to use additional tools on the database if server-mode is
> configured wrong (this applies both to the app config, as the tool config), or
> if tools expect to use a TCP/IP connection

* Slighty slower that TCP/IP over localhost (yes, particularly fetch because
of no server buffering)

> Pros of embedded:
> * No server running
> * No user authentication (yes, I'm listing it as both a con and a pro)
> * Slightly faster than TCP/IP over localhost

--
WBR, SD.

[Hugo Larson]

Thanks Mark.

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3a278cfd-bfaf-a051-3f7d-b24fa5f49f08%40lawinegevaar.nl.