DB Weekly Issue 176: October 13, 2017

An Interview with SQL's Co-Creator, Don Chamberlin — A fascinating researcher who has also had a major role in developing XPath and XQuery. This interview digs into some of the earliest database history.

AthenaX: Uber's Open Source Streaming Analytics Platform — Uber has open sourced its streaming analytics platform bringing large-scale SQL-driven event stream processing to everyone.

How to Stop a Runaway Index Build in MongoDB — Index builds in MongoDB can have an adverse impact on the availability of your cluster. When triggering a foreground index build on a large collection, your cluster may be unresponsive until the build is complete. While the recommended best practice is...

Scaling the Relational Database with NewSQL — A thorough write up of a talk given by one of the creators of TiDB, a distributed SQL database, on why and how it was created.

MySQL Fixes An auto_increment Bug Reported in 2003 — A look at a long standing bug finally fixed in MySQL 8.

CockroachDB 1.1 Released: Production Made Easy — CockroachDB 1.1 (an open source, distributed SQL database) supports faster migrations from legacy databases, simplified cluster management, and improved performance.

Mature MADlib Moves Up Apache Development Chain — MADlib is an open source in-database analytics library making inroads in cloud-based AI applications.

NoSQL vs Relational Database File Storing — A look at storage in NoSQL vs relational databases by comparing MongoDB and SQL Server.

A Fast Track Hadoop Curriculum: Going from 0 to 60

Free team guide on continuous delivery from GoCD — Free Continuous Delivery 101 ebook where you’ll get a reference guide with visuals on key concepts.

Taming SQL for Query Optimization — The latest in a series on writing a query optimizer for Hyrise, a main-memory column-oriented research database.

Migrating to a New Database Without Impacting Users

DevOps Practices for Database Teams

6 SQL Data Warehouse Solutions For Big Data Analysts — Complete with pros and cons of each.

To SQL or Not to SQL? — A comparison of SQL and NoSQL, and a overview of common databases of each type

Data Lakes Are More Than Just 'Dump Your Data Here'

HumongouS.io: A universal admin interface for MongoDB — Generate an enterprise grade admin interface for your MongoDB database with support for joins, smart forms & charts.

redis-graph: A Graph Database with Cypher Query Language as a Redis Module

Wallaroo: An 'Ultrafast', Elastic Data Processing Engine — Currently with bindings for C++, Pony & Python. There’s also a video explaining why it exists.