Firebird is a nice, small, ACID compliant database that embeds well.
firebird.sourceforge.net
Rick
pgsql-general-owner@xxxxxxxxxxxxxx wrote on 10/03/2005 12:12:44 AM:
> Samik Raychaudhuri <samik@xxxxxxxxxxxxx> writes:
> > ... What I wanted is a no-trace (or minimal trace), no-admin required
> > kind of installation (I won't be able to create a non-admin user in the
> > comp), which, when I am done, I can just delete the installation
> > directory and will be clear.
>
> Postgres isn't really designed to be the sort of "embedded" database
> that you seem to be after. You should look at other alternatives.
> (Berkeley DB is one possibility that's written by friends of ours ;-))
>
> In particular, you'll get zero sympathy here for any request to let the
> database run as an admin-level user. The IPC communication structure we
> use does not allow restricting requests to just one program, and hence
> ignoring security issues is simply not a sane thing to do.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
