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

Database Weekly 87   . 

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

[Database Weekly](http://dbweekly.com) Issue 87 — January 15, 2016     

Featured [Designing Schemaless, Uber Engineering’s Scalable Datastore](https://eng.uber.com/schemaless-part-one/?utm_source=dbweekly&utm_medium=email) — Uber has developed its own MySQL-based schemaless storage system. This article explains why and how it came together. Uber Engineering [Writing More Legible SQL](http://www.craigkerstiens.com/2016/01/08/writing-better-sql/?utm_source=dbweekly&utm_medium=email) — Writing SQL is one thing, but when it comes to reading other’s SQL, things can get tricky. These few tips will help to make your SQL much more understandable by others. Craig Kerstiens [Real-time Postgres monitoring](http://dtdg.co/1PkYlNZ) — Visualize Postgres system resources, connections, locks, transactions, and indexes, and instantly correlate with metrics from anywhere in your stack. Datadogsponsored [![\](https://copm.s3.amazonaws.com/505d3b9c.png)](http://dtdg.co/1PkYlNZ) [Using CTEs and Unions to Compute Running Totals](https://www.periscopedata.com/blog/using-ctes-and-unions-to-compute-running-totals.html?utm_source=dbweekly&utm_medium=email) — A look at combining CTEs with unions to give not just grouped results, but also side by side aggregates. periscopedata.​com [How Developers Use Databases Today: A JetBrains Report](https://www.jetbrains.com/datagrip/how-developers-use-databases-today/?utm_source=dbweekly&utm_medium=email) — Insights based on responses from 2000 developers. One factoid: Postgres is the database most would like to migrate to, while MySQL is the one they most want to leave behind. JetBrainsnews [Elasticsearch Replaces Solr As The Most Popular Search Engine](http://db-engines.com/en/blog_post/55?utm_source=dbweekly&utm_medium=email) — While they’re commonly used for their search functionality only, Solr and Elasticsearch are also document database engines of sorts. Elasticsearch has now pulled ahead of Solr in DB Engines’ rankings. DB Enginesnews [Querying Amazon Kinesis Streams Directly with SQL and Spark Streaming](http://blogs.aws.amazon.com/bigdata/post/Tx3916WCIUPVA3T/Querying-Amazon-Kinesis-Streams-Directly-with-SQL-and-Spark-Streaming?utm_source=dbweekly&utm_medium=email) — What if you could use your SQL knowledge to discover patterns directly from an incoming stream of data? Streaming analytics is a very popular topic of conversation around big data use cases. Amazontutorial [PipelineDB Releases First Enterprise Version Of Its Streaming SQL Database](http://techcrunch.com/2016/01/14/pipelinedb-releases-first-enterprise-version-of-its-streaming-sql-database/?utm_source=dbweekly&utm_medium=email) — PipelineDB is built on a new way of looking at SQL databases, thinking about streams of data rather than data at rest in big silos. TechCrunchnews [Hadoop's 10th Birthday](http://www.cloudera.com/content/www/en-us/promos/hadoop10.html?utm_source=dbweekly&utm_medium=email) — A look back at how Hadoop has gone from an unknown to the king of distributed data set processing systems. Cloudera [Creating a Data Model For Carpooling](http://www.vertabelo.com/blog/technical-articles/creating-a-data-model-for-carpooling?utm_source=dbweekly&utm_medium=email) — It’s always good to see how a database designer approaches modelling a situation. In this case, it’s a ride-sharing app. Shantanu Kher In brief [Does your company need Big Data? LambdaNow can help!](http://www.lambdanow.com/welcome?utm_source=dbweekly&utm_medium=email) — LambdaNow solves the complexity of Big Data by providing easy Big Data processing pipelines. Try it for FREE Now. LambdaNowtools sponsored [SQLite 3.10.1 Released](https://www.sqlite.org/releaselog/3_10_1.html?utm_source=dbweekly&utm_medium=email) — ‘Fixed a 16-month-old bug in the query planner that could generate incorrect results’ SQLitenews [Picking the Right SQL-on-Hadoop Tool for the Job](http://www.datanami.com/2016/01/13/picking-the-right-sql-on-hadoop-tool-for-the-job/?utm_source=dbweekly&utm_medium=email) Datanaminews [Preview The Newest ODBC SQL Server Driver for Windows and Linux](http://blogs.technet.com/b/dataplatforminsider/archive/2016/01/11/preview-the-newest-odbc-sql-server-driver-for-windows-and-linux.aspx?utm_source=dbweekly&utm_medium=email) SQL Server Team Blognews tools [Survey: Big Data Goes Mainstream](http://www.datanami.com/2016/01/11/survey-big-data-goes-mainstream/?utm_source=dbweekly&utm_medium=email) — “Financial services firms remain the biggest users of big data technologies” Datanaminews [JSON Support in SQL Server 2016](http://codingsight.com/json-support-in-sql-server-2016/?utm_source=dbweekly&utm_medium=email) CodingSightnews [Top 6 Database Performance Metrics to Monitor in Enterprise Applications](https://blog.appdynamics.com/database/top-6-database-performance-metrics-to-monitor-in-enterprise-applications/?utm_source=dbweekly&utm_medium=email) Omed Habibtutorial [What's New in Cassandra 3.0 - Part 1](https://www.smartcat.io/blog/whats-new-in-cassandra-30-part-1/?utm_source=dbweekly&utm_medium=email) SmartCattutorial [Using the Ltree Datatype in Postgres](http://leapfrogonline.io/articles/2015-05-21-postgres-ltree/?utm_source=dbweekly&utm_medium=email) Leapfrog Onlinetutorial [Natural Language Processing with Spark on Reddit Comments](http://dbunker.github.io/2016/01/04/spark-and-nlp-on-reddit/?utm_source=dbweekly&utm_medium=email) Data Reflexionstutorial [Graph Databases for Beginners: ACID vs. BASE Explained](http://neo4j.com/blog/acid-vs-base-consistency-models-explained/?utm_source=dbweekly&utm_medium=email) Neo4jtutorial [As Data Science Evolves, It's Taking Statistics with It](http://www.datanami.com/2016/01/14/as-data-science-evolves-its-taking-statistics-with-it/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [PostgreSQL 9.6 Wish List](http://blog.databasepatterns.com/2016/01/postgresql-96-wish-list.html?utm_source=dbweekly&utm_medium=email) Neil McGuiganopinion [Medis: An Open Sourced Redis GUI Tool for OS X](https://github.com/luin/medis?utm_source=dbweekly&utm_medium=email) — Lets you view and edit keys, supports SSH tunnelling, config viewing/editing. It’s built using Node, Electron and React. Zihua Litools [MarsDB: A Promise Based Lightweight Database with MongoDB Query Syntax, Written On ES6](https://github.com/c58/marsdb?utm_source=dbweekly&utm_medium=email) Artem Artemyevcode    

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