craig

"SQL Alchemy does have native support for hStore and connection pooling, but still doesn't support the broad array of datatypes and functionality thats within Postgres." - craig

"Original author here - specific to Postgres there's some things you can do to query across databases which are reasonable on performance. db_link is an extension that will query across Postgres databases and do push-down of conditions so queries are optimized. I hope to cover more of these details around reporting and how to determine what to shard in a future post." - craig

"We've been pretty excited about this release to come for some time at Heroku as its loaded with great features. In addition to the JSON datatype here's a bit of a longer list of features that are pretty noteworthy in the release: - Allow libpq connection strings to have the format of a URI - Add a JSON data type - Allow the planner to generate custom plans for specific parameter values even when using prepared statements - Add the SP-GiST (Space-Partitioned GiST) index access method - Add support for range data types - Cancel queries if clients get disconnected - Add CONCURRENTLY option to DROP INDEX - Add a tcn (triggered change notification) module to generate NOTIFY events on table changes - Allow pg_stat_statements to aggregate similar queries via SQL - text normalization. Users with applications that use non-parameterized SQL will now be able to monitor query performance without detailed log analysis." - craig

"Here's a bit of a shameless self plug for my own blog post, but I've covered a lot of the advantages of Postgres. Its not necessarily a why postgres versus mysql or other db, as some databases do have some of these features but none that I know of have all of them (craigkerstiens.com/2012/05/07/why-postgres-part-2/). In general postgres over mysql: Postgres has near instant column addition Concurrent index creation Better query planner Extensions Foreign Data Wrappers" - craig

"For a good description of how heroku technically works check out this post - http://www.quora.com/Scalabi... Its slightly older, but still largely accurate" - craig

"Completely fair point, when you work with it long enough you come to expect those things. There's still many databases out there that don't even off the above." - craig

"submitted by reddit to blog." - craig

"http://freezing-warrior-5489.herokuapp.com/" - craig

"We do fully support Django, we simply highlighted Flask as the simplest example to get an application running. You can see a full guide to getting started with Django at: http://devcenter.heroku.com/article..." - craig

"Hey, also would be happy to help out for free. Send me a DM and we can connect. I'm rather proficient in all areas and in particular have really deep knowledge on Postgres so can go as light or as deep as you want to go there." - craig

"My biggest qualm with all of these is the slight extra steps to deploy. While they are significantly easier than rolling your own, the common custom ini's do lack the ease of only git push with a requirements.txt file." - craig