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 TiKV (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.

How to migrate from SQL to MongoDB — Learn why today's most innovative companies are migrating to MongoDB.

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.