#256 — May 16, 2018 |
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 extension 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 |
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.
|