DB Weekly Issue 100: April 14, 2016

Analyzing the Panama Papers with Neo4j — A look at how a graph database has major strengths to deep dive into large, interconnected collections of documents like the Panama Papers.

Scaling a MySQL Datastore By 20x+ in 3 Weeks — The tale behind how a team rapidly scaled their MySQL-based datastore and the problems and tools they encountered along the way.

PostgreSQL Bloat: Origins, Monitoring and Managing — PostgreSQL's MVCC model supports running multiple transactions operating on the same data set, but questions have arisen around bloat. Here's a look at how it can affect performance and how to monitor and manage it.

Do GPU Optimized DBs Threaten Oracle, Splunk and Hadoop? — GPU optimized databases are moving from science project to business reality, but what does that mean?

MySQL 5.7.12: Big Steps Forward for MySQL? — The usual bug fixes and enhancements expected with a point release, but a new protocol and a new MySQL Shell are also emerging.

How The Guardian Analyzed 70m Comments On Its Site — A brief, high level look. It required joining together their AWS-hosted Postgres database, Redshift, CSV files, and Apache Spark.

PostgreSQL Query Optimization — For many, what happens when you join two tables is a mystery. Once you do build a deeper understanding, it becomes much easier to optimize joins - luckily it’s not rocket science to understand some of the logic under the covers, as seen here.

Work on a Better Stack — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly.

AWS Schema Conversion Tool Now Supports Conversions Between MySQL and PostgreSQL

Securely Modernizing Employee Access Management with Graph Databases

What Does PostgreSQL 9.5 Bring to Developers

The Ancient Greek Guide to Re-Negotiating with Oracle — Learn valuable tips from the CEO of Palisade Compliance, Craig Guarente, a 16-year licensing veteran from Oracle.

Using SQL to Calculate the Popularity (on Stack Overflow) of Derby, H2, and HSQLDB

ElasticSearch Cluster Rolling Restart at the Speed of Light

How We Get High Availability with Elasticsearch and Ruby on Rails

A Developers' Guide to Azure SQL Data Warehouse

Urban Myths About SQL (2015) (slidedeck)

The Unspoken Complexity of NoSQL

Could PostgreSQL 9.5 Be Your Next JSON Database? — TL;DR: No, but that’s not the right question.

Mongoclient: A MongoDB Management Tool

Sqlectron: A Simple DB Client for Postgres, MySQL and SQL Server — A simple and lightweight SQL client desktop/terminal with cross database and platform support.

PGInsight: CLI Tool to Dig Inside Your Postgres Databases — Easily dig deep inside your Postgresql database. Features include finding index information, disk usage, cache hits and more.

Auto-generated APIs for any database — Powerful API automation for standardization, portability, and scale. Free dev environment for testing and rapid prototyping.

Corvus: Fast and Lightweight Redis Cluster Proxy for Redis 3.0

gredis: A Redis Server built over grpc

jseg: JavaScript Entity Graph — A super simple, in-memory, JS graph database.

Data Modeling in Cassandra From A Postgres Perspective — Usually we highlight articles of people moving from other systems to Postgres, in a contrast here’s how to apply a Postgres perspective to a database that doesn’t lend quite the same flexibility–Cassandra.

An SQL Joins Visualizer — A simple, but very clear tool to visually explain joins in SQL.