DB Weekly Issue 180: November 10, 2017

MongoDB 3.6 Released: Security, Robustness and JSON Schema — A new version of the popular NoSQL database: better hardened against network outages with ‘Retryable Writes’, as well as against ransomware by only binding to localhost by default. It now also supports JSON Schema for data validation.

Advanced SQL: A Look At Window Functions — A complete exploration of window functions, ideal if you’re not particularly familiar with them.

Redis Streams and the Unified Log — Redis, the data structure server, will soon be shipping with a stream data structure, which opens up an opportunity for unified logs and using Redis as a lighter alternative to Kafka.

Continuous Delivery 101 from GoCD — This video series covers the history of CD, concepts, best practices, how to get started, and popular tools. You'll gain a holistic view of continuous delivery and a deeper understanding and appreciation of critical concepts.

Turning VS Code Into A Killer MongoDB Admin Tool — You can turn Visual Studio Code into a practical MongoDB admin tool with a single extension.

Work on SQLite4 Has Concluded — Not a lot to see here, but SQLite4 was basically an experimental branch whose ideas have now been folded into SQLite3 which remains the latest official version.

Standards Effort Seeks to Redefine 'Data Scientist' — Despite soaring demand for data skills "there isn’t a standardized way of defining, certifying or even quantifying the number of data scientists in the workforce"

Google's Cloud SQL for Postgres Adds High Availability and Replication — Google's service has improved its Postgres offering with support for high availability and read replicas, plus instances with up to 416GB of RAM.

PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 Released — To fix three security vulnerabilities.

Couchbase's Engaging Plan for Customer Victory — Essentially it’s about letting users analyze ‘customer engagement’ better.

Elastic Acquires Swiftype, a Site Search Service

In-Memory Database Terracotta Goes 'Translytical'

Monitoring for All Your Data Stores (And Everything Else) — Datadog integrates seamlessly with 200+ technologies, including Postgres, MySQL, MongoDB, Redis, and DynamoDB.

On Database Connection and Statement Timeouts

Portfolio Risk Analysis in SQL — A fun (but older) read if you’re looking to level up your SQL skills.

The Case Against ORMs — One developer lays out the case against using ORMs, based on personal experience.

SQL or NoSQL? How About Both? — Using SQL and NoSQL side-by-side to exploit their respective strengths.

So, What is DevOps? — The million-dollar question, it is. Much like the trailer for "Star Wars: The Last Jedi," it seems like everyone is talking about DevOps.

Catena: A Distributed Database Based on a Blockchain — .. and accessible using SQL.