#​355 — May 21, 2021

Read on the Web

Database Weekly

SQLFluff: A SQL Linter and Auto-Formatter — A ‘dialect-flexible’ SQL linter that aims to automatically fix most linting errors. Written in Python.


PostgreSQL 14 Beta 1 Released — The first “this is ready for you to give it a try” release of the next major PostgreSQL release is here. Postgres 14 features a variety of performance improvements across the board, adds new multirange types, VACUUM enhancements, and more.

PostgreSQL Global Development Group

An Operations-Free, Scalable & Flexible Postgres Alternative — Fauna combines the operational integrity and relational modeling of Postgres with an interface and architecture that fits better with modern app development in the cloud. The goodness of Postgres without its operational bottlenecks - Learn more about Fauna.

Fauna sponsor

PlanetScale Unveils Distributed MySQL Database Service Based on Vitess — I’ve been seeing buzz about PlanetScale on Twitter for a while, particularly around all the hires they’ve been making. So it’s interesting to finally see what they’re up to. Essentially it’s a developer-focused ‘serverless’ database platform offering ‘indefinite scaling’, branching, and CLI tooling.

Alex Woodie


  • Percona is celebrating its fifteenth birthday. They started as a small MySQL performance consulting shop but now have over 260 employees and work on numerous projects including MongoDB and PostgreSQL too.

Everything You Need to Know About DynamoDB Partitions — Amazon’s DynamoDB is incredibly scalable but has its own particular way of operating that may seem alien to many developers. This post digs deep into the partitioning side of things which, ultimately, is the biggest part of how and why DynamoDB is so fast and can scale so far.

Alex DeBrie

Scheduling Google Cloud SQL Instances to Start and Stop to Reduce Costs — This is certainly the serverless PAYG model dream..

Jonathan Simon (Google)

eBay’s New Optimized Spark SQL Engine for Interactive Analysis — How eBay created an optimized SQL solution to enhance speed, stability and scalability in service of a new open-source-based analytics platform.

Ma, Li, and Dhanpal (eBay)

Free eBook: Finding the Root Cause of Slow Postgres Queries Using EXPLAIN — An in-depth guide on how to use Postgres EXPLAIN to find and improve problematic query plans and how to use auto_explain.

pganalyze sponsor

Why Do (Some) Database Columns Have a Character Length of 191, Specifically?varchar(191) is an odd thing to see in numerous places - where does it come from? Not to spoil things too much, but MySQL is involved.

Evan Tahler

An Approach to Processing a Trillion-Edge Graph on One Computer — Graphs have lots of uses from representing social networks to webs of financial transactions but they can become unwieldy at scale. KAIST has come up with a solution for working with gigantic graphs on relatively modest systems, though it’s just research / academic level work for now.

Oliver Peckham (Datanami)

TypeDB: A Strongly-Typed Distributed Knowledge Graph — A lot of databases are strongly typed, but the idea here is for organizing large networks of data using knowledge engineering principles. It has its own ‘reasoning and analytics’ query language called TypeQL and is built in Java. It was formerly known as Grakn and we featured it in issue 250.


Forget SQL vs NoSQL: Get the Best of Both Worlds with JSON in PostgreSQL
Derek Xiao


Find Data Engineering Jobs with Hired — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now.