#293 — February 28, 2020
Database Weekly
It's a compact and bijou issue this week as Cooperpress is in the middle of some organizational changes — back to full service next week! 😄
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
Quick bytes:
- SQL Server supports emojis in identifiers. Fun! Oracle does too (and so should any database that supports Unicode in identifiers).