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

Database Weekly 122   . 

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

[Database Weekly](http://dbweekly.com) Issue 122 — September 16, 2016     

Featured [MySQL 8.0.0 Milestone Release Available](http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/?utm_source=dbweekly&utm_medium=email) — A development milestone release so you can play with MySQL 8’s new features now. MySQL Server Teamnews [HTSQL: A Navigational Query Language for Relational DBs](http://htsql.org/?utm_source=dbweekly&utm_medium=email) — Designed for data analysts and ‘accidental programmers’ who have complex business inquiries to solve and need a productive tool to write and share database queries. Open source. Prometheus Researchtools [Neo4j + KeyLines: The Developer's Route out of Dependency Hell](https://neo4j.com/blog/neo4j-keylines-dependency-hell/?utm_source=dbweekly&utm_medium=email) — How to use Neo4j in conjunction with KeyLines for software dependency management using insights gleaned from graph visualization. Miro Marchitutorial [Auto-generated REST APIs from any database](https://www.dreamfactory.com/demo?utm_medium=newsletter&utm_campaign=2-3) — Version 2.3 of DreamFactory’s powerful open source API automation platform brings major enhancements to speed, caching, and versatility. Free demo. DreamFactorysponsored [![\](https://copm.s3.amazonaws.com/3a054a04.png)](https://www.dreamfactory.com/demo?utm_medium=newsletter&utm_campaign=2-3) [BlazingDB Uses GPUs to Manipulate Huge Databases in No Time](https://techcrunch.com/2016/09/12/blazingdb-uses-gpus-to-manipulate-huge-databases-in-no-time/?utm_source=dbweekly&utm_medium=email) — BlazingDB works with GPU instances on popular cloud services to let you rapidly run SQL queries over large amounts of data. Romain Dilletnews [MIT Programmers Attack Big Data Memory Gap](https://www.datanami.com/2016/09/15/mit-programmers-attack-big-data-memory-gap/?utm_source=dbweekly&utm_medium=email) — A new programming language that efficiently manages memory during big data operations. Datanaminews [Next Generation Tools for Data Science: Apache vs Google](http://www.unofficialgoogledatascience.com/2016/08/next-generation-tools-for-data-science.html?utm_source=dbweekly&utm_medium=email) — A comparison of Apache Spark and Google Cloud Dataflow in the context of being two key ‘next generation’ data processing frameworks. Unofficial Google Data Science Blogopinion [QuineDB: A Quine That Is Also A Key-Value Store](https://github.com/gfredericks/quinedb?utm_source=dbweekly&utm_medium=email) — A quine is a program that, when run, outputs its own source code. Stores data in a shell variable. Solely for fun and an interesting experiment. Gary Frederickscode Jobs [Find Your Perfect Company Match](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies. Hired.​com In brief [Some Notes on Shipping CouchDB 2.0](http://mail-archives.apache.org/mod_mbox/couchdb-dev/201609.mbox/%3C1397FA4E-020F-43B0-914B-003E7F7D8AF4%40apache.org%3E?utm_source=dbweekly&utm_medium=email) — CouchDB is “tantalisingly close to shipping 2.0”. Jan Lehnardtnews [SIEUFERD: A General Purpose UI for Relational Databases](http://people.csail.mit.edu/ebakke/sieuferd/?utm_source=dbweekly&utm_medium=email) — An academic project that’s not publicly available. Eirik Bakkenews [Unraveling Hadoop and Spark Performance Mysteries](https://www.datanami.com/2016/09/13/unraveling-hadoop-spark-performance-mysteries/?utm_source=dbweekly&utm_medium=email) Datanaminews [Calculating Proportional Values in SQL](https://www.periscopedata.com/blog/calculating-proportional-values.html?utm_source=dbweekly&utm_medium=email) — Aggregations are common and generally straightforward in SQL, but some more complex operations like medians require a bit more work as demonstrated here. Periscopetutorial [MySQL 8.0's Invisible Indexes](http://mysqlserverteam.com/mysql-8-0-invisible-indexes/?utm_source=dbweekly&utm_medium=email) — Invisible indexes are a new feature in MySQL 8.0 to hide an index from MySQL’s optimizer. Martin Hanssontutorial [An Overview of MySQL’s Information Schema](http://www.vertabelo.com/blog/technical-articles/an-overview-of-mysqls-information-schema?utm_source=dbweekly&utm_medium=email) Emil Drkušićtutorial [Recovering a Postgres Database From Disk Level Corruption](http://www.pateldenish.com/2016/09/recovering-corrupted-postgres-database.html?utm_source=dbweekly&utm_medium=email) Denish Pateltutorial [Neo4j With Scala: Migrating Data From Other Databases to Neo4j](https://blog.knoldus.com/2016/09/12/neo4j-with-scala-migrate-data-from-other-database-to-neo4j/?utm_source=dbweekly&utm_medium=email) Anurag Knoldustutorial [Fun with SQL: Computing Run Rate and Month Over Month Growth](https://www.citusdata.com/blog/2016/09/12/fun-with-sql-computing-run-rate-and-growth-with-ctes-and-window-functions/?utm_source=dbweekly&utm_medium=email) Citus Datatutorial [Command-Line Tools Can Be 235x Faster Than Your Hadoop Cluster](http://aadrake.com/command-line-tools-can-be-235x-faster-than-your-hadoop-cluster.html?utm_source=dbweekly&utm_medium=email) — A ‘golden oldie’ that’s done the rounds again this week. Adam Drakestory [Building a Recommendation Engine with Machine Learning Techniques](https://www.youtube.com/watch?v=SRnM_P_ygqI&utm_source=dbweekly&utm_medium=email) Brian Sam-Boddenvideo [Avoid Using COUNT() in SQL When You Could Use EXISTS()](https://blog.jooq.org/2016/09/14/avoid-using-count-in-sql-when-you-could-use-exists/?utm_source=dbweekly&utm_medium=email) JOOQopinion [Why You Should Build Your Own NoSQL Database](https://medium.com/@marceloboeira/why-you-should-build-your-own-nosql-database-9bbba42039f5?utm_source=dbweekly&utm_medium=email) — Covers the basic principles and creates something very simple in 33 lines of Crystal. Marcelo Boeiraopinion [5 Mistakes to Avoid When Deploying An Analytical Database](https://www.oreilly.com/ideas/5-mistakes-to-avoid-when-deploying-an-analytical-database?utm_source=dbweekly&utm_medium=email) — Leading data-driven organizations point out five common pitfalls. Alice LaPlanteopinion [Spot performance bottlenecks right away with Datadog](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — Correlate and investigate: Monitor query latency and errors alongside CPU, memory, network, and I/O metrics. Datadogtools sponsored [sQucumber-redshift: A Framework for Defining and Executing SQL Integration & Acceptance Tests on AWS Redshift](https://github.com/moertel/sQucumber-redshift?utm_source=dbweekly&utm_medium=email) Stefanie Grunwaldtools [EliasDB: A No Dependencies Graph Database Written in Go](https://github.com/krotik/eliasdb?utm_source=dbweekly&utm_medium=email) — Exposes a REST API. Matthias Ladkaucode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/122) [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