|
Greg Fawcett
greg at vig.co.nz
Tue Jun 12 22:33:24 EDT 2007
Hi David - For Postgresql, you have a choice between pygresql (seems to be the defacto standard) and psycopg (also has a strong following). I tested both and decided to go with psycopg, because it seemed faster and more complete at the time. I recommend getting it as source rather than relying on your distribution's package manager, because there is a lot of improvement happening. This goes for mod-python too - the latest stable release is far easier to work with. If your system is three-tier (database on a separate machine) you might want to look at pgpool, a very well regarded pooling daemon. Cheers! Greg. On 13/06/07, David Bear <David.Bear at asu.edu> wrote: > > I don't want to start a flame ware here, but I'm starting to develop > and application that will connect to a postgresql server. > > I realize there are probably a dozen things I should know about > modpython before I begin. > > I will be use the standard python handler. I won't be using publisher > or psp (at least I think). > > I am afraid of issues like having modpython make a db connection > object that is not shared properly --. The more terrifying question is > what should be be asking. > > I wonder if someone has develop a top ten rules of thumb when using > modpython with sql data base connections? > > > -- > David Bear > phone: 602-496-0424 > fax: 602-496-0955 > College of Public Programs/ASU > University Center Rm 622 > 411 N Central > Phoenix, AZ 85007-0685 > "Beware the IP portfolio, everyone will be suspect of trespassing" > _______________________________________________ > Mod_python mailing list > Mod_python at modpython.org > http://mailman.modpython.org/mailman/listinfo/mod_python > -- Phone: +64 3 409 8165 Mobile: +64 21 333 291 Fax: +64 3 974 6810 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20070613/46e5db42/attachment-0001.html
|