[Flask] FYI--put up a blog post on managing PostgreSQL Materialized Views with Flask-SQLAlchemy

[David Baumgold]

Jeff, this is really cool! Thank you for sharing! Any chance that this work can be merged back into SQLAlchemy, so that anyone using SQLAlchemy can benefit without having to write custom code?

David Baumgold


From: Jeff Widman <jeff at jeffwidman.com>
Reply: Jeff Widman <jeff at jeffwidman.com>
Date: January 8, 2016 at 12:46:11 AM
To: flask at python.org <flask at python.org>
Subject:  [Flask] FYI--put up a blog post on managing PostgreSQL Materialized Views with Flask-SQLAlchemy  

PostgreSQL materialized views have been extremely useful as a caching layer for some of my projects. They're fast, easy to setup, don't require extra infrastructure, and easy to refresh.

However, it took me forever to figure out how to manage the materialized views using Flask-SQLAlchemy, so I wrote it up in the hopes of saving others some time. 

If interested, you can see the code here:
https://github.com/jeffwidman/sqlalchemy-postgresql-materialized-views

And my blog post of explanatory notes here:
http://www.jeffwidman.com/blog/847/using-sqlalchemy-to-create-and-manage-postgresql-materialized-views/


--

Jeff Widman
jeffwidman.com | 740-WIDMAN-J (943-6265) 
<><
ᐧ
_______________________________________________  
Flask mailing list  
Flask at python.org  
https://mail.python.org/mailman/listinfo/flask  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/flask/attachments/20160108/6fbbbaad/attachment.html>