DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
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 10 Beta 4 Released
postgresql.​org   news  
New Perf Levels and Storage Add-ons for Azure SQL Database
Morgan Oslake   news  
MongoDB Drops Support for Solaris
MongoDB Engineering   news  
A Guide to Data Synchronization in Microsoft SQL Server
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  
The 20 Best MySQL GUI Tools as of 2017
Krissanawat​ Kaewsanmuang   tools  
Honey SQL: Turn Clojure Data Structures Into SQL
Justin Kramer   code  
« Prev
Next »