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

Database Weekly 124   . 

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

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

Featured [How Uber Manages 1M Writes/Second Using Mesos and Cassandra](http://highscalability.com/blog/2016/9/28/how-uber-manages-a-million-writes-per-second-using-mesos-and.html?utm_source=dbweekly&utm_medium=email) — Uber needs to store location data sent out every 30 seconds by both driver and rider apps and it’s built a custom solution on top of Cassandra and Mesos to cope. High Scalabilitystory [GraphQL: Designing a Data Language](https://www.youtube.com/watch?v=Oh5oC98ztvI&utm_source=dbweekly&utm_medium=email) — GraphQL is a static-strong-typed data query language and runtime designed and used at Facebook. This talk introduces it, its impact on architecture at Facebook, and how it was developed. _39 minutes._ Lee Byronvideo [Embracing the Red Bar: Safely Refactoring Tests](http://corgibytes.com/blog/2016/09/20/refactoring-against-the-red-bar/) — Do you ever refactor your test code? Corgibytes’ M. Scott Ford explores a technique for protecting against the possibility of turning a perfectly valid test into one that always passes, regardless of whether or not the code that it covers is correct. Corgibytessponsored [![\](https://copm.s3.amazonaws.com/7d824c4c.png)](http://corgibytes.com/blog/2016/09/20/refactoring-against-the-red-bar/) [Sleepless Nights with MongoDB WiredTiger and Our Return to MMAPv1](https://blog.clevertap.com/sleepless-nights-with-mongodb-wiredtiger-and-our-return-to-mmapv1/?utm_source=dbweekly&utm_medium=email) — A tale of how a behavioral analytics platform upgraded to Mongo’s WiredTiger storage engine but had a bad experience. Francis Pereirastory [Using R to Detect Fraud At 1 Million Transactions Per Second](http://blog.revolutionanalytics.com/2016/09/fraud-detection.html?utm_source=dbweekly&utm_medium=email) — In Joseph Sirosh’s keynote at the Data Science Summit, Wee Hyong Took demonstrated using R in SQL Server 2016 to detect fraud in real-time credit card transactions at a rate of 1 million transactions per second. Revolution Analyticsstory [PostgreSQL 9.6 Released](https://www.postgresql.org/about/news/1703/?utm_source=dbweekly&utm_medium=email) — The next key release of Postgres. Key features include parallel queries, faster autovacuum, phrase searching in full-text search, and many performance improvements. [Release notes here.](https://www.postgresql.org/docs/current/static/release-9-6.html) PostgreSQLnews [The Major Features in Postgres 9.6 [PDF\]](http://momjian.us/main/writings/pgsql/features.pdf?utm_source=dbweekly&utm_medium=email) — Straightforward, simple slides with the basics on 9.6’s new features. Bruce Momjian [Data Engineers in Hot Demand](https://www.datanami.com/2016/09/27/data-engineers-hot-demand/?utm_source=dbweekly&utm_medium=email) — Once it was all about ‘data scientists’ but now ‘data engineers’, engineers who excel at working with and storing data at a large scale, are in heavy demand. Datanaminews Jobs [Stop wasting time - know what you'll earn before the interview](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week Hired.​com In brief [Blockchain Database Startup BigchainDB Raises €3 Million](http://www.coindesk.com/bigchaindb-3-million-series-a-blockchain/?utm_source=dbweekly&utm_medium=email) — The company aims to turn traditional databases into blockchains. CoinDesknews [MapR Embraces Microservices in Big Data Platform](https://www.datanami.com/2016/09/28/mapr-embraces-microservices-big-data-platform/?utm_source=dbweekly&utm_medium=email) Datanaminews [Survey: Spark Going 'Mainstream'](https://www.datanami.com/2016/09/27/survey-spark-going-mainstream/?utm_source=dbweekly&utm_medium=email) Datanaminews [Previewing Autopilot: A New Elasticsearch Cloud Orchestration Tool](https://medium.appbase.io/previewing-autopilot-7933163abbfc?utm_source=dbweekly&utm_medium=email) Siddharth Kotharinews [Introducing the DreamFactory Cassandra Service](http://blog.dreamfactory.com/introducing-the-dreamfactory-cassandra-service?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=2-3) — Easily connect to a Cassandra db with the same RESTful API already in use with other NoSQL databases in DreamFactory. DreamFactorynews sponsored [Global Historical Daily Weather Data Now Available in BigQuery](https://cloudplatform.googleblog.com/2016/09/global-historical-daily-weather-data-now-available-in-BigQuery.html?utm_source=dbweekly&utm_medium=email) — Weather data from over 80,000 stations in 180 countries, spans several decades and has been quality-checked. Google Cloud Platformnews [Apache Cassandra 2.2.8 Released](https://lists.apache.org/thread.html/bcd56450a76be22e244a6b31b70121b55e98e4d89464c4b1b3351ea7@%3Cuser.cassandra.apache.org%3E?utm_source=dbweekly&utm_medium=email) — This version is a bug fix release of the 2.2 series. You can [grab it here](http://cassandra.apache.org/). Michael Shulernews [Using the Neo4j Graph Database with a .NET Client](http://thenewstack.io/graph-database-neo4j-net-client/?utm_source=dbweekly&utm_medium=email) The New Stacktutorial [A Data Model for Listing Apartments and Other Rental Units](http://www.vertabelo.com/blog/technical-articles/a-data-model-for-listing-apartments-and-other-rental-units?utm_source=dbweekly&utm_medium=email) Vertabelotutorial ['Google' Your Own Brain: Create a CMS with Neo4j and Elasticsearch](https://neo4j.com/blog/google-brain-cms-neo4j-elasticsearch/?utm_source=dbweekly&utm_medium=email) John David Martintutorial [Why Your Next Project Deserves an Open Source Multi Model Database](https://www.youtube.com/watch?v=CcYgivf9i6I&utm_source=dbweekly&utm_medium=email) YouTubevideo [Zero to Hero Data Pipeline - From MongoDB to Cassandra](https://www.youtube.com/watch?v=ta9WyFvCe1c&utm_source=dbweekly&utm_medium=email) — Migrating a data pipeline to Apache Cassandra in a short period without having any prior knowledge and doing all of the computation with Apache Spark. _Just over and hour long._ Demi Ben Arivideo [Elixir ETS Versus Redis](https://blog.codeship.com/elixir-ets-vs-redis/?utm_source=dbweekly&utm_medium=email) — Redis is becoming an assumed part of many web stacks, in the same breath as your database. But with Elixir, do you need it? Do you even need a database? Barry Jonesopinion [When to Choose SQL and When to Choose NoSQL](https://blog.jooq.org/2016/09/28/when-to-choose-sql-and-when-to-choose-nosql/?utm_source=dbweekly&utm_medium=email) — When should NoSQL storage systems be evaluated as an alternative to RDBMS? JOOQopinion [MariaDB CTO: NoSQL Database Bubble to Burst Soon](https://data-economy.com/mariadb-cto-nosql-database-bubble-burst-soon/?utm_source=dbweekly&utm_medium=email) — _“Defining climate for NoSQL companies is not that good, it continues to be bad, and it tends to go uglier.”_ Data Economyopinion [4 'Noob' MySQL Mistakes Every Programmer Makes](https://devops.com/2016/08/11/4-n00b-mysql-mistakes-every-programmer-makes/?utm_source=dbweekly&utm_medium=email) Brian Wheeleropinion [Code, Manage, Collaborate](http://www.launchbit.com/taz/11159-6613-111) — Start a free trial of Bitbucket Server and get this amazing t-shirt :) Bitbuckettools sponsored [mTools: A Must-Have Toolkit for MongoDB](http://blog.eleven-labs.com/en/mtools-mongodb/?utm_source=dbweekly&utm_medium=email) — Six tools in one, including a log reader, log filter, and random data generator. Rémy Jardinettools [Introducing neo4j-etl, The Newest RDBMS-to-Neo4j ETL Tool](https://neo4j.com/blog/rdbms-neo4j-etl-tool/?utm_source=dbweekly&utm_medium=email) Neo4jtools [Barman 2.0 Released: A Backup Manager for Postgres](http://blog.2ndquadrant.com/the-best-barman-ever/?utm_source=dbweekly&utm_medium=email) Gabriele Bartolinitools [sparklyr: An R interface for Apache Spark](https://blog.rstudio.org/2016/09/27/sparklyr-r-interface-for-apache-spark/?utm_source=dbweekly&utm_medium=email) RStudiocode [UpscaleDB-MySQL: A MySQL Storage Engine Based on UpscaleDB](https://upscaledb.com/blog/0014-beta-release-of-mysql-0.0.1.html?utm_source=dbweekly&utm_medium=email) — UpscaleDB is an embedded key/value database with fast analytical functions. Christoph Ruppcode    

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