DB Weekly Issue 177: October 20, 2017

TiDB 1.0: A Distributed NewSQL Database for Analytics — An open source distributed Hybrid Transactional/Analytical Processing (HTAP) database written in the Go language.

Getting Started Analyzing Twitter Data in Apache Kafka through KSQL — How to use Apache Kafka and KSQL to query, analyze, and transform streams of data, such as from Twitter.

Performance Analytics for Amazon Redshift — When it comes to Amazon Redshift, there’s an elephant in the room. Everyone is struggling.

MongoDB Looks to Future Following IPO — Exciting times for the document-oriented database company, especially as their shares jumped in their first day of trading. But what’s the longer term story?

ApsaraCache: A Redis Branch from the Alibaba Group — Based on Redis 4.0, this Redis variant supports Memcached’s two main protocols, and boasts performance improvements over regular Redis.

'Dear Postgres': A Love Letter to Postgres — Give a read to this letter on all Postgres has brought over the years.

Automating SQL Caching for Amazon ElastiCache and Amazon RDS — How to use DBA assistant tools to automate the creation and management of a Redis query cache using ElastiCache and Amazon RDS (or Amazon Aurora).

RocketMQ Reaches Top-Level Status at the Apache Software Foundation

Analytics Remains Top Data Tech, Survey Says

2Q PGConf 2017 (November 6-9, NYC and Chicago) — Postgres training and talks in New York, plus a day of talks in Chicago. Use code Cooper_40 for a 40% discount on general admission and/or training.

20ドル Free on a new Linode account — Linux cloud hosting starting at 1GB of RAM for 5ドル/mo. Get 20ドル credit on a new account.

Monitoring Slow SQL Queries via Slack

A Tour of Postgres Index Types — Postgres has a rich set of index types from standard b-tree to GIN and GiST.

Scalable SQL Made Easy: How CockroachDB Automates Operations

The 7 Year Itch: How Aerospike Decided to Transform The Database Status-Quo — Aerospike is mostly used in real-time high-throughput scenarios.

Ask HN: What Papers and Resources Are Best to Learn NoSQL Concepts?

The Best Features of Postgres 10 for Database Administrators

GoCD - Open Source Continuous Delivery Server — Open source continuous delivery tool specializing in advanced workflow modeling and dependency management.

visql: Edit 'Slices' of SQL Databases in Vi/Vim — Works with SQLite, MySQL and Postgres.