Thread: embedded postgres

embedded postgres

From
"Rick Gigger"
Date:
Is there an embedded version of postgres that I could compile into a desktop
app?  I would just use embedded mysql but I don't want to GPL my code or pay
them for a licence, plus all of the code was already built for postgres
server.


Re: embedded postgres

From
Bruno Wolff III
Date:
On Thu, Jan 23, 2003 at 01:57:39 -0700,
  Rick Gigger <rick@alpinenetworking.com> wrote:
> Is there an embedded version of postgres that I could compile into a desktop
> app?  I would just use embedded mysql but I don't want to GPL my code or pay
> them for a licence, plus all of the code was already built for postgres
> server.

You might want to look into this issue more carefully. If your application just
uses a gpl program you don't have to gpl your application since it is a separate
application. If you were actually making changes to the database AND
distributing it then the changes would need to be gpl'd. Even then there
might be a loophole for an embedded modified database server since you
wouldn't necessarily be seen as distributing the binaries if the customers
didn't have access to them.

Re: embedded postgres

From
"scott.marlowe"
Date:
On Thu, 23 Jan 2003, Rick Gigger wrote:

> Is there an embedded version of postgres that I could compile into a desktop
> app?  I would just use embedded mysql but I don't want to GPL my code or pay
> them for a licence, plus all of the code was already built for postgres
> server.

Have you looked at small databases that were designed for this sort of
thing from the ground up?

I'd look at hsql http://sourceforge.net/projects/hsqldb/ for a choice.
At 100k, it's a pretty small database engine that seems to get a lot of
activity.  I'm betting it's not built for 100 users all thrashing it at
once, but for imbedded apps, it's hard to say no to a 100k database
engine.  And, it's got all the BSD goodness you're used to with
Postgresql.

There are a couple other small databases like this floating around out
there as well.


Re: embedded postgres

From
"Rick Gigger"
Date:
Great!  Thats exactly what I want.  Now if it's got a SQL engine that won't
require me to alter any of my code...

Thanks!


> On Thu, 23 Jan 2003, Rick Gigger wrote:
>
> > Is there an embedded version of postgres that I could compile into a
desktop
> > app?  I would just use embedded mysql but I don't want to GPL my code or
pay
> > them for a licence, plus all of the code was already built for postgres
> > server.
>
> Have you looked at small databases that were designed for this sort of
> thing from the ground up?
>
> I'd look at hsql http://sourceforge.net/projects/hsqldb/ for a choice.
> At 100k, it's a pretty small database engine that seems to get a lot of
> activity.  I'm betting it's not built for 100 users all thrashing it at
> once, but for imbedded apps, it's hard to say no to a 100k database
> engine.  And, it's got all the BSD goodness you're used to with
> Postgresql.
>
> There are a couple other small databases like this floating around out
> there as well.
>
>


Re: embedded postgres

From
Medi Montaseri
Date:
What do you mean by embedded ?
Do you have a persistent storage ? Flash or disk ? That would be
something you'll
need regardless. If you have a Flash secondary storage, then the writes
will shorten
the life of your flash. Otherwise, PG has a very smal foot print and can
be used in
most "embedded" environment based on what is embedded today...

Your questions are really
- do you have persistent storage
- do you have sufficient ram (PG not requiring as much as Oracle)
- There is also the issue of DB Maintenance (vacuumming) that PG still
requires it
  I think in 7.4 the plan is to make that automatic....

Bruno Wolff III wrote:

>On Thu, Jan 23, 2003 at 01:57:39 -0700,
>  Rick Gigger <rick@alpinenetworking.com> wrote:
>
>
>>Is there an embedded version of postgres that I could compile into a desktop
>>app?  I would just use embedded mysql but I don't want to GPL my code or pay
>>them for a licence, plus all of the code was already built for postgres
>>server.
>>
>>
>
>You might want to look into this issue more carefully. If your application just
>uses a gpl program you don't have to gpl your application since it is a separate
>application. If you were actually making changes to the database AND
>distributing it then the changes would need to be gpl'd. Even then there
>might be a loophole for an embedded modified database server since you
>wouldn't necessarily be seen as distributing the binaries if the customers
>didn't have access to them.
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>




Re: embedded postgres

From
"Rick Gigger"
Date:
It turns out that SQLite is exactly what I need.

Thanks!

Rick

----- Original Message -----
From: "Bruno Wolff III" <bruno@wolff.to>
To: "Rick Gigger" <rick@alpinenetworking.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, January 23, 2003 7:15 AM
Subject: Re: [GENERAL] embedded postgres


> On Thu, Jan 23, 2003 at 01:57:39 -0700,
>   Rick Gigger <rick@alpinenetworking.com> wrote:
> > Is there an embedded version of postgres that I could compile into a
desktop
> > app?  I would just use embedded mysql but I don't want to GPL my code or
pay
> > them for a licence, plus all of the code was already built for postgres
> > server.
>
> You might want to look into this issue more carefully. If your application
just
> uses a gpl program you don't have to gpl your application since it is a
separate
> application. If you were actually making changes to the database AND
> distributing it then the changes would need to be gpl'd. Even then there
> might be a loophole for an embedded modified database server since you
> wouldn't necessarily be seen as distributing the binaries if the customers
> didn't have access to them.
>