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.
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
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.
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.
Five Sharding Data Models and Which Is Right
— A survey of five sharding approaches and what factors could guide you to each approach.
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.
How We Designed CrateDB as a Realtime SQL DBMS for IoT
— The DBMS design choices that Crate.io made to support an IoT workload.
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.
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
PostgreSQL 10 Beta 4 Released
New Perf Levels and Storage Add-ons for Azure SQL Database
MongoDB Drops Support for Solaris
A Guide to Data Synchronization in Microsoft SQL Server
Using JS for Extending Low-Latency In-Memory Key-Value Stores
The Hidden Costs of Data Engineering
— Managing databases in today's environments presents many complex problems. See the impact in this 2016 survey.
The 20 Best MySQL GUI Tools as of 2017
Honey SQL: Turn Clojure Data Structures Into SQL