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 109 — June 10, 2015
PostgreSQL 9.4.3, 9.3.8, 9.2.12, 9.1.17 & 9.0.21 Released
This release primarily fixes a startup failure problem created by the prior update release, and should be installed by all users who applied that release.
Postgresql.​org
Porting ActiveRecord's 'Soft Delete' Behavior to Postgres
The soft delete mechanism of some ORMs is incredibly valuable, it lets you actually retain your data while “deleting” a user or record.
Sean Huber
SQLPro for Postgres: A Mac OS X Postgres Manager
This beta is available for free.
Hankinsoft Development   #tools 
Opbeat = Ops for developers
New feature: Auto-assignments. When an error occurs, Opbeat deduces who the best equipped person to fix the code is, via Git. Receive fewer but smarter notifications spend more time being productive. Read the full article.
Opbeat    #sponsored 
Moving past averages in Postgres with Percentiles
Averages are fairly straight forward to compute, but not always the best metric. Sometimes percentiles such as perc 90 or perc 95 are better indicators of how you’re actually doing, fortunately you can pretty easily get directly to those in SQL.
Craig Kerstiens
Postgres UPSERT ON DUPLICATE and How Other Databases Implement UPSERT
Want to see how Postgres’ upsert compares to other offerings? Here’s a rundown of the syntax vs. what other databases support.
Micha Roders
Porting ActiveRecord Validations to Postgres
A look at how common ActiveRecord validations port to Postgres constraints in SQL.
Sean Huber   #tutorial 
Goodbye jsonb_replace, Hello jsonb_set
While a small change, a pretty critical one to the JSON operators for Postgres 9.5 this will easily let you update some value deep within a larger JSON object.
Andrew Dunstan
CFP for PGConf Silicon Valley Closes June 15th
Postgresql.​org   #news 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.