DB Weekly Issue 86: January 8, 2016

5 Reasons You Should Use SQLite in 2016 — 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.

Using Redis as a Time Series Database: Why and How — As a data structure data store, Redis is incredibly flexible. This article looks at one way to use it as a time series database.

Is PostgreSQL Your Next JSON Database? — For those that haven’t been paying attention to JSON support in Postgres, this post will catch you up on its history and functionality.

Breaking News: New PostgreSQL 9.5 Performs 96% Faster Than v9.4 — 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.

DTBS: Database Design and Visualization — A visual, browser-based database design tool that lets you build both SQL and MongoDB schemas.

PostgreSQL 9.5 Released — 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.

MongoDB Co-Creator Explains Why ‘NoSQL’ Came to Be — An interview with Eliot Horowitz on the background to MongoDB, NoSQL in general, and the role of open source in innovation.

One Reason Why People Fail in Oracle DBA Interviews — "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."

Join our team of brainiacs and be a part of the database monitoring revolution

Announcing Spark 1.6 — Apache Spark is a fast and general processing engine compatible with Hadoop data.

New Databases Help Astronomers Probe the Universe

MySQL for Visual Studio 1.2.6 Released

MySQL for Excel 1.3.6 Released

Introducing A Simplified Configuration Experience for SQL Server in Azure Virtual Machines

BBC's iPlayer Sees Performance Uplift After Relaunching on NoSQL Database

How to Really Use SQL Views

Building An ElasticSearch Cluster in AWS with Packer and Terraform

Using Different MySQL Storage Engines in Database Design

Why Does Microsoft SQL Server Exist?

Clojure SQL Library Showdown

N1QL vs TSQL - Aggregations with Couchbase Server Vs SQL Server

How to Choose An In-Memory NoSQL Solution: Performance Measuring

dbHero for PostgreSQL & MySQL — 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.

restabase: A REST Inteface for Your Database — Written in Node, supports MySQL, Postgres, SQLite and MSSQL.

Meaningful Cassandra Monitoring — 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.