The embedded version will act just like a full-blown server as far as your app is concerned. Just
make sure that your app is always programmed as if it were intended to be used in a multi-user
environment, and then deploying the single-user version will simply be a special case where it
seems like only one app is "connected to the server". Make sure you take all the precautions
normally expected: pessimistic locking if needed, watch for concurrency "errors" that might occur
if other users were on the system, etc.

One difference: username/password validation. Since the embedded server doesn't use the security
database, it's going to believe you about usernames. As I recall, you still have to set up the
username you want to use, and permissions, but the password isn't checked ... That might affect
you, might not. (Helen should know more about that stuff.)

Happy coding!

-Philip

---------- Original Message -----------
From: "edward_van_h2002" <edward_van_h2002@...>
To: firebird-support@yahoogroups.com
Sent: Tue, 24 Feb 2004 09:09:04 -0000
Subject: [firebird-support] Embedded version and concurrency?

> Hi,
>
> Before I dive into how to deploy and use the embedded version of FB
> final from VB with direct calls to the DLL... could a kind soul tell
> me whether it provides some support for concurrency, or if it's like
> SQLite, ie. it's really meant for stand-alone apps, and relies on the
> OS to manage concurrent accesses?
>
> Most of our customers use our apps in stand-alone mode, but at some
> bigger sites, more than one host needs to read/write data. So, since
> FB 1.5 final just came out, I figured I should check out its embedded
> version before hacking around SQLite.
>
> Thank you
> Fred.
>
>
> Yahoo! Groups Links
>
>
>

------- End of Original Message -------