Sql

Published on
November 14, 2023
Calculating Monthly Active Users (MAU)
mau redis sql
Learn some common strategies on calculating MAU and the tradeoffs between them!
Published on
October 5, 2022
Preventing Postgres SQL Race Conditions with SELECT FOR UPDATE
sql postgres concurrency
Learn how to prevent logical race conditions in read-modify-write SQL workloads using SELECT FOR UPDATE.
Published on
December 18, 2021
Redshift Understanding the "EXPLAIN" Statement
redshift explain debugging sql
Learn how to debug sql queries using the Redshift Explain statement.
Published on
May 13, 2021
Deriving Data Lineage From SQL Statements
sql lineage
How to infer lineage by inspecting SQL statements.