Zeitgeist.8

Being an account of some things that captured my interest this week.

I went to the Sydney AWS Summit.

Nothing says cloud like casual business attire and thumping electronic.

Spotify’s Love/Hate Relationship with DNS

I know we’re all DevOps these days, but my theory is you can tell who is more ops by how well they grok DNS.

Why you shouldn’t use ENV variables for secret data

On AWS, you can use KMS.

How to query JSONB, beginner sheet cheat

Number 089623798465 in my series “PostgreSQL is teh Best”.

Streaming Postgres to Kafka and Maintaining Consistency and Transaction Isolation

Thoughts on managing transaction boundaries when dealing with streaming data. PG, but applies to all such systems.

Deploy Confluent Platform on the AWS Cloud

Speaking of streaming systems, this AWS Quick Start makes setting up the Confluent platform much easier.

Distributed count(distinct) with HyperLogLog on Postgres

Demonstrates use of PostgreSQL extension adding HyperLogLog data structures as a native data type.

HyperLogLog is an algorithm for estimating unique number of elements in a list.

Also, PipelineDB has HyperLogLog built in. Just saying.

The Epistemology of Information Technology

Datacentres are hard.