Issue 166 — August 4, 2017
More Dangerous Subtleties of JOINs in SQL — Two examples of how common, yet profoundly consequential, semantic errors in SQL can be.
Alex Petralia tutorial
Implementing State Machines with SQL in Postgres — A practical look at creating a FSM using a transition function, a user-defined aggregate function and a table to keep track of events.
Felix Geisendörfer tutorial
A Live Demo With a VividCortex Engineer — Join a live demo with a VividCortex engineer to show how the VividCortex solution can eliminate your most critical visibility gaps.
VividCortex sponsored
How To Write Better SQL Queries — A reasonably thorough primer to SQL queries and the decisions you have to make while constructing them.
Karlijn Willems tutorial
TiSpark: Run Apache Spark on Top of TiDB/TiKV — A thin layer that brings Spark SQL to TiKV (a distributed key value store) for doing complex OLAP queries.
PingCAP tools
A Practical Guide to SQL Transaction Isolation — A detailed post on how transaction isolation works, particularly in Postgres. A good read if you just rely on the defaults.
Joe Nelson tutorial
Urjit Singh Bhatia tutorial
How to migrate from SQL to MongoDB — Learn why today's most innovative companies are migrating to MongoDB.
MONGODB sponsored
William Lyon tutorial
How Far Can You Go with MySQL or MariaDB? — There are installations heading into multiple terabytes.
Jean-François Gagné story
Analyzing 320 GB of SQL for Comma Usage — "Leading with commas is not a popular style — but I’ll argue that it’s a productive one. Can I prove this?"
Felipe Hoffa story
Open Source Redshift Vacuum and Analyze Tool — Save time on maintenance, use our dockerized vacuum & analyze tool. Pull the image, schedule, and get reports to your email.
Alooma.io tools sponsored
q: Run SQL directly on CSV files — Loads CSV into SQLite and lets you query with SQL.
Harel Ben-Attia tools
TablePlus: A Mac App for Working with Relational Databases — Currently supports Postgres, MySQL/MariaDB, and Redshift.
TablePlus Ltd tools
Neo4j Releases Efficient Graph Algorithms Library for Neo4j — Covers things like PageRank, partitioning, and path finding.
Michael Hunger tools
Apache Calcite: A Foundation for High Performance Databases — A Java dynamic data management framework that includes a SQL parser, a relational algebra API, and a query planning engine.
Apache Foundation tools
Robert Peele code
Jan Söndermann code