Embedded SQL thoughts

[Roger Oberholtzer]

On Mon, 2010-10-18 at 14:43 +0100, Federico Voges wrote:
> On 18/10/2010 13:18, 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.
> >
> >
> > TIA
> You might want to check SQLite (http://www.sqlite.org/). It's an 
> embedded SQL database with a lot of users. Android OS is one of it's 
> highest profile users and you can find more big names here 
> http://www.sqlite.org/famous.html.
> 
> I haven't use it personally, but I have a few dev friends that are quite 
> picky about the software they use and they seem to like it.

It was one we started looking at. The main thing that is lacking is
support for stored procedures. The database will be dealing with some
complicated data relationships, and we think stored procedures should
help keep the issues of dealing with this 'internal' to the database.

I am also not sure that SQLite allows concurrent access to a database.
We want to offer that to interested users who are willing to set up a
server and thus not use the embedded version. OTOH, users only needing
single application/system/user access to the data would have an easier
life with an embedded database,

Or so we are thinking at this stage of the game.


-- 
Roger Oberholtzer

OPQ Systems / Ramböll RST

Ramböll Sverige AB
Krukmakargatan 21
P.O. Box 17009
SE-104 62 Stockholm, Sweden

Office: Int +46 10-615 60 20
Mobile: Int +46 70-815 1696