DB Weekly
Archives| Latest| RSS
« Prev
Next »
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  
« Prev
Next »