realbasic-nug
[Top] [All Lists]

Re: Database query

To: "REALbasic NUG" <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Database query
From: "Adam Shirey" <adam dot shirey at gmail dot com>
Date: Fri, 7 Sep 2007 16:38:51 -0500
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <46E1C1CD dot 4010307 at chrononomicon dot com>
IANAL, but...

I would say what makes a database "multi-user" is not how many people
use it or whether it allows remote connections, but rather whether the
db engine authenticates the user. Do you need a username/password to
get into the database? That may sound more like a security issue than
a licensing one, but I can't imagine any serious database engines out
there that purport to be multi-user while at the same time not having
that sort of user authentication. MySQL, PostgreSQL, Oracle, and so
on, all require you authenticate with the server based (at least in
part) on your username.

Also, I would guess a "multi-user" database is aware of the
possibility -- and, in most cases, probability -- that querying can be
done from one or more places simultaneously (eg, User A is SELECTing
>from a table while User B is INSERTing into the table). I don't know
how SQLite would handle such a scenario, but I know MySQL will handle
such access gracefully.

The NUG has developers more intimate with such details, but I would
guess these are at least good starting points for determining whether
a DB constitutes single- or multi-user.


-Adam
dingostick.com

On 9/7/07, Bart Silverstrim <bsilver at chrononomicon dot com> wrote:
> Silly question...(do I ask any other? :-)
>
> What exactly makes a database "multiuser", according to the license?
>
> RB Standard has a single-user license.
>
> If you make an application that lets two or three people use a client
> program that connects over a socket to a server application, like an RB
> web server made by the standard version and stores wiki-like entries in
> the database...is it single user because it's only one database being
> used by one application, the server?  Or is it multiuser because
> multiple people are using (non-database equipped) clients to communicate
> with the server application that does use the database?
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>