Here’s part one of the series of using Postgres as a document store. In short, it works, but could use a bit of usability tuning. Fortunately much of this is coming but it’s still quite workable today - take a look at how.
Bruce Momjian teaches the popular course Comprehensive PostgreSQL Administration again in September, covering foundational and advanced topics needed for success. Join Bruce and learn from his tips in this live on-line session. 20% off promo code COMB-WEB-01.
Should a SQL injection vulnerability occur in your application it could be a huge disaster, here’s a newer approach for helping prevent such by analyzing every query and alerting on unknown queries against your system.
PgBouncer is still the best solution for connection pooling with Postgres in your application. With the newest release from just a few weeks ago there’s a number of improvements that make it even more usable.