Re: Postgres as embedded db for GUI

on 11/24/05 9:55 AM, fairwinds(at)eastlink(dot)ca purportedly said:

> Hi Jaime. I currently work with psycopg with web apps. My question is
> more a matter of whether postgres can be installed in a way that keeps
> it contained to the program files for the app (as opposed to the
> regular type of install where postgres becomes available as a server
> available anywhere on the operating system. I don't want the
> installation used for tables other than app tables (or available to
> anything other than the app).

Although the short answer is that Postgres is not designed to be embedded,
you can emulate this condition with a custom install that does not include
the client apps and keeping all authentication private to the app
(especially keeping app authentication separate from db authentication). The
the only issue you have to watch out for is multiple installations, which
can be avoided by using a specific IP address (or domain socket if Win
supports them).

So essentially, you're keeping people out simply because they can't
authenticate, which, by and large, is the only way that most, if not all,
"embeddable" systems keep foreign apps out.

Best,

Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"