sqlalchemy core is a better option than going straight to the driver imo.
And you can call postgresql functions from the session, however if you are
using pyramid transaction and zope.sqlalchemy you will want to get in the
habit of marking the transactions as changes were made for the functions
tha
I second what Michael said. The sqlalchemy starter template is the right
way to go.
The major thing this template does, is provide you with the glue between a
SQLAlchemy "Session" and the pyramid request. See :
https://github.com/Pylons/pyramid-cookiecutter-starter/blob/latest/%7B%7Bcookiecu
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