#166: How To Write Better SQL Queries

This week's database news - Read this on the Web

Database Weekly 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   Shoveling Data to Redshift with Pipes and Filters Urjit Singh Bhatia   tutorial   How to migrate from SQL to MongoDB — Learn why today's most innovative companies are migrating to MongoDB. MONGODB   sponsored   Building a Simple GraphQL Server with Neo4j 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   Rezoom.SQL: Statically Typed SQL ORM for F# Robert Peele   code   An Opinionated MongoDB Style Guide Jan Söndermann   code   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK