Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 120 — August 26, 2015
Designing a PostgreSQL Document API
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.
Rob Conery
Generating MoM, YoY and CMGR from SQL
Window functions are extremely powerful and you can do many things with them. One very common capability is computing month over month growth without having to break out a scripting language or Excel.
YunoJuno Tech Team
Spotify PostgreSQL Metrics: Tool That Extracts and Provides Metrics On Your Database
A CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster.
Spotify   #tools 
Learn Postgres Admin from Community Leader Bruce Momjian
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.
EnterpriseDB    #sponsored 
pgfutter: Import CSV and JSON Into PostgreSQL The Easy Way
Here’s an incredibly handy tool for importing CSV and JSON data directly into PostgreSQL.
Lukas Martinelli   #code 
sql_firewall: SQL Firewall Extension for PostgreSQL
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.
Uptime Technologies   #code 
Row Level Security in PostgreSQL 9.5
Row Level Security (RLS) allows the contents of a table to be filtered before being returned to the user.
James Keener
PostgreSQL Document API Part 3: Finding Things
A look at searching documents stored in Postgres. It can be extremely performant thanks to JSONB and a combination of indexing and full text search.
Rob Conery
Meteor PostgreSQL
Meteor now has a preview version of Postgres support available.
readthedocs.​org
What's New in PgBouncer 1.6
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.
2ndQuadrant
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.