Re: [sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-12-14 Thread Jeff Widman
> > > the descriptions on that page for several other methods say 'see > > execute_at() for more information' so it doesn't exactly "feel" > deprecated. > > I see it just at DDLElement.execute() where that doc should be updated. > Where else? > I think here as well?

Re: [sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-12-14 Thread Mike Bayer
On 12/14/2015 05:33 PM, Jeff Widman wrote: > > the descriptions on that page for several other methods say 'see > > execute_at() for more information' so it doesn't exactly "feel" > deprecated. > > I see it just at DDLElement.execute() where that doc should be updated. > Where

Re: [sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-11-16 Thread Mike Bayer
On 11/16/2015 02:23 AM, Jeff Widman wrote: > Thanks Mike. That helped tremendously. > > A couple of followup questions: > (questions based on this code extending the view recipe: > https://gist.github.com/jeffwidman/1656498de21dc0afcdab) > > 1) In the recipe for creating views, I see: > >

Re: [sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-11-15 Thread Jeff Widman
Thanks Mike. That helped tremendously. A couple of followup questions: (questions based on this code extending the view recipe: https://gist.github.com/jeffwidman/1656498de21dc0afcdab) 1) In the recipe for creating views, I see: CreateView(name, selectable).execute_at('after-create', metadata)

Re: [sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-11-09 Thread Mike Bayer
On 11/09/2015 03:52 PM, Jeff Widman wrote: > A couple of quick questions about Postgres Materialized Views--searched, > but found very little: > > I've got a few values that are fairly expensive to calculate, so I'd > like to pre-calculate the results. It's fine if the the data is stale > for a

[sqlalchemy] How do a I create Postgres Materialized View using SQLAlchemy?

2015-11-09 Thread Jeff Widman
A couple of quick questions about Postgres Materialized Views--searched, but found very little: I've got a few values that are fairly expensive to calculate, so I'd like to pre-calculate the results. It's fine if the the data is stale for a few hours, so I'd like to use Postgres Materialized