Re: embedded postgres

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.