Thread: embedded postgres
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.
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.
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.
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. > >
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) > >
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. >