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

Database Weekly 86   . 

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

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

Featured [5 Reasons You Should Use SQLite in 2016](http://charlesleifer.com/blog/five-reasons-you-should-use-sqlite-in-2016/?utm_source=dbweekly&utm_medium=email) — SQLite, a self-contained, zero-config SQL database engine, is frequently underestimated. But it’s fast, convenient, and there are compelling reasons to use it in certain contexts. Charles Leifer [Using Redis as a Time Series Database: Why and How](http://www.infoq.com/articles/redis-time-series?utm_source=dbweekly&utm_medium=email) — As a data structure data store, Redis is incredibly flexible. This article looks at one way to use it as a time series database. InfoQ [Is PostgreSQL Your Next JSON Database?](https://www.compose.io/articles/is-postgresql-your-next-json-database/?utm_source=dbweekly&utm_medium=email) — For those that haven’t been paying attention to JSON support in Postgres, this post will catch you up on its history and functionality. compose.​io [Breaking News: New PostgreSQL 9.5 Performs 96% Faster Than v9.4](http://www.enterprisedb.com/news-events/press-releases/enterprisedb-announces-improved-database-integration-scalability-and-data?utm_source=cooperpress&utm_medium=nl&utm_campaign=Jan2016PostgreSQL95) — Be among the first to download the newly announced PostgreSQL 9.5, which is focused on performance and scalability, productivity with data analytics, and improved integration with other database solutions, laying the groundwork for supporting horizontal scaling across multiple servers. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/481b081c.png)](http://www.enterprisedb.com/news-events/press-releases/enterprisedb-announces-improved-database-integration-scalability-and-data?utm_source=cooperpress&utm_medium=nl&utm_campaign=Jan2016PostgreSQL95) [DTBS: Database Design and Visualization](http://dtbs.herokuapp.com/?utm_source=dbweekly&utm_medium=email) — A visual, browser-based database design tool that lets you build both SQL and MongoDB schemas. MIRTHFUL CHUKSHAtools [PostgreSQL 9.5 Released](http://www.postgresql.org/about/news/1636/?utm_source=dbweekly&utm_medium=email) — Postgres 9.5’s headline features include UPSERT, row level security, and extra ‘big data’ features like BRIN indexing, improved foreign data wrappers, and TABLESAMPLE, an SQL clause for statistical sampling of large tables. PostgreSQLnews [MongoDB Co-Creator Explains Why ‘NoSQL’ Came to Be](https://medium.com/s-c-a-l-e/mongodb-co-creator-explains-why-nosql-came-to-be-and-why-open-source-mastery-is-an-elusive-goal-3a138480b9cd?utm_source=dbweekly&utm_medium=email) — An interview with Eliot Horowitz on the background to MongoDB, NoSQL in general, and the role of open source in innovation. Derrick Harris [One Reason Why People Fail in Oracle DBA Interviews](http://www.techopsskills.com/2015/12/25/138/?utm_source=dbweekly&utm_medium=email) — “My intention is to explain to you the core architecture of Oracle in simple words in a way even high school students could understand it.” Bharathram Manoharan Jobs [Join our team of brainiacs and be a part of the database monitoring revolution](https://www.vividcortex.com/about-us/careers/?utm_source=paid&utm_medium=dbw) Vivid Cortex In brief [Announcing Spark 1.6](https://databricks.com/blog/2016/01/04/announcing-spark-1-6.html?utm_source=dbweekly&utm_medium=email) — Apache Spark is a fast and general processing engine compatible with Hadoop data. Databricks Blognews [New Databases Help Astronomers Probe the Universe](http://www.datanami.com/2016/01/07/new-databases-help-astronomers-probe-the-universe/?utm_source=dbweekly&utm_medium=email) Datanaminews [MySQL for Visual Studio 1.2.6 Released](http://insidemysql.com/mysql-for-visual-studio-1-2-6-has-been-released/?utm_source=dbweekly&utm_medium=email) Inside MySQLnews [MySQL for Excel 1.3.6 Released](http://insidemysql.com/mysql-for-excel-1-3-6-has-been-released/?utm_source=dbweekly&utm_medium=email) Inside MySQLnews [Introducing A Simplified Configuration Experience for SQL Server in Azure Virtual Machines](https://azure.microsoft.com/en-us/blog/new-configuration-experience-sql-server-virtual-machines/?utm_source=dbweekly&utm_medium=email) Microsoft Azure Blognews [BBC's iPlayer Sees Performance Uplift After Relaunching on NoSQL Database](http://www.computerworlduk.com/news/data/bbc-iplayer-sees-performance-uplift-after-relaunching-on-nosql-database-3524893/?utm_source=dbweekly&utm_medium=email) ComputerWorld UKnews [How to Really Use SQL Views](https://periscopedata.com/blog/how-to-use-views.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Building An ElasticSearch Cluster in AWS with Packer and Terraform](http://www.paulstack.co.uk/blog/2016/01/02/building-an-elasticsearch-cluster-in-aws-with-packer-and-terraform/?utm_source=dbweekly&utm_medium=email) Paul Stacktutorial [Using Different MySQL Storage Engines in Database Design](http://www.vertabelo.com/blog/technical-articles/using-different-mysql-storage-engines-in-database-design?utm_source=dbweekly&utm_medium=email) Pavel Zimahoraututorial [Why Does Microsoft SQL Server Exist?](https://news.ycombinator.com/item?id=10843380&utm_source=dbweekly&utm_medium=email) Hacker Newsopinion [Clojure SQL Library Showdown](https://adambard.com/blog/clojure-sql-libs-compared/?utm_source=dbweekly&utm_medium=email) Adam Bardopinion [N1QL vs TSQL - Aggregations with Couchbase Server Vs SQL Server](http://blog.couchbase.com/2016/january/n1ql-vs-tsql---processing-aggregations?utm_source=dbweekly&utm_medium=email) Couchbaseopinion [How to Choose An In-Memory NoSQL Solution: Performance Measuring](http://highscalability.com/blog/2015/12/30/how-to-choose-an-in-memory-nosql-solution-performance-measur.html?utm_source=dbweekly&utm_medium=email) High Scalabilityopinion [dbHero for PostgreSQL & MySQL](https://dbheroapp.com/gui-database-client-for-mysql-postgresql-mac-osx?utm_source=dbweekly&utm_medium=email) — The list of options seem to keep growing for GUI editors for Postgres. dbHero looks to be a simple and clean option that looks great for OSX users. dbheroapp.​comtools [restabase: A REST Inteface for Your Database](https://github.com/marin-liovic/restabase?utm_source=dbweekly&utm_medium=email) — Written in Node, supports MySQL, Postgres, SQLite and MSSQL. Marin Liovićcode [Meaningful Cassandra Monitoring](http://dtdg.co/1PkYlNZ) — Easily collect and aggregate metrics from across your Cassandra cluster. Correlate Cassandra metrics with metrics from the rest of your stack. [14 day unlimited trial.](http://dtdg.co/1PkYlNZ) Datadogsponsored    

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