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

Database Weekly 120   . 

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

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

Featured [MyRocks: A Space- and Write-Optimized MySQL Storage Engine](https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database?utm_source=dbweekly&utm_medium=email) — Facebook’s Yoshinori Matsunobu looks at how deploying MyRocks (a key/value store forked from Google’s LevelDB) within a MySQL installation enabled a 50% reduction in storage requirements. Facebook Codestory [A Comparison of 10 Open Source Time Series Databases](https://blog.dataloop.io/top10-open-source-time-series-databases?utm_source=dbweekly&utm_medium=email) — The author looks at and ranks DalmatinerDB, InfluxDB, Prometheus, Riak TS, OpenTSDB, KairosDB, Elasticsearch, Druid, Blueflood and Graphite. Steven Acreman [Tracking The Ever-Shifting Big Data Bottleneck](https://www.datanami.com/2016/08/31/tracking-ever-shifting-big-data-bottleneck/?utm_source=dbweekly&utm_medium=email) — _“Bottlenecks are a fact of life in IT. No matter how fast you build something, somebody will find a way to max it out.”_ And it seems newer in-memory frameworks may make CPU shared caches the next bottleneck for big data systems. Alex Woodie [Forget Technical Debt - Build Technical Wealth](http://firstround.com/review/forget-technical-debt-heres-how-to-build-technical-wealth/) — First Round Review recently sat down with Andrea Goulet, CEO of Corgibytes, to discuss how "software remodeling"can help you pay down tech debt and tackle even the most difficult legacy codebases. Corgibytessponsored [![\](https://copm.s3.amazonaws.com/2d256964.png)](http://firstround.com/review/forget-technical-debt-heres-how-to-build-technical-wealth/) [Build a Raspberry Pi Hadoop Cluster to Run Spark on YARN](https://dqydj.com/raspberry-pi-hadoop-cluster-apache-spark-yarn/?utm_source=dbweekly&utm_medium=email) — The Raspberry Pi isn’t the most natural platform for Hadoop or Spark work but it can provide a fun way to learn and this is a thorough walkthrough. DQYDJtutorial [Building A Recommendation Engine with AWS Data Pipeline, Elastic MapReduce and Spark](https://medium.com/@HubbaDev/building-a-recommendation-engine-with-aws-data-pipeline-elastic-mapreduce-and-spark-ad886b0a1434?utm_source=dbweekly&utm_medium=email) — From Google’s advertisements to Amazon’s product suggestions, recommendation engines are everywhere. Hubbatutorial [Apache Spark at Scale: A 60 TB+ Production Use Case](https://code.facebook.com/posts/1671373793181703/apache-spark-scale-a-60-tb-production-use-case/?utm_source=dbweekly&utm_medium=email) — Facebook is a heavy user of analytics for data-driven decision making and this post looks at how they use Spark for doing real-time entity ranking at scale. Facebook Codestory Jobs [Get 5+ Engineering Job Offers in 1 Week](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square Hired.​com In brief [Over 18,000 Redis Instances Targeted by Fake Ransomware](https://duo.com/blog/over-18-000-redis-instances-targeted-by-fake-ransomware?utm_source=dbweekly&utm_medium=email) Duo Labsnews [JSON Support Now Generally Available in Azure SQL Database](https://azure.microsoft.com/en-us/blog/json-support-is-generally-available-in-azure-sql-database/?utm_source=dbweekly&utm_medium=email) Microsoftnews [Azure SQL Data Warehouse General Availability Expanding to 18 Regions Worldwide](https://azure.microsoft.com/en-us/blog/azure-sql-data-warehouse-general-availability-expanding-to-18-regions-worldwide/?utm_source=dbweekly&utm_medium=email) Prem Prakashnews [MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27 Now Available](https://mariadb.org/mariadb-10-1-17-mariadb-galera-cluster-10-0-27-now-available/?utm_source=dbweekly&utm_medium=email) Daniel Bartholomewnews [Installing DreamFactory from source on Ubuntu 14.0.4 LTS](http://blog.dreamfactory.com/installing-dreamfactory-from-source-on-ubuntu-14.0.4-lts?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=ubuntu) — DreamFactory auto-generates a rich API platform from any database. Here’s a quick tutorial for a common Linux flavor. DreamFactorysponsored tutorial [When To Avoid JSONB In A PostgreSQL Schema](http://blog.heapanalytics.com/when-to-avoid-jsonb-in-a-postgresql-schema/?utm_source=dbweekly&utm_medium=email) Dan Robinsontutorial [A (Managing) Elasticsearch Cheat Sheet](https://thoughts.t37.net/an-elasticsearch-cheat-sheet-9b92c9211d7b?utm_source=dbweekly&utm_medium=email) Fred de Villamiltutorial [Valuing User Subscriptions Over Time with SQL](https://periscopedata.com/blog//calculating-active-subscriptions-over-time.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [A Practical Guide to PostgreSQL Optimizations](https://tech.lendinghome.com/practical-guide-to-postgresql-optimizations-d7b9c2ad6a22?utm_source=dbweekly&utm_medium=email#.db0qvlg0x) Omar Bohsalitutorial [How A Japanese Cucumber Farmer Is Using Deep Learning and TensorFlow](https://cloud.google.com/blog/big-data/2016/08/how-a-japanese-cucumber-farmer-is-using-deep-learning-and-tensorflow?utm_source=dbweekly&utm_medium=email) — Uses of machine learning and deep learning are only limited by our imaginations: A farmer can use deep learning to sort cucumbers. See how. Google Developersstory [How Mail.Ru Uses Tarantool to Help Scale Its Anti-Spam Service](http://highscalability.com/blog/2016/8/30/the-cat-and-mouse-story-of-implementing-anti-spam-for-mailru.html?utm_source=dbweekly&utm_medium=email) — Tarantool is a NoSQL database running in a Lua application server. High Scalabilitystory [How Big Data Can Optimize Global Shipping](https://www.datanami.com/2016/08/31/big-data-can-optimize-global-shipping/?utm_source=dbweekly&utm_medium=email) Datanamistory [Using JSON in SQL Server 2016 and Azure SQL Database](https://channel9.msdn.com/Shows/Data-Exposed/Using-JSON-in-SQL-Server-2016-and-Azure-SQL-Database?WT.mc_id=dlvr_twitter_ch9&utm_source=dbweekly&utm_medium=email) Channel 9video [Your Relational Database Management System Is Underutilized](https://spin.atomicobject.com/2016/08/31/relational-database-management-system/?utm_source=dbweekly&utm_medium=email) — If you’re just storing data, you’re missing out says the author. Jason Porrittopinion [Spark Comparison: AWS vs. Google Cloud Platform](https://www.oreilly.com/ideas/spark-comparison-aws-vs-gcp?utm_source=dbweekly&utm_medium=email) — Assessing cost, performance, and run time of a typical Spark workload. Michael Li and Ariel M'ndange-Pfupfuopinion [Email API from SendGrid](http://www.launchbit.com/taz/11185-6510-111) — Reliably deliver your emails with a quick and simple API or SMTP integration. Try for Free SendGridsponsored tools    

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