---
title: "This week's database news, issue 100"
publication: "DB Weekly"
issue: 100
published_at: "2016-04-14"
canonical_url: "https://dbweekly.com/issues/100"
---

Database Weekly 100   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/100) 

[Database Weekly](http://dbweekly.com) Issue 100 — April 14, 2016     

Featured [Analyzing the Panama Papers with Neo4j](http://neo4j.com/blog/analyzing-panama-papers-neo4j/?utm_source=dbweekly&utm_medium=email) — A look at how a graph database has major strengths to deep dive into large, interconnected collections of documents like the Panama Papers. Michael Hunger and William Lyontutorial [Scaling a MySQL Datastore By 20x+ in 3 Weeks](https://nylas.com/blog/growing-up-with-mysql/?utm_source=dbweekly&utm_medium=email) — The tale behind how a team rapidly scaled their MySQL-based datastore and the problems and tools they encountered along the way. Christine Spangstory [PostgreSQL Bloat: Origins, Monitoring and Managing](https://www.compose.io/articles/postgresql-bloat-origins-monitoring-and-managing/?utm_source=cooper&utm_medium=dbweekly&utm_campaign=postgres-bloat) — 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. Composesponsored [![\](https://copm.s3.amazonaws.com/2761114c.png)](https://www.compose.io/articles/postgresql-bloat-origins-monitoring-and-managing/?utm_source=cooper&utm_medium=dbweekly&utm_campaign=postgres-bloat) [Do GPU Optimized DBs Threaten Oracle, Splunk and Hadoop?](http://diginomica.com/2016/04/11/do-gpu-optimized-databases-threaten-the-hegemony-of-oracle-splunk-and-hadoop/?utm_source=dbweekly&utm_medium=email) — GPU optimized databases are moving from science project to business reality, but what does that mean? Kurt Markoopinion [MySQL 5.7.12: Big Steps Forward for MySQL?](http://mysqlserverteam.com/mysql-5-7-12-part-1-more-than-a-maintenance-release/?utm_source=dbweekly&utm_medium=email) — The usual bug fixes and enhancements expected with a point release, but [a new protocol](http://mysqlserverteam.com/mysql-5-7-12-part-2-improving-the-mysql-protocol/) and [a new MySQL Shell](http://mysqlserverteam.com/mysql-5-7-12-part-4-a-new-mysql-command-line-shell/) are also emerging. Mike Franknews [How The Guardian Analyzed 70m Comments On Its Site](https://www.theguardian.com/technology/2016/apr/12/how-we-analysed-70m-comments-guardian-website?utm_source=dbweekly&utm_medium=email) — A brief, high level look. It required joining together their AWS-hosted Postgres database, Redshift, CSV files, and Apache Spark. Mahana Mansfieldnews [PostgreSQL Query Optimization](http://jinchengli.me/post/postgres-query-opt/?utm_source=dbweekly&utm_medium=email) — 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. Jincheng Li Jobs [Work on a Better Stack](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=betterstack&utm_campaign=q2-16-dbweekly&utm_location=us) — 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. Hired.​com In brief [AWS Schema Conversion Tool Now Supports Conversions Between MySQL and PostgreSQL](https://aws.amazon.com/about-aws/whats-new/2016/04/aws-schema-conversion-tool-now-supports-conversions-between-mysql-and-postgresql/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [Securely Modernizing Employee Access Management with Graph Databases](http://www.datanami.com/2016/04/12/securely-modernize-employee-access-management-graph-databases/?utm_source=dbweekly&utm_medium=email) Datanaminews [What Does PostgreSQL 9.5 Bring to Developers](http://blog.nordeus.com/dev-ops/what-does-postgresql-9-5-bring-to-developers.htm?utm_source=dbweekly&utm_medium=email) Petar Partlovnews [The Ancient Greek Guide to Re-Negotiating with Oracle](http://www.enterprisedb.com/postgres-plus-edb-blog/craig-guarente/ancient-greek-guide-re-negotiating-oracle?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016BlogOraFix) — Learn valuable tips from the CEO of Palisade Compliance, Craig Guarente, a 16-year licensing veteran from Oracle. EnterpriseDBtutorial sponsored [Using SQL to Calculate the Popularity (on Stack Overflow) of Derby, H2, and HSQLDB](https://blog.jooq.org/2016/04/11/using-sql-to-calculate-the-popularity-on-stack-overflow-of-derby-h2-and-hsqldb/?utm_source=dbweekly&utm_medium=email) jooq.​orgtutorial [ElasticSearch Cluster Rolling Restart at the Speed of Light](https://t37.net/elasticsearch-cluster-rolling-restart-at-the-speed-of-light-with-rack-awareness.html?utm_source=dbweekly&utm_medium=email) Frederic de Villamiltutorial [How We Get High Availability with Elasticsearch and Ruby on Rails](https://18f.gsa.gov/2016/04/08/how-we-get-high-availability-with-elasticsearch-and-ruby-on-rails/?utm_source=dbweekly&utm_medium=email) 18F Digital Servicestutorial [A Developers' Guide to Azure SQL Data Warehouse](https://channel9.msdn.com/events/build/2016/p402?utm_source=dbweekly&utm_medium=email) Microsoftvideo [Urban Myths About SQL (2015) (slidedeck)](http://docslide.us/technology/urban-myths-about-sql.html?utm_source=dbweekly&utm_medium=email) Michael Stonebrakeropinion [The Unspoken Complexity of NoSQL](http://pjuu.github.io/pjuu/nosql/mongo/choices/2016/04/08/unspoken-complexity-nosql.html?utm_source=dbweekly&utm_medium=email) Pjuuopinion [Could PostgreSQL 9.5 Be Your Next JSON Database?](https://compose.io/articles/could-postgresql-9-5-be-your-next-json-database/?utm_source=dbweekly&utm_medium=email) — TL;DR: No, but that’s not the right question. Dj Walker-Morganopinion [Mongoclient: A MongoDB Management Tool](https://github.com/rsercano/mongoclient/?utm_source=dbweekly&utm_medium=email) Sercan Özdemirtools [Sqlectron: A Simple DB Client for Postgres, MySQL and SQL Server](https://sqlectron.github.io/?utm_source=dbweekly&utm_medium=email) — A simple and lightweight SQL client desktop/terminal with cross database and platform support. Sqlectrontools [PGInsight: CLI Tool to Dig Inside Your Postgres Databases](http://pginsight.io/?utm_source=dbweekly&utm_medium=email) — Easily dig deep inside your Postgresql database. Features include finding index information, disk usage, cache hits and more. Khalid Lafitools [Auto-generated APIs for any database](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=tryit) — Powerful API automation for standardization, portability, and scale. Free dev environment for testing and rapid prototyping. DreamFactorytools sponsored [Corvus: Fast and Lightweight Redis Cluster Proxy for Redis 3.0](https://github.com/eleme/corvus?utm_source=dbweekly&utm_medium=email) elemecode [gredis: A Redis Server built over grpc](https://github.com/voidabhi/gredis?utm_source=dbweekly&utm_medium=email) Abhijeet Mohancode [jseg: JavaScript Entity Graph](https://github.com/brandonbloom/jseg?utm_source=dbweekly&utm_medium=email) — A super simple, in-memory, JS graph database. Brandon Bloomcode [Data Modeling in Cassandra From A Postgres Perspective](http://neovintage.org/2016/04/07/data-modeling-in-cassandra-from-a-postgres-perspective/?utm_source=dbweekly&utm_medium=email) — 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. neovintage.​org [An SQL Joins Visualizer](http://sql-joins.leopard.in.ua/?utm_source=dbweekly&utm_medium=email) — A simple, but very clear tool to visually explain joins in SQL. Alexey Vasiliev    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/100) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK