#282 — November 14, 2018

Read on the Web

Postgres Weekly

PipelineDB 1.0: High-Performance Time-Series Aggregation for PG 11 — If this feels similar to last week’s announcement of TimescaleDB 1.0, another time series system for Postgres, PipelineDB is more focused on aggregation and does not store granular data long term. As they put it themselves, “PipelineDB should be used for analytics use cases that only require summary data, like realtime reporting dashboards.”

Derek Nelson

Postgres 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released — A bumper set of releases issued primarily to fix a SQL injection security issue in pg_upgrade and pg_dump. This also marks the final release of 9.3 which has now reached its end-of-life.

PostgreSQL Global Development Group

JackDB: A Modern Database Client for Postgres — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today.

JackDB, Inc. sponsor

Using Encryption to Strengthen Postgres Database Security — An overview of the ways you can use encryption as one of the measures to establish database security and keep data protected.

Maryann Kamau

The Ghost of phpPgAdminphpPgAdmin is a now rather old Web-based Postgres administration tool (in a similar vein to MySQL’s phpMyAdmin) but there’s a new release supporting recent Postgres versions.. the only catch is it remains for PHP 5 but a PHP 7 version is coming soon.

Robert Treat

Preventing SQL Injections in Postgres — SQL injection occurs when an app allows user input (or any other unexpected data) to change the structure of an SQL query. Here are some ways to avoid that.

Dimitri Fontaine

Using Postgres for Machine Learning: Kmeans Clustering — The first in a new series of posts looking at how you can use machine learning algorithms without leaving Postgres.

Hernan Resnizky

Migrating Oracle Autonomous Transactions to Postgres — While migrating from Oracle to Postgres, you could come across Oracle Autonomous Transactions. This post explains what they are and how to replicate the functionality in Postgres.

Yaser Raja

Dealing with Significant Postgres Database Bloat — What Are Your Options? — When data is updated or deleted in Postgres, new data is written. The old data then needs to be vacuumed. That unvacuumed data is known as bloat. Here’s a look at how you can deal with it.

John Gerhardt

Free Webinar: Backup Management for PostgreSQL — Learn about the types of backups and how to design a backup strategy to ensure high availability.

Severalnines sponsor

Using Parallel Sequential Scan in Postgres — Parallel sequential scan is the first parallel access method in PostgreSQL and is introduced in version 9.6. Here is a walk through of how it works and how to set it up.

Rafia Sabih

🗓 Events

PgDay Argentina 2018 November 21 (Buenos Aires, Argentina) An intensive mini-conference focused on PostgreSQL.

Pg Down Under 2018 December 7 (Melbourne, Australia) PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.

PostgreSQL Conference Europe 2019 October 15–18, 2019 (Milan, Italy) The 11th Annual PostgreSQL Conference Europe, a day of instructor-led training followed by three days of world-class PostgreSQL presentations and a superb hallway track.