Postgres as embedded db for GUI
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
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 ;)
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:
Show quoted text
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
Davidgoogle 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
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/
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"