Issues » 43

Archives   Read this issue on the Web
Postgres Weekly Issue 43
January 22, 2014
Postgres 9.4 Feature Highlight: ALTER SYSTEM SET for Dynamic Configuration
While you could modify many config settings for a specific database, in 9.4 with some new new SQL commands you’ll be able to modify the configuration of the Postgres server itself.
Michael Paquier
PostgreSQL Conference New York - April 3-4, 2014
PGConf NYC 2014 focuses on how people use PostgreSQL, from the perspective of developers, DBAs, systems administrators, and decision makers. The schedule for the site is now live, take a look at the talks and make sure to register.
PGConf NYC 2014
Understanding Postgres Parameter Context
There’s a variety of controls within Postgres, each of these have different times and opportunities where they can be modified. Here’s a great simple overview into them.
Gurjeet Singh
SQL for Reporting Queries
A collection of Postgres queries by @selenamarie that highlights some of the more powerful as well as useful features including CTEs, JSON, HyperLogLog, and Window functions.
Selena Deckelmann
Woolly: A Mac GUI for Postgres
There continues to be more and more in the line of admin interfaces for Postgres, clearly attempting to address the hole of quality ones. Here’s yet another attempt for Mac.
Mac App Store
Constructing Escape-Time Fractals with PostgreSQL
While not overly practical here’s a few really fun queries showing just how expressive you can be in SQL.
Explain Extended
DB Doc 1.0: Postgres Database Documentation Tool
Commercial software (with a trial) that documents your server’s properties, settings, and database objects.
Yohz Software
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2013 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens