#181: Elasticsearch 6.0.0 Released

This week's database news - Read this on the Web

Database Weekly Issue 181 — November 17, 2017

SQL Operations Studio: A New Data Management Tool from Microsoft — A Windows, macOS and Linux app for working with SQL Server, Azure SQL DB and SQL DW. Microsoft   tools   Elasticsearch 6.0.0 Released — The popular full-text search-oriented database gains zero downtime upgrades, faster restarts, faster query times, and more. The new version is based on Lucene 7. Clinton Gormley   news   Performance Analytics for Amazon Redshift. For Data Engineering Heroes — Amazon Redshift is incredibly powerful, but you can spend a lot of time fighting fires. We fix that. intermix.io gives you the tools you need to analyze your Redshift performance and improve the toolchain of everyone downstream from your cluster. intermix.​io   sponsored   Building a Microservices Ecosystem with Kafka Streams and KSQL — How to build fine grained, streaming microservices with the Apache Kafka Streams API and KSQL. Ben Stopford   tutorial   Datasette: Instantly Build an API for SQLite Databases — Got an SQLite database you want to share on the web? This is the tool for you. Simon Willison   tools   MariaDB Coming to Azure as Microsoft Joins the MariaDB Foundation — The popular MySQL fork continues to make big steps. Ars Technica   news   Distributed PostgreSQL Settling Into Cloud — Citus brings horizontal scalability to Postgres users. Datanami   news   Google Cloud's Distributed NoSQL Database Spanner Goes Global The New Stack   news   Azure Cosmos DB Launches Native Support for the Apache Cassandra API — Allows you to take Cassandra-backed apps to Azure using Microsoft’s scalable multi-model database, Cosmos. Microsoft Azure   news   Using Grafana with SiriDB — Learn how to setup a Grafana dashboard using the SiriDB plugin. Transceptor Technology   sponsored   Troubleshooting MongoDB 100% CPU Load and Slow Queries Igor Khomenko   tutorial   Faster Bulk Loading in Postgres with 'Copy' — \copy is a mechanism for you to bulk load data in or out of Postgres. citusdata   tutorial   How ACID Transactions Work in a Globally Distributed Database — .. or FaunaDB, specifically. Matt Freels   tutorial   The Mode Ordered-Set Aggregate Function — A way to find the most frequent input value in a group. Dimitri Fontaine   tutorial   How to Avoid Excessive Sorts in Window Functions Lukas Eder   tutorial   How to Approach Cassandra NoSQL Data Model Design Shannen Wehrman   tutorial   Continuous Delivery: GoCD vs. Jenkins — We compared GoCD with Jenkins on philosophy, continuous delivery & plugins. Understand how these CI/CD tools fit your needs. GoCD   sponsored   PostgreSQL 10: An 'Amplified' Version of PostgreSQL — Why version 10 is “the defining version” of the popular RDBMS. commandprompt.​com   opinion   YCSB Benchmark Results for YugaByte and Apache Cassandra — Yugabyte is a new database we featured 2 weeks ago which is compatible with Cassandra’s API. YugaByte Forum   opinion   How Should You Build A High-Performance Column Store for the 2020s? Daniel Lemire   opinion   dbmgr: CLI Tool to Back Up, Restore, and Provision Dev Databases — For MySQL and Postgres only so far. github.​com   tools   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK