Re: [sqlalchemy] design question for sqlite backed app

2018-05-18 Thread Jonathan Vanasco
On Friday, May 18, 2018 at 5:17:00 PM UTC-4, Mike Bayer wrote: > > > Well, SQLite locks the whole file during writes so that could be > problematic.if you have a write transaction open, it could cause > problems.I haven't stayed up to date on the latest SQLite changes, > current

Re: [sqlalchemy] design question for sqlite backed app

2018-05-18 Thread Mike Bayer
On Fri, May 18, 2018 at 1:47 PM, Jonathan Vanasco wrote: > We use a custom SqlAlchemy+Pyramid backed client for requesting and managing > LetsEncrypt SSL certificates. It centrally stores/manages the certificates, > which can then be deployed to various servers on a network,

[sqlalchemy] design question for sqlite backed app

2018-05-18 Thread Jonathan Vanasco
We use a custom SqlAlchemy+Pyramid backed client for requesting and managing LetsEncrypt SSL certificates. It centrally stores/manages the certificates, which can then be deployed to various servers on a network, with support built-in for PostgreSQL and SqlIte data storage. I'm working on