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.
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.
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.
How To Write Better SQL Queries
— A reasonably thorough primer to SQL queries and the decisions you have to make while constructing them.
TiSpark: Run Apache Spark on Top of TiDB/TiKV
— A thin layer that brings Spark SQL to
(a distributed key value store) for doing complex OLAP queries.
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.
Shoveling Data to Redshift with Pipes and Filters
Urjit Singh Bhatia
How to migrate from SQL to MongoDB
— Learn why today's most innovative companies are migrating to MongoDB.
Building a Simple GraphQL Server with Neo4j
How Far Can You Go with MySQL or MariaDB?
— There are installations heading into multiple terabytes.
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?”
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.
q: Run SQL directly on CSV files
— Loads CSV into SQLite and lets you query with SQL.
TablePlus: A Mac App for Working with Relational Databases
— Currently supports Postgres, MySQL/MariaDB, and Redshift.
Neo4j Releases Efficient Graph Algorithms Library for Neo4j
— Covers things like PageRank, partitioning, and path finding.
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.
Rezoom.SQL: Statically Typed SQL ORM for F#
An Opinionated MongoDB Style Guide