Embedded SQL thoughts

[Bill Campbell]

On Mon, Oct 18, 2010, Roger Oberholtzer wrote:
>I am gearing up to make a spec for a database app. We have decided that
>the database will be accessed via SQL. For various reasons, we want to
>be able to run the database either as an embedded database (direct file
>access - no server), or via a server. This will depend on user
>requirements. The database must allow stored SQL procedures.
>
>We are looking at MySQL/MariaSQL. I am curious if anyone here has any
>opinions of using either of these to run an embedded database. I am sort
>of sure they support this ability. But has anyone here done that? I
>recall that there are a few database pros out these. I, on the other
>hand, am not such a creature. So experiences and suggestions are very
>welcome.

I'm very suspicious of anything related to Oracle (e.g. MySQL) given their
history with open source.  The most recent disappointment for me was their
changes in OpenSolaris.

We use postgresql for most things, but that's not an option for embedded
systems that can't depend on an external server.

Bill
-- 
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

When dealing with any spammer, one must always keep in mind that you
are dealing with someone who makes their living through forgery, fraud,
theft, subterfuge and obfuscation.  Stated simply, spammers lie.
     David Ritz <dritz at primenet.com>