Re: embedded postgresql - Mailing list pgsql-general

From jini us
Subject Re: embedded postgresql
Date
Msg-id 20031115053600.15402.qmail@web86111.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: embedded postgresql  (Dustin Sallings <dustin@spy.net>)
List pgsql-general
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@spy.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

pgsql-general by date:

Previous
From: jini us
Date:
Subject: Re: embedded postgresql + C++ IDE
Next
From: Kris Jurka
Date:
Subject: Re: Storage consumption