[sqlalchemy] FYI: Put up a blog post on how to manage PostgreSQL Materialized Views using SQLAlchemy

2016-01-07 Thread Jeff Widman
thanks to Mike Bayer for his help. Cheers, Jeff -- *Jeff Widman* jeffwidman.com <http://www.jeffwidman.com/> | 740-WIDMAN-J (943-6265) <>< ᐧ -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group

Re: [sqlalchemy] using savepoint transactions in unittests for a webapp which uses a scoped session?

2015-12-20 Thread Jeff Widman
You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@g

Re: [sqlalchemy] adjacency list to nested dictionary

2015-12-16 Thread Jeff Widman
Can this dictionary be built non-recursively? I am not sure how to > manually do this otherwise. > > Thanks in advance! > > Greg-- > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this g

Re: [sqlalchemy] adjacency list to nested dictionary

2015-12-16 Thread Jeff Widman
> > Greg-- > > On Wednesday, December 16, 2015 at 5:42:01 PM UTC-6, Jeff Widman wrote: >> >> What database are you using? >> >> Are you trying to solve data insert or retrieval? >> >> Do you want to do your traversal in your app or use SQLAlchemy to &g

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] Determination of string lengths

2015-12-05 Thread Jeff Widman
lalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- *Jeff Widman* jeffwidman.com <http://www.jeffwidman.com/> | 740-WIDMAN-J (943-6265) <>< -- You received this me

Re: [sqlalchemy] Splitting a table ?

2015-12-02 Thread Jeff Widman
ving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > --

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

2015-11-15 Thread Jeff Widman
tion of creating the view? More than happy to submit a PR helping tidy up the docs on this, just not sure what I should be saying. Cheers, Jeff On Mon, Nov 9, 2015 at 1:58 PM, Mike Bayer <mike...@zzzcomputing.com> wrote: > > > On 11/09/2015 03:52 PM, Jeff Widman wrote: > &

[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