Re: free embedded databases?

Tom wrote:
Not so. DBISAM, among others, can handle multiuser in embedded or C/S
mode
with the same identical code.
Firebird can as well.
Unfortunately, FB cannot. At least, not with embedded. Embedded FB only
allows one user connected, although that user can have multiple connections
so you could build a server application which uses it for multiple users.

That's funny, I do it. I do not RECOMPILE my Delphi app at all. I store my connection string in an INI file and simply drop the appropriate DLLs in place depending on the situation (embed or C/S).

And say four users can connect to the same database files without any
server? Most small SQL databases can be embedded in an EXE but usually
the on disk format only allows one server at a time access. That
means multiple users can't access the same database using the
engines embedded in each EXE. There are some that have an on disk
format that can be accessed by more than one engine. Two examples
would be Access and DBISAM.

I use embedded here to mean more the SQL database engine is
run directly in/by the EXE in question as opposed to using a
C/S style link to a database engine.

Myself I find it's better to bite the bullet and use a dedicated
server for anything over a single user. Allows a choice between
a lot more database engines.

Brian
.

Relevant Pages

  • Re: Async and single threading sockets in SBCL
    ... I'm a lisp newbie writing a server in SBCL and I would prefer to ... > I should probably also point out that connections to the server are ... with multiple threads unless you have multiple CPUs and you know what ... So my second requirement was ``Use a single thread because I ...
    (comp.lang.lisp)
  • Re: Async and single threading sockets in SBCL
    ... > with multiple threads unless you have multiple CPUs and you know what ... > I've written single-threaded servers that support multiple connections ... I wanted to implement such a server that was free ... in particular it conses 3 new lists of that size. ...
    (comp.lang.lisp)
  • Re: How To Force Load Balancing For Incoming Traffic to One Server Through 5500 / 6500 Switches?
    ... > "load balancing" is a term that is usually applied only in the situation ... > where there are multiple servers (including multiple connections to ... > the same server). ... they actually measure throughput and make decisions about which connections ...
    (comp.dcom.sys.cisco)
  • Re: Now, another question about Xnews
    ... you're allowed several connections simultaneously to ... > your server, and each connection has a speed-cap individually, ... > newsrc)and download parts of a post in one, ... instead of opening multiple aliases (or whatever ...
    (news.software.readers)
  • Re: Multiple User Access through ADO?
    ... SqlCE is can handle connections from multiple applications and threads on the same machine. ... It can also be used with IIS for multiple web requests for data, but this is still on the same machine. ... >>> I have a SQLCE database on a terminal server. ...
    (microsoft.public.sqlserver.ce)