Re: [sqlalchemy] Best way to implement PostgreSQL materialized views?

2020-04-29 Thread Jonathan Vanasco
There also exists a 3rd party library that has been somewhat maintained: https://github.com/jklukas/sqlalchemy-views IIRC, it is largely based on the Wiki recipe that Mike linked to. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post

Re: [sqlalchemy] Best way to implement PostgreSQL materialized views?

2020-04-29 Thread Ethan Ralph
Replies inline. On Wednesday, April 29, 2020 at 1:55:49 PM UTC, Mike Bayer wrote: > > Addition of views to SQLAlchemy is an extremely long term issue that has > never been done, largely because we have a recipe that works well enough > for most cases, which you have probably seen, at >

Re: [sqlalchemy] Best way to implement PostgreSQL materialized views?

2020-04-29 Thread Mike Bayer
Addition of views to SQLAlchemy is an extremely long term issue that has never been done, largely because we have a recipe that works well enough for most cases, which you have probably seen, at https://github.com/sqlalchemy/sqlalchemy/wiki/Views. The issue itself is