Not rendering correctly? View this email as a web page here.
Crunchy Data Newsletter

PostgreSQL update releases for 12.4, 11.9, 10.14, 9.6.19, and 9.5.23 are available Thursday, August 13. We thank the community for their continued efforts developing our favorite open source database!

Announcing pgBackRest for Azure - Fast, Reliable Postgres Backups - pgBackRest aims to be a fast, reliable, easy-to-use backup and restore solution with the ability to seamlessly scale to the largest databases. It's been around for a number of years with support for AWS and just recently received one more exciting update: support for Azure

Avoiding the Pitfalls of BRIN Indexes in Postgres - When implemented correctly, BRIN offers significant benefits such as space savings and speed. However, when implemented incorrectly, it loses some of its benefit, so it's important to look at some of the reasons a BRIN index might not be right for you.

Getting Started with PostgreSQL Operator 4.3 in OpenShift - Deploying an Operator on OpenShift can be viewed as an intimidating thing, but it doesn't have to be. In this post, we're going to walk through the quickest and easiest possible way to get started!

How to SCRAM in Postgres with pgBouncer - The beauty of SCRAM is that both authenticating parties can both verify that each party knows a secret without ever exchanging the secret. In this case, the secret is a PostgreSQL password! Check out how SCRAM works in Postgres.

Building a User Registration Form with Django's Authentication System - Follow along as we show how to set up a "self-registration" form using Django's built-in authentication (which includes built-in forms like UserCreationForm). It would be beneficial to be familiar with some Django fundamentals such as models, views, templates, and URLconf. 

A Walk Through PostgreSQL INSERT - The INSERT command is used to add new data to a table and there are some neat tricks you can learn to do with it. This post is a refresher on INSERT and also introduces the RETURNING and ON CONFLICT clauses if you haven't used them yet, commonly known as upsert. 

Cloud Native and Geospatial Information - How do developers serve up geospatial data in a cloud-native way? Adam Timm shows how Crunchy Postgres for Kubernetes, Crunchy Spatial and Openshift can deliver a scalable, cloud-native GIS platform that can also house your non-spatial business/mission data during this DevNation Federal Deconstructed web series.

Screen Shot 2020-08-10 at 12.34.10 PM

Follow us on Twitter and LinkedIn for daily updates.