Postgres 10.4 released, and having fun with recursive CTEs

The latest Postgres news, articles, tools, and projects.

#256 — May 16, 2018 Read on the Web Postgres Weekly PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18, and 9.3.23 Released — This release fixes one security issue in all supported versions, as well as numerous bugs reported over the last few months. PostgreSQL Global Development Group Fun with SQL: Recursive CTEs in Postgres — A quick exploration of recursive CTEs (Common Table Expressions) which allow themselves to be called until some condition is met. Craig Kerstiens Linux Cloud Hosting Starting at 1GB of RAM for $5/mo — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you're ready to deploy your server. Get $20 credit on a new account. Linode Cloud Hosting sponsor An Overview of the 'serial' Pseudo-Datatype — An introduction to the special implementation of serial data types typically used for the creation of synthetic primary keys. Berend Tober TimescaleDB vs MongoDB for Storing Time-Series Data — TimescaleDB is a Postgres fork focused on time-series data, so it may come as no surprise that it's faster at the task. Rob Kiefer Using 'cgroups' to Limit Postgres Resource Usage on Linux — Control groups are a Linux feature that allow processes to be organized into hierarchical groups whose usage of various types of resources can be limited and monitored. Laurenz Albe PostGIS for Managers [PDF] — Note-heavy slides presenting an introduction to PostGIS, how its features compare to Oracle's, and how it can integrate with other systems. Paul Ramsey slidedeck Unified Management & Automation for PostgreSQL Severalnines sponsor From Nothing to REST API with PostgREST — A minimal example of getting a PostgREST API running from scratch for testing purposes. Michel Pelletier Events PostgresOpen 2018: Call for Papers — The event takes place early September in San Francisco. Talk submissions will be accepted up until June 12. PostgresOpen Postgres Vision 2018 — June 5-6 (Boston, USA) Postgres in the Cloud - Front and center at Postgres Vision 2018. PGDay.IT 2018 — June 28 - 29 (Pacengo di Lazise, Italy) The Italian conference dedicated to PostgreSQL. PGConf UK 2018 — July 2- 3 (London, UK) Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.

Curated by Cooperpress and Craig Kerstiens Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom