Re: [pylons-discuss] Questions about DB engine setup

2019-04-27 Thread Mike Orr
On Sat, Apr 27, 2019 at 1:34 PM Michael Merickel wrote: > > The session and sessionmaker are only necessary if you want to hook into > pyramid_tm, because zope.sqlalchemy requires a session object and won't work > with a simple connection. That being said, I would want to such that >

Re: [pylons-discuss] Questions about DB engine setup

2019-04-27 Thread Michael Merickel
The session and sessionmaker are only necessary if you want to hook into pyramid_tm, because zope.sqlalchemy requires a session object and won't work with a simple connection. That being said, I would want to such that pyramid_tm handles the commits for you. That being said, you might abstract

[pylons-discuss] Questions about DB engine setup

2019-04-27 Thread Zsolt Ero
I'm trying to set up an API which would use SQLAlchemy Core (not ORM) + PostgreSQL. The server is a Google managed PostgreSQL instance, on external IP. I have a couple of questions. Since I needed to manually add SSL certificates as connect_args to create_engine + some additional arguments,