#218: Implementing State Machines in Postgres

.

Read this on the Web

Postgres Weekly Issue 218 — August 2, 2017

Implementing State Machines in Postgres A practical look at creating a FSM in Postgres using a transition function, a user-defined aggregate function and a table to keep track of events. Felix Geisendörfer A Practical Guide to SQL Transaction Isolation A detailed post on how transaction isolation works, particularly in Postgres. A good read if you just rely on the defaults. Joe Nelson Scaling Out (Postgre)SQL An in-depth talk on scaling via distributing query computation tasks across many servers. (Note: To watch the video, click the yellow play button.) Marco Slot   #video  2ndQuadrant PostgreSQL Conference - November 6-9, 2017 2Q PGConf is dedicated to exchanging & increasing knowledge about PostgreSQL. Join us for this unique opportunity taking place in NYC & Chicago to learn more about recent achievements and exciting future developments in PostgreSQL from world-class experts. 2ndQuadrant PostgreSQL Events    #sponsored  A 'Call for Quotes' for Postgres 10's Release Notes The Postgres team are looking for quotes from Postgres users about new features in the upcoming release. Jonathan S.​ Katz   #news  PostGIS 2.3.3 Is Now Available with BigSQL A patch release with a focus on fixing bugs and breakages. Holly Orr   #news  Calculating Response Times with Window Functions and CTEs Matteo Ferrando Database Table Types with Citus and Postgres Citus, which extends Postgres to make sharding simple, introduces a few new types of tables in Postgres. Here’s a tour of the things you need to think about. citusdata Work Smarter with SelectStar See how SelectStar can expertly monitor replication in your Postgres database. Start your free trial today. SelectStar    #sponsored  Analyzing a Billion Taxi Rides with BrytlytDB and 2 GPU-Powered EC2 Instances BrytlytDB is an in-GPU-memory database built on top of Postgres. Mark Litwintschik Postgres Natural Joins Squash Unneeded Columns When it comes to databases there are a number of types of joins that exist. Natural joins are a less known set that can help as highlighted here. Hashrocket TIL 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