Re: embedded postgresql

I have come to the conclusion that for my purpose
I would be better off using sqlite from www.sqlite.org
or firebird from www.phoenix.com.

Although mysql provides client APIs & server APIs
and is stable.
But there seems to be doubt whether mysql is actually
free if I wish to use it as an embedded database.

It has been suggested that I would have to pay
$10,000 one off licence fee if I include mysql in my
app.
Another person suggested that mysql is free to include
in my app, so I am simply not sure over the licence
costs of mysql.

--- Dustin Sallings <dustin(at)spy(dot)net> wrote: >
> On Nov 14, 2003, at 14:13, jini us wrote:
>
> > I would class your solution as a work around
> > rather than a "natural solution".
>
> It really seemed like the obvious way to do it (I'm
> sure I'm not the
> only person who thought of that, but didn't post
> it).
>
> > Anyway I am using MS windows and to implement
> > postgres as embedded, using your approach, would
> > probably become complicated.
> > .It would probably introduce unwanted bugs in my
> > software.
>
> I believe it would be you introducing those bugs if
> you do not
> initialize the DB correctly, regardless of the
> mechanism.
>
> Now, how many bugs do you think it would create in
> postgres if the
> entire interface model were changed from
> postmaster/postgres processes
> to having multiple threads in a single application
> trying to issue
> queries in the in-process DB. What happens to the
> DB when your app
> segfaults? Are there any signal handlers postgres
> uses that you would
> want to use in your app? Do you really need to
> redesign the way
> postgres works just because you don't want to manage
> the resource as a
> process rather than a different type of API?
>
> --
> Dustin Sallings
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match

________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk