How to Write Complex Recursive SQL Queries — The English isn’t perfect as this is a translation, but the author knows his stuff and you could learn something here.

Egor Rogov

CouchDB 3.0 Now Available — CouchDB is a mature, JSON-document oriented NoSQL database, and one of the earlier modern generation of databases to be called ‘NoSQL’. 3.0 is an interesting release designed to path the way to a FoundationDB-powered version 4.0, with a curious side effect being a drop in the default maximum document size from 4GB to 8MB.

Jan Lehnardt

Learn the Basics of MongoDB in Just Two Hours — Missing out on MongoDB? Don’t wait - Join hundreds of new learners and register for this free course today.

Studio 3T sponsor

A Guide to Running Elasticsearch in Production — Elasticsearch is a popular, flexible, and high performance document database that provides search engine functionality. This post covers a lot of what’s worth knowing about keeping it running in production.

Mattis Haase

The Jellyfish-Inspired Database Under AWS Block Storage — “If you want inspiration for a hyperscale, resilient distributed block storage service, apparently a jellyfish is a good place to start looking for architectural features.” A high level introduction to Physalia, a massively distributed database service that stores the metadata for Elastic Block Store.

Timothy Prickett Morgan

YugabyteDB 2.1 Now GA: Scaling New Heights with Distributed SQL — YugabyteDB is an open source, distributed SQL database focused on resilience and low query latency. The 2.1 release brings better performance (at quite a significant level over YugabyteDB 2.0), two data center (2DC) deployments, read replicas, security enhancements (including key rotation), and more.

Sid Choudhury

Google Adds In-Memory BI Option to BigQuery — Response times for interactive queries in Google BigQuery are about to get better thanks to a new in-memory BI option.

Alex Woodie

How to Read an (Oracle) Execution Plan — Learn to follow and understand the steps and processes in an SQL statement’s execution plan.

Chris Saxon (Oracle)

Snel: SQL Native Execution for LLVM — A paper looking into Snel, a relational database engine featuring LLVM-powered Just-In-Time (JIT) compilation of queries, columnar data representation and which is either dynamically linked into other systems or works as an SQLite extension (so essentially an embedded OLAP database — DuckDB is worth considering if you want something similar that’s already open sourced).

Mottalli, Ajzenman and Sarraute

Google Adds In-Memory BI Option to BigQuery — Response times for interactive queries in Google BigQuery are about to get better thanks to a new in-memory BI option.

Alex Woodie