#177: TiDB 1.0 - A Distributed NewSQL Database for Analytics

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

Database 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. PingCAP   news   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. Robin Moffatt   tutorial   Performance Analytics for Amazon Redshift — When it comes to Amazon Redshift, there’s an elephant in the room. Everyone is struggling. intermix.​io   sponsored   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? Datanami   news   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. Alibaba   code   'Dear Postgres': A Love Letter to Postgres — Give a read to this letter on all Postgres has brought over the years. Craig Kerstiens   news   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). AWS Database Blog   tutorial   RocketMQ Reaches Top-Level Status at the Apache Software Foundation Susan Hall   news   Analytics Remains Top Data Tech, Survey Says Datanami   news   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. 2Q PGconf 2017   news   $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. Linode Cloud Hosting   sponsored   Monitoring Slow SQL Queries via Slack Azer Koçulu   tutorial   A Tour of Postgres Index Types — Postgres has a rich set of index types from standard b-tree to GIN and GiST. Craig Kerstiens   tutorial   Scalable SQL Made Easy: How CockroachDB Automates Operations Bram Gruneir   story   The 7 Year Itch: How Aerospike Decided to Transform The Database Status-Quo — Aerospike is mostly used in real-time high-throughput scenarios. Aerospike   story   Ask HN: What Papers and Resources Are Best to Learn NoSQL Concepts? Hacker News   opinion   The Best Features of Postgres 10 for Database Administrators Kaarel Moppel   opinion   GoCD - Open Source Continuous Delivery Server — Open source continuous delivery tool specializing in advanced workflow modeling and dependency management. GoCD   sponsored   visql: Edit 'Slices' of SQL Databases in Vi/Vim — Works with SQLite, MySQL and Postgres. Paul Fitzpatrick   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