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

Database Weekly 136   . 

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

[Database Weekly](http://dbweekly.com) Issue 136 — January 6, 2017     

Featured [SQL Server is DB-Engines' DBMS of 2016](http://db-engines.com/en/blog_post/67?utm_source=dbweekly&utm_medium=email) — DB-Engines tracks the popularity of database systems and found Microsoft’s SQL Server grew most in popularity in 2016. The release of SQL Server 2016 and the Linux port likely had a major effect. DB-Enginenews [Dgraph v0.7.1: A Low Latency Graph Database](https://open.dgraph.io/post/v0.7-release/?utm_source=dbweekly&utm_medium=email) — Bills itself as ‘the most production ready graph database’. Strong claims versus Neo4j, but the feature set is certainly interesting. Manish Rai Jaintools [SQLite 3.16.0 Released](https://www.sqlite.org/releaselog/3_16_0.html?utm_source=dbweekly&utm_medium=email) — Uses 9% fewer CPU cycles, fixes a long standard LEFT JOIN bug, adds experimental support for PRAGMA functions, has faster LIKE and GLOB matching when using multiple wildcards, and more. sqlite.​orgnews [Explore your memory use over time with RedisGreen](http://www.redisgreen.net/8/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=expore+time+memory) — RedisGreen's hosting and monitoring service maps your memory usage and tracks how keys in your database behave over time. Redisgreensponsored [![\](https://copm.s3.amazonaws.com/0fc6b256.png)](http://www.redisgreen.net/8/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=expore+time+memory) [RocksDB: A Persistent Key-Value Store for Flash and RAM Storage](https://github.com/facebook/rocksdb?utm_source=dbweekly&utm_medium=email) — From Facebook comes a library forming the core of a fast memory-based key-value store. It has a Log-Structured-Merge-Database (LSM) design with flexible tradeoffs and multi-threaded compactions. Facebooktools [Playing with 80 Million Amazon Product Ratings Using Apache Spark](http://minimaxir.com/2017/01/amazon-spark/?utm_source=dbweekly&utm_medium=email) — An attempt to show manipulating big data can be as easy as performing an analysis on a dataset with only a few records. Max Woolfstory [BigDL: Distributed Deep Learning Library for Apache Spark](https://github.com/intel-analytics/BigDL?utm_source=dbweekly&utm_medium=email) — Lets you write deep learning apps as standard Spark programs to run on Spark or Hadoop clusters. Intel Analyticstools [Solving a Classic Puzzle using Postgres and Advanced SQL](https://explainextended.com/2016/12/31/happy-new-year-8/?utm_source=dbweekly&utm_medium=email) — Love puzzles and got quite a bit of time on your hands? This is a fascinating journey. Quassnoistory In brief [An SQL Injection Attack is a Legal Company Name in the UK](https://www.schneier.com/blog/archives/2017/01/an_sql_injectio.html?utm_source=dbweekly&utm_medium=email) Bruce Schneiernews [Five Things to Monitor After Black Friday & Cyber Monday](https://www.vividcortex.com/resources/five-things-to-monitor-after-black-friday-and-cyber-monday?utm_campaign=DB%20Weekly&utm_source=ppc) — Baron Schwartz discusses how organizations can monitor their databases wisely after the holiday rush. VividCortextutorial sponsored [MongoDB 3.4 and Money: Hello BigDecimal Type](http://www.moschetti.org/rants/mongomoney.html?utm_source=dbweekly&utm_medium=email) Buzz Moschettitutorial [Generating YouTube-Like IDs in Postgres Using PL/V8 and Hashids](https://blog.abevoelker.com/2017-01-03/generating-youtube-like-ids-in-postgres-using-plv8-and-hashids/?utm_source=dbweekly&utm_medium=email) Abe Voelkertutorial [A Database Model for Gallery or Museum Management](http://www.vertabelo.com/blog/technical-articles/a-database-model-for-gallery-or-museum-management?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()](https://blog.jooq.org/2014/08/12/the-difference-between-row_number-rank-and-dense_rank/?utm_source=dbweekly&utm_medium=email) jOOQtutorial [How to Generate A Pivoted CROSS JOIN Where The Resulting Table Definition Is Unknown](http://dba.stackexchange.com/questions/159280/how-do-i-generate-a-pivoted-cross-join-where-the-resulting-table-definition-is-u/159339?utm_source=dbweekly&utm_medium=email) — An interesting question and set of answers that looks into using Postgres’ ‘crosstab’ function as well as other approaches. Stack Overflowtutorial [Installing Livy on a Hadoop Cluster](http://site.clairvoyantsoft.com/installing-livy-on-a-hadoop-cluster/?utm_source=dbweekly&utm_medium=email) — Livy is an add-on to Spark that lets you communicate with your cluster in a RESTful fashion. clairvoyantsoft.​comtutorial [What 2017 Will Bring: 10 More Big Data Predictions](https://www.datanami.com/2017/01/04/2017-more-big-data-predictions/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [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-25322) — Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL. Red Gatevideo sponsored [Is There A Perf Difference Between Equal (=) and IN with 1 Value?](http://stackoverflow.com/q/37828398/3951?utm_source=dbweekly&utm_medium=email) Stack Overflow [catsql: 'cat' for SQL Databases](https://github.com/paulfitz/catsql?utm_source=dbweekly&utm_medium=email) Paul Fitzpatricktools [Hasbolt: The New Haskell Neo4j Bolt Driver](https://neo4j.com/blog/hasbolt-haskell-neo4j-bolt-driver/?utm_source=dbweekly&utm_medium=email) Pavel Yakovlevtools [rediSQL: Redis Module Providing an SQL Database Inside Redis](https://github.com/RedBeardLab/rediSQL?utm_source=dbweekly&utm_medium=email) — Very alpha. Uses SQLite under the hood. Simone Mosciattitools [RediSearch: Full-Text Search Extension for Redis](http://redisearch.io/?utm_source=dbweekly&utm_medium=email) RedisLabstools [Presto: Distributed SQL Query Engine for Interactive Big Data](https://prestodb.io/?utm_source=dbweekly&utm_medium=email) Facebooktools [aredis: An Efficient Async Redis Client for Python](https://github.com/NoneGG/aredis?utm_source=dbweekly&utm_medium=email) github.​comcode [Tile38: Geolocation Data Store, Spatial Index, and Realtime Geofence](https://github.com/tidwall/tile38?utm_source=dbweekly&utm_medium=email) Josh Bakercode    

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