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.