#242: Postgres's Hidden Gems

.

Read this on the Web

Postgres Weekly Issue 242 — February 7, 2018

Standard SQL Features Where Postgres Beats Its Competitors Code-heavy slides from a talk given at FOSDEM PgDay that cover filters, BOOLEAN tests, XMLTABLE, and inverse distribution functions. Markus Winand Postgres's Hidden Gems A collection of responses to the question: “Whats your favorite hidden gem of Postgres that you wish more people knew about?” Craig Kerstiens   #opinion  PostgresConf US 2018: The Largest Postgres Conference Series in the World Happening April 16 - 20 at the Westin Jersey City Newport, we will be featuring two full days of Postgres training opportunities, three days of breakout session content, a large sponsor hall, numerous workshops, a job fair, and more. Register today. PostgresConf.​org    #sponsored  Find The Longest Continuous Number of Days a Stock Went Up We all love a good, thorough SQL tutorial, right? This is a great walkthrough of bringing together several SQL features in a relatively advanced way. Dimitri Fontaine Postgres Indexing: Index vs. Bitmap vs. Sequential Scans A quick intro to index scans in Postgres, highlighting what the optimizer does when a single query is processed. Hans-Jürgen Schönig Exporting a Hierarchy in JSON with Recursive Queries Putting JSON into Postgres is pretty simple nowadays, but exporting it in elaborate ways can require a bit of work as in this example. Dimitri Fontaine Demystifying Contributing to Postgres Want to contribute some code, a patch, even some documentation? Here’s a talk covering how to get involved. (See links to the slides and video at the bottom of the page.) Lætitia Avrot SelectStar: One Monitoring Solution to Cover All Your (Data)bases SelectStar    #sponsored  How The Citus Distributed Database Rebalances Your Data Citus is an extension for scaling Postgres horizontally. citusdata How Updating A Partition Key Would Work in Postgres 11 Stefan Fercot Easily Setup Postgres 10 and pgAdmin 4 with Docker Jonathan S.​ Katz Creating Fast, Lightweight Testing Databases in Docker Kevin Barresi Postgres Tip: Working With Dates Using the EXTRACT Function Karol Galanciak Linux Cloud Hosting Starting at 1GB of RAM for $5/mo Linode Cloud Hosting    #sponsored  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