[mod_python] having modpython make a data base connection

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


More information about the Mod_python mailing list