Re: Embedded Database

On Mon, 2004-08-09 at 01:30, Richard Connamacher wrote:
> Does anybody know if it can be used as an embedded database engine within an application,
> so the application doesn't have to connect to an external server? (I have looked at SQLite, and
> I'd rather use PostgreSQL for my app, footprint be damned.)
>

There are no embedded database libraries for PostgreSQL data. Even a
well-designed embedded database library can leave your data corrupted
due to an applicaiton bug (because an embedded DB runs in the same
address space as the application, so it has no way to protect itself
from application bugs). Dangers like this, in addition to the
fundamental design differences, mean that one probably won't be
developed any time soon.

> And, does anybody know if it's possible for PostgreSQL to run a database entirely in RAM
> without saving the file out to disk?
>

Linux has the "tmpfs" filesystem. Just put all the DB files in a tmpfs
mount.

Hope this helps,
    Jeff Davis