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 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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.