Thread: Postgres as embedded db for GUI

Postgres as embedded db for GUI

From
David Pratt
Date:
Hi.  Where would I locate information on setting up postgres as a stand
alone db for a gui application.  I am writing this in python and have
been using sqlite but would like to try my app with postgres backend.
Links to any specific open source example would be helpful. The only
user would be the application as opposed to using postgres as server
for multiple client applications.

Many thanks
David

Re: Postgres as embedded db for GUI

From
Jaime Casanova
Date:
On 11/24/05, David Pratt <fairwinds@eastlink.ca> wrote:
> Hi.  Where would I locate information on setting up postgres as a stand
> alone db for a gui application.  I am writing this in python and have
> been using sqlite but would like to try my app with postgres backend.
> Links to any specific open source example would be helpful. The only
> user would be the application as opposed to using postgres as server
> for multiple client applications.
>
> Many thanks
> David
>


google for psycopg2

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

Re: Postgres as embedded db for GUI

From
David Pratt
Date:
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).

I am not sure of whether postgres can be set up this way which is the
reason for the question.  I have only ever installed it on FreeBSD and
MacOSX in the normal way and then compiling the db adapter to work with
it.

Regards,
David

On Thursday, November 24, 2005, at 12:06 PM, Jaime Casanova wrote:

> On 11/24/05, David Pratt <fairwinds@eastlink.ca> wrote:
>> Hi.  Where would I locate information on setting up postgres as a
>> stand
>> alone db for a gui application.  I am writing this in python and have
>> been using sqlite but would like to try my app with postgres backend.
>> Links to any specific open source example would be helpful. The only
>> user would be the application as opposed to using postgres as server
>> for multiple client applications.
>>
>> Many thanks
>> David
>>
>
>
> google for psycopg2
>
> --
> Atentamente,
> Jaime Casanova
> (DBA: DataBase Aniquilator ;)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly
>

Re: Postgres as embedded db for GUI

From
Peter Eisentraut
Date:
David Pratt wrote:
> Hi.  Where would I locate information on setting up postgres as a
> stand alone db for a gui application.

This is not possible.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Postgres as embedded db for GUI

From
Keary Suska
Date:
on 11/24/05 9:55 AM, fairwinds@eastlink.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"