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 101 — April 15, 2015
Functions and Addressing JSON Data
Postgres is great at storing and retrieving data, including JSON these days. But what if you need to find a specific value in JSON then manipulate it? That takes a little more effort, but as highlighted here can be easily done with a little PLV8.
Shaun M.​ Thomas
PG Bouncer: Lightweight Connection Pooler for PostgreSQL
PG Bouncer, the best connection pooling application for Postgres, has a new home along with a release that contains some great updates. A good excuse to update your version or check it out if you’ve not yet.
pgbouncer.​github.​io
Browser-based query tool and PostgreSQL client
Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free.
JackDB    #sponsored 
Postgres 9.5 Feature Highlight: log_autovacuum_min_duration At Relation Level
Michael Paquier
Connecting A Pakyow App to Postgres with Sequel
Pakyow, a framework in Ruby that’s focused on view-first development, plays well with many databases, but most importantly Postgres. Here’s a look at plugging in Postgres via Sequel (one of the best Ruby ORMs).
Bryan Powell
Dynamically disabling triggers without locks
A big part of the performance improvements over time come from reducing when and how long locks are held for on certain operations. Take a look at this recently landed feature to no longer hold locks when running an alter table for triggers.
Andrew Dunstan
How To Create Reports in Tableau with PostgreSQL
Tableau is a popular suite of data visualization and reporting tools used in the business intelligence sector.
Stormatics
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.