Hi, I use Postgres and Pyramid without ORM. It's quite straight forward and I don't see any reason against this approach. 'Connection Pooling' might be a problem because Postgres is quite slow when it comes to setting up new connections. If necessary you could handle it outside of Pyramid/Python by using pgBouncer.
You might need to have a look at the event system, especially NewRequest/NewResponse: https://docs.pylonsproject.org/projects/pyramid/en/latest/api/events.html Arndt. > > I would like to use psycopg2, I am reading this now : > > > https://docs.pylonsproject.org/projects/pyramid-cookbook/en/latest/database/index.html > > > > but I would like to see if anyone can share his experience / or point any > pitfalls. > > what part of pyramid API should I look more into. > > that would help me understand pyramid and postgresql more. > > >>> -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/pylons-discuss/35285c99-37a7-4062-8d72-033a168c03d5n%40googlegroups.com > <https://groups.google.com/d/msgid/pylons-discuss/35285c99-37a7-4062-8d72-033a168c03d5n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > Arndt Droullier Nive GmbH -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAJYR-0NsaYOPnpdEGE%3DqCg87QrWJaA_iBAPCm%2BUt_YSh8r3C_A%40mail.gmail.com.
