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

Database Weekly 121   . 

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

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

Featured [InfluxDB 1.0 GA Released: A Retrospective and What’s Next](https://www.influxdata.com/influxdb-1-0-ga-released-a-retrospective-and-whats-next/?utm_source=dbweekly&utm_medium=email) — InfluxDB is an open source time series database with no external dependencies that’s useful for recording metrics, events, and performing analytics. Paul Dixnews [Dumb Tricks to Save Database Space](https://kev.inburke.com/kevin/dumb-tricks-to-save-database-space/?utm_source=dbweekly&utm_medium=email) — Don’t store UUIDs as text, use smaller number types, use enums, avoid overusing JSON, and more. Kevin Burketutorial [Apache Hadoop 3.0 Alpha 1 Released](http://hadoop.apache.org/docs/r3.0.0-alpha1/index.html?utm_source=dbweekly&utm_medium=email) — The first in a series of planned alphas and betas. This isn’t ready for production use. Apache Foundationnews [Join us at DataLayer](https://datalayer.com/?utm_source=cooper&utm_medium=newsletter&utm_campaign=datalayer) — Hear speakers from GitHub, Artsy, ZenDesk and many others as they discuss how their teams are optimizing the data layer to scale modern web and mobile apps. Reserve your seat now for this one day event on Sept. 28 in Seattle. Compose | DataLayersponsored [![\](https://copm.s3.amazonaws.com/916e4d49.png)](https://datalayer.com/?utm_source=cooper&utm_medium=newsletter&utm_campaign=datalayer) [ScyllaDB Revamps NoSQL Database in 1.3 Release](http://siliconangle.com/blog/2016/09/07/scylladb-revamps-nosql-database-in-1-3-release/?utm_source=dbweekly&utm_medium=email) — The drop-in replacement for Apache Cassandra boasts sub 1 millisecond 99% latency, 10x throughput of Cassandra, self-tuning, and more. Mike Wheatleynews [Code Generation: The Inner Sanctum of Database Performance](http://highscalability.com/blog/2016/9/7/code-generation-the-inner-sanctum-of-database-performance.html?utm_source=dbweekly&utm_medium=email) — Drew Paroski, architect and engineering manager at MemSQL, reflects on how human readable SQL queries are compiled to native code and what benefits this brings. High Scalabilitystory [Yahoo Open-Sourcing Pulsar, Pub-Sub Messaging at Scale](https://yahooeng.tumblr.com/post/150078336821/open-sourcing-pulsar-pub-sub-messaging-at-scale?utm_source=dbweekly&utm_medium=email) — Pulsar is a highly scalable, low latency pub-sub messaging system running on commodity hardware. It seems to fill a similar niche to Apache Kafka. Yahoo Engineeringnews [Elasticsearch, The Server](https://www.elastic.co/blog/elasticsearch-the-server?utm_source=dbweekly&utm_medium=email) — Reflections how Elasticsearch has evolved into a powerful search and analytics engine and how embedded Elasticsearch will no longer be supported. Clinton Gormleystory 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 [Improved Automatic Tuning Boosts Azure SQL Database Performance](https://azure.microsoft.com/en-us/blog/improved-automated-tuning-sql-database-advisor/?utm_source=dbweekly&utm_medium=email) — Azure SQL will ‘learn and adapt’ to fit applications and self-optimize its settings for better performance. Vladimir Ivanovicnews [MapR Appoints New CEO, Preps for 'Hypergrowth'](https://www.datanami.com/2016/09/08/mapr-appoints-new-ceo-preps-hypergrowth/?utm_source=dbweekly&utm_medium=email) Datanaminews [PostgreSQL 9.6 RC 1 Released](https://www.postgresql.org/about/news/1693/?utm_source=dbweekly&utm_medium=email) — The first release candidate of Postgres 9.6 is here, which means we’re not far away from the full release. Help the community out by giving it a try. postgresql.​orgnews [DreamFactory 2.3 released, includes PHP 7, Cassandra, Redis](http://blog.dreamfactory.com/dreamfactory-2.3-release?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=2-3) — This release includes major enhancements, including PHP 7, new APIs for Cassandra, Redis, and Memcached, and queued event scripts. DreamFactorysponsored [A Beginner's Guide to Hadoop Storage Formats (or File Formats)](http://blog.matthewrathbone.com/2016/09/01/a-beginners-guide-to-hadoop-storage-formats.html?utm_source=dbweekly&utm_medium=email) Matthew Rathbonetutorial [A Simple Sentiment Analysis Prototype Using Elasticsearch](https://qbox.io/blog/sentiment-analysis-prototype-using-elasticsearch?utm_source=dbweekly&utm_medium=email) Neil Alextutorial [Fun With SQL Constraints](http://www.anserinae.net/fun-with-sql-constraints.html?utm_source=dbweekly&utm_medium=email) Kamil Choudhurytutorial [Calculating Proportional Values in SQL](https://www.periscopedata.com/blog/calculating-proportional-values.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Database Design: Relation Predicates and 'Identical Relations'](http://www.dbdebunk.com/2016/09/database-design-relation-predicates-and.html?utm_source=dbweekly&utm_medium=email) Fabian Pascaltutorial [Querying Non-Existent MongoDB Fields](http://www.east5th.co/blog/2016/09/05/querying-non-existent-mongodb-fields/?utm_source=dbweekly&utm_medium=email) — A look at a subtle potential vulnerability. Pete Coreystory [FaRM: A Design for 'Fast Remote Memory'](http://blog.carlosgaldino.com/farm-fast-remote-memory.html?utm_source=dbweekly&utm_medium=email) — A high level overview of a paper describing an in-memory distributed computing platform. Carlos Galdinostory [NoSQL Is Ideal Database for Mobile Apps, Says Couchbase's Chief Mobile Architect](http://www.techrepublic.com/article/nosql-is-ideal-database-for-mobile-apps-says-couchbases-chief-mobile-architect/?utm_source=dbweekly&utm_medium=email) Wayne Carteropinion [Open Source Time-Series Database Benchmarks](https://blog.dataloop.io/time-series-database-benchmarks?utm_source=dbweekly&utm_medium=email) Steven Acremanopinion [How can you help your team write better, shareable SQL faster?](http://www.red-gate.com/products/sql-development/sql-prompt/resources/?utm_source=dbweekly&utm_medium=displayemail&utm_content=stop_bad_sql_1&utm_campaign=sqlprompt&utm_term=email-24975) — Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL. Red Gatetools sponsored [Apache Arrow: Columnar In-Memory Analytics](https://arrow.apache.org/?utm_source=dbweekly&utm_medium=email) Apache Foundationtools [pg_cron: Run Periodic Jobs in PostgreSQL](https://github.com/citusdata/pg_cron?utm_source=dbweekly&utm_medium=email) Citus Datacode    

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