Issue 319 - Building faster Postgres trigger functions in C (9)

Percona Distribution for Postgres 11 (Beta) Now Available — Percona, perhaps more historically known for its MySQL performance expertise, is now in the PostgreSQL world too. This Percona-flavored distribution of Postgres 11 includes a variety of tools and extensions to make Postgres more powerful and scaleable.

Building Faster, Lightweight Trigger Functions in C — Trigger functions/procedures (functions that run automatically when certain events occur on a table) are commonly written in PL/pgSQL, but C can come in handy when high performance is absolutely essential.

📕 20 Patterns to Watch for in Engineering Teams — GitPrime's new book draws together some of the most common software team dynamics, observed in working with hundreds of enterprise engineering organizations. Actionable insights to help you debug your development process with data. Get your copy.

Rotating Postgres Passwords with No Downtime — The basic idea is to create separate roles and temporarily have two active at the same time before deactivating the ‘old’ one.

Porting a Postgres Extension from Unix to Windows 10 — Building your own Postgres extension from scratch is one thing, porting an existing one to support a different operating system is quite another, particularly when Windows is the target. Few of you are unlikely to need to do this, but these notes may be invaluable if you do..

See How Easy Managing Access to Postgres Can Be — Splunk's CISO says "strongDM lets you see what happened, replay and analyze incidents. You can't get that anywhere else."

A Function to Clone a Schema — A developer needed a function to clone/copy schemas in Postgres, fixed it up to support materialized views, and has re-released it here.

pgsodium: A Postgres Extension for Using libsodium — libsodium is a crypto library for encryption, decryption, signatures, password hashing and more.