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

SQLFluff

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

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.

Vaticle