This Week's PostgreSQL News (#170)

Datetime:2016-08-23 02:17:19          Topic: PostgreSQL           Share

Actually Understanding Timezones in PostgreSQL

Postgres’s support for timezones is one of the best amongst relational databases, but what’s the difference between timestamp and timestamptz? This practical guide lays out the things you need to know.

Chris Clark #tutorial 

PostgreSQL 9.6 Beta 4 Released

This release contains previews of all of the features which will be available in the final release of version 9.6.

postgresql .​ org    #news 

2016-08-11 Security Update Release

The PostgreSQL Global Development Group has released an update to all supported versions, including 9.5.4, 9.4.9, 9.3.14, 9.2.18 and 9.1.23. It’s not as critical as other security releases but you’re still encouraged to upgrade when you can.

PostgreSQL #news 

RAM increased across all plans. Now get 2GB of RAM for only $10/mo.

Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code POSTGRES20

Linode #sponsored 

postgresql-cpp: A C++11 Port of Postgres

Postgres doesn’t generally get ported to other languages, so it’s interesting to see this attempt to port to C++’s C++11 standard. This community member highlights post indicated there may be benefits.

Joy Arulraj #code 

An Easy Way to Use a PostgreSQL Database (and Hstore) from Go

Hstore is an extension that provides key-value storage capabilities directly in Postgres. This library provides an easy way to use a Postgres database (and the Hstore feature) from Go.

Alexander F Rødseth #code 

Understand Full-Text Search with Postgres

Full-text search is powerful in Postgres, but not without a learning curve. This in-depth guide covers about everything you need to know to get up and running with it.

Piotr Lewandowski

migra: PostgreSQL Migrations Made Almost Painless

It’s like ‘diff’ but for PostgreSQL schemas.

Robert Lechte #code 

BDR 1.0 (Bi-Directional Replication for PostgreSQL)

BDR provides multi-master replication across Postgres 9.4 instances.

Craig Ringer #tools 

Using State Machines to Run Databases

While not directly about running Postgres, if you want a look at how a large as-a-service offering provides databases at scale this gives you a look. The key under the covers is a state machine, used by both Citus and Heroku Postgres.

Citus Data

Stop wasting time - know what you'll earn before the interview

On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week

Hired .​ com     #job 




About List