---
title: "#181: Elasticsearch 6.0.0 Released"
publication: "DB Weekly"
issue: 181
published_at: "2017-11-17"
canonical_url: "https://dbweekly.com/issues/181"
---

Database Weekly 181   

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

[Database Weekly](http://dbweekly.com) Issue 181 — November 17, 2017     

[SQL Operations Studio: A New Data Management Tool from Microsoft](https://github.com/Microsoft/sqlopsstudio) — A Windows, macOS and Linux app for working with SQL Server, Azure SQL DB and SQL DW. Microsofttools [Elasticsearch 6.0.0 Released](https://www.elastic.co/blog/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 Gormleynews [Performance Analytics for Amazon Redshift. For Data Engineering Heroes](https://www.intermix.io) — 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.​iosponsored [![\](https://copm.s3.amazonaws.com/508229b4.jpg)](https://www.intermix.io) [Building a Microservices Ecosystem with Kafka Streams and KSQL](https://www.confluent.io/blog/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 Stopfordtutorial [Datasette: Instantly Build an API for SQLite Databases](https://simonwillison.net/2017/Nov/13/datasette/) — Got an SQLite database you want to share on the web? This is the tool for you. Simon Willisontools [MariaDB Coming to Azure as Microsoft Joins the MariaDB Foundation](https://arstechnica.com/gadgets/2017/11/mariadb-coming-to-azure-as-microsoft-joins-the-mariadb-foundation/) — The popular MySQL fork continues to make big steps. Ars Technicanews [Distributed PostgreSQL Settling Into Cloud](https://www.datanami.com/2017/11/16/distributed-postgresql-settling-cloud/) — Citus brings horizontal scalability to Postgres users. Datanaminews [Google Cloud's Distributed NoSQL Database Spanner Goes Global](https://thenewstack.io/google-takes-cloud-spanner-global/) The New Stacknews [Azure Cosmos DB Launches Native Support for the Apache Cassandra API](https://azure.microsoft.com/en-gb/blog/dear-cassandra-developers-welcome-to-azure-cosmosdb/) — Allows you to take Cassandra-backed apps to Azure using Microsoft’s scalable multi-model database, Cosmos. Microsoft Azurenews [Using Grafana with SiriDB](http://siridb.net/blog/using-grafana-with-siridb/) — Learn how to setup a Grafana dashboard using the SiriDB plugin. Transceptor Technologysponsored [Troubleshooting MongoDB 100% CPU Load and Slow Queries](https://medium.com/@igorkhomenko/troubleshooting-mongodb-100-cpu-load-and-slow-queries-da622c6e1339) Igor Khomenkotutorial [Faster Bulk Loading in Postgres with 'Copy'](https://www.citusdata.com/blog/2017/11/08/faster-bulk-loading-in-postgresql-with-copy/) — `\copy` is a mechanism for you to bulk load data in or out of Postgres. citusdatatutorial [How ACID Transactions Work in a Globally Distributed Database](https://fauna.com/blog/consistent-transactions-in-a-globally-distributed-database) — .. or FaunaDB, specifically. Matt Freelstutorial [The Mode Ordered-Set Aggregate Function](http://tapoueh.org/blog/2017/11/the-mode-ordered-set-aggregate-function/) — A way to find the most frequent input value in a group. Dimitri Fontainetutorial [How to Avoid Excessive Sorts in Window Functions](https://blog.jooq.org/2017/11/06/how-to-avoid-excessive-sorts-in-window-functions/) Lukas Edertutorial [How to Approach Cassandra NoSQL Data Model Design](http://highscalability.com/blog/2017/11/13/cassandra-nosql-data-model-design.html) Shannen Wehrmantutorial [Continuous Delivery: GoCD vs. Jenkins](https://www.gocd.org/2017/04/25/gocd-over-jenkins/?utm_campaign=jenkins_vs_gocd&utm_medium=email&utm_source=cooperess_db&utm_content=jenkins_blog&utm_term=) — We compared GoCD with Jenkins on philosophy, continuous delivery & plugins. Understand how these CI/CD tools fit your needs. GoCDsponsored [PostgreSQL 10: An 'Amplified' Version of PostgreSQL](https://commandprompt.com/blog/postgresql_v10_an_amplified_version_of_postgresql/) — Why version 10 is _“the defining version”_ of the popular RDBMS. commandprompt.​comopinion [YCSB Benchmark Results for YugaByte and Apache Cassandra](https://forum.yugabyte.com/t/ycsb-benchmark-results-for-yugabyte-and-apache-cassandra/59) — [Yugabyte](https://blog.yugabyte.com/yugabyte-has-arrived-fa1be31aa57b) is a new database we featured 2 weeks ago which is compatible with Cassandra’s API. YugaByte Forumopinion [How Should You Build A High-Performance Column Store for the 2020s?](https://lemire.me/blog/2017/11/10/how-should-you-build-a-high-performance-column-store-for-the-2020s/) Daniel Lemireopinion [dbmgr: CLI Tool to Back Up, Restore, and Provision Dev Databases](https://github.com/callahanrts/dbmgr) — For MySQL and Postgres only so far. github.​comtools    

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