Thread: 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: > 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 >
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"