Issue 136 — January 6, 2017
Featured
SQL Server is DB-Engines' DBMS of 2016 — 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-Engine news
Dgraph v0.7.1: A Low Latency Graph Database — Bills itself as ‘the most production ready graph database’. Strong claims versus Neo4j, but the feature set is certainly interesting.
Manish Rai Jain tools
SQLite 3.16.0 Released — 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.org news
Explore your memory use over time with RedisGreen — RedisGreen's hosting and monitoring service maps your memory usage and tracks how keys in your database behave over time.
Redisgreen sponsored
RocksDB: A Persistent Key-Value Store for Flash and RAM Storage — 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.
Facebook tools
Playing with 80 Million Amazon Product Ratings Using Apache Spark — An attempt to show manipulating big data can be as easy as performing an analysis on a dataset with only a few records.
Max Woolf story
BigDL: Distributed Deep Learning Library for Apache Spark — Lets you write deep learning apps as standard Spark programs to run on Spark or Hadoop clusters.
Intel Analytics tools
Solving a Classic Puzzle using Postgres and Advanced SQL — Love puzzles and got quite a bit of time on your hands? This is a fascinating journey.
Quassnoi story
In brief
Bruce Schneier news
Five Things to Monitor After Black Friday & Cyber Monday — Baron Schwartz discusses how organizations can monitor their databases wisely after the holiday rush.
VividCortex tutorial sponsored
Buzz Moschetti tutorial
Abe Voelker tutorial
Vertabelo tutorial
How to Generate A Pivoted CROSS JOIN Where The Resulting Table Definition Is Unknown — An interesting question and set of answers that looks into using Postgres’ ‘crosstab’ function as well as other approaches.
Stack Overflow tutorial
Installing Livy on a Hadoop Cluster — Livy is an add-on to Spark that lets you communicate with your cluster in a RESTful fashion.
clairvoyantsoft.com tutorial
Datanami opinion
How can you help your team write better, shareable SQL faster? — Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL.
Red Gate video sponsored
Paul Fitzpatrick tools
Pavel Yakovlev tools
rediSQL: Redis Module Providing an SQL Database Inside Redis — Very alpha. Uses SQLite under the hood.
Simone Mosciatti tools
RedisLabs tools
github.com code