#214: How to Use Ansible to Manage Postgres

.

Read this on the Web

Postgres Weekly Issue 214 — July 5, 2017

Analyzing Ethereum, Bitcoin, and 1200+ Cryptocurrencies Cryptocurrencies are fuelling a modern day gold rush. How can we use Postgres and some SQL to better understand this evolving market? Timescale How to Use Ansible to Manage Postgres Ansible, an open source automation tool, can make complex configuration and management tasks in Postgres simple. Opensource Postgres-XL: MPP and Horizontally Scalable PostgreSQL from 2ndQuadrant Postgres-XL is a massively parallel database built on top of and very closely compatible with PostgreSQL 9.5. It is flexible enough to handle OLAP & OLTP workloads and is Horizontally Scalable with all the features of PostgreSQL. 2ndQuadrant PostgreSQL Products    #sponsored  Announcing PGConf Austin 2017 — Call for Papers Open It’s being held November 3-4 and the CFP is open till August 20. Joshua Drake   #news  Uptown Func: Uses for Postgres Functions “creating a set-returning function in Postgres is almost frighteningly trivial when compared to other database engines” Shaun Thomas Efficient Rollup Tables with HyperLogLog Part two of a series, this one looks at how HyperLogLog can be combined in various ways to give you more efficient rollups for dashboards and metrics. citusdata Postgres and the Calendar Working with calendars can be surprisingly frustrating from various formats to dealing with the nuance of leap years. Postgres yet again can do much of the hard work for you as shown here. Dimitri Fontaine Migrating Oracle Databases to Postgres on Amazon RDS See how to migrate to PostgreSQL on RDS in three steps SelectStar    #sponsored  Postgres Open Silicon Valley's Line-Up: A First Take Craig Kerstiens   #opinion  Playing with Unicode Crafting SQL queries to return ‘Regional Indicator Symbols’ which are formed as special combination of Unicode characters. Dimitri Fontaine What is 'SKIP LOCKED' for in Postgres 9.5? A year old but has become popular on social media again this week. Craig Ringer An Intro to PostgreSQL in 45 Minutes from PGConf US Joe Conway   #video  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK