Issue 170 — September 1, 2017
JOIN Elimination: An Essential Optimization for Advanced SQL Usage — It’s possible to transform many SQL statements into more optimized ones. This is a deep dive into how that works when joins are involved.
Lukas Eder tutorial
How Salesforce Is Using AI to 'Democratize' SQL — ..so anyone can query databases in natural language. It’s explained in detail in this academic paper.
TechCrunch news
Understanding Tricky Joins and Multi-Table Updates — Writing a proper SQL UPDATE query involving multiple tables in Postgres can be tricky and counterintuitive. Here’s a particularly tricky example and the concepts involved.
Paul Martinez tutorial
HumongouS.io: A universal admin interface for MongoDB — Generate automatically an enterprise grade admin interface for your MongoDB database with support for joins, custom views, smart forms and charts.
HumongouS.io sponsored
Five Sharding Data Models and Which Is Right — A survey of five sharding approaches and what factors could guide you to each approach.
Craig Kerstiens tutorial
Deferrable SQL Constraints in Depth — Automatic constraint enforcement is a useful and powerful feature, but sometimes there are reasons to defer enforcement, as examined in depth here.
Joe Nelson tutorial
How We Designed CrateDB as a Realtime SQL DBMS for IoT — The DBMS design choices that Crate.io made to support an IoT workload.
Jodok Batlogg opinion
KSQL: Open Source Streaming SQL for Apache Kafka — KSQL provides a simple and interactive SQL interface for processing data in Kafka, rather than having to write Python or Java functions.
Neha Narkhede news
Percona Live Europe 2017 - Dublin (25-27 September) — Join the Open Source database community for various talks on MySQL, MongoDB, MariaDB, PostgreSQL, RocksDB & more.
Percona Live Europe sponsored
postgresql.org news
Morgan Oslake news
MongoDB Engineering news
Brandon Morelli tutorial
Using JS for Extending Low-Latency In-Memory Key-Value Stores — A look at the potential for JavaScript in RAMCloud.
Adrian Colyer story
The Hidden Costs of Data Engineering — Managing databases in today's environments presents many complex problems. See the impact in this 2016 survey.
VividCortex sponsored
Krissanawat Kaewsanmuang tools
Justin Kramer code