---
title: "#177: TiDB 1.0 - A Distributed NewSQL Database for Analytics"
publication: "DB Weekly"
issue: 177
published_at: "2017-10-20"
canonical_url: "https://dbweekly.com/issues/177"
---

Database Weekly 177   

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

[Database Weekly](http://dbweekly.com) Issue 177 — October 20, 2017     

[TiDB 1.0: A Distributed NewSQL Database for Analytics](https://pingcap.github.io/blog/2017/10/17/announcement/?utm_source=dbweekly&utm_medium=email) — An open source distributed Hybrid Transactional/Analytical Processing (HTAP) database written in the Go language. PingCAPnews [Getting Started Analyzing Twitter Data in Apache Kafka through KSQL](https://www.confluent.io/blog/using-ksql-to-analyse-query-and-transform-data-in-kafka?utm_source=dbweekly&utm_medium=email) — How to use Apache Kafka and KSQL to query, analyze, and transform streams of data, such as from Twitter. Robin Moffatttutorial [Performance Analytics for Amazon Redshift](https://www.intermix.io/dbweekly) — When it comes to Amazon Redshift, there’s an elephant in the room. Everyone is struggling. intermix.​iosponsored [![\](https://copm.s3.amazonaws.com/b2ba1091.jpg)](https://www.intermix.io/dbweekly) [MongoDB Looks to Future Following IPO](https://www.datanami.com/2017/10/19/mongodb-looks-future-following-ipo/?utm_source=dbweekly&utm_medium=email) — Exciting times for the document-oriented database company, especially as their shares [jumped in their first day](https://www.cnbc.com/2017/10/19/mongodb-mdb-ipo-stock-price-on-first-trading-day.html) of trading. But what’s the longer term story? Datanaminews [ApsaraCache: A Redis Branch from the Alibaba Group](https://github.com/alibaba/ApsaraCache?utm_source=dbweekly&utm_medium=email) — Based on Redis 4.0, this Redis variant supports Memcached’s two main protocols, and boasts performance improvements over regular Redis. Alibabacode ['Dear Postgres': A Love Letter to Postgres](http://www.craigkerstiens.com/2017/10/12/dear-postgres/?utm_source=dbweekly&utm_medium=email) — Give a read to this letter on all Postgres has brought over the years. Craig Kerstiensnews [Automating SQL Caching for Amazon ElastiCache and Amazon RDS](https://aws.amazon.com/blogs/database/automating-sql-caching-for-amazon-elasticache-and-amazon-rds/?utm_source=dbweekly&utm_medium=email) — 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 Blogtutorial [RocketMQ Reaches Top-Level Status at the Apache Software Foundation](https://thenewstack.io/rocketmq-reaches-asf-top-level-status/?utm_source=dbweekly&utm_medium=email) Susan Hallnews [Analytics Remains Top Data Tech, Survey Says](https://www.datanami.com/2017/10/19/analytics-remains-top-data-tech-survey-says/?utm_source=dbweekly&utm_medium=email) Datanaminews [2Q PGConf 2017 (November 6-9, NYC and Chicago)](http://www.2qpgconf.com/?utm_source=dbweekly&utm_medium=email) — 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 2017news [$20 Free on a new Linode account](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Linux cloud hosting starting at 1GB of RAM for $5/mo. Get $20 credit on a new account. Linode Cloud Hostingsponsored [Monitoring Slow SQL Queries via Slack](http://azer.bike/journal/monitoring-slow-sql-queries-via-slack/?utm_source=dbweekly&utm_medium=email) Azer Koçulututorial [A Tour of Postgres Index Types](https://www.citusdata.com/blog/2017/10/17/tour-of-postgres-index-types/?utm_source=dbweekly&utm_medium=email) — Postgres has a rich set of index types from standard b-tree to GIN and GiST. Craig Kerstienstutorial [Scalable SQL Made Easy: How CockroachDB Automates Operations](https://www.cockroachlabs.com/blog/automated-rebalance-and-repair/?utm_source=dbweekly&utm_medium=email) Bram Gruneirstory [The 7 Year Itch: How Aerospike Decided to Transform The Database Status-Quo](https://www.aerospike.com/blog/aerospike4-tech/?utm_source=dbweekly&utm_medium=email) — Aerospike is mostly used in real-time high-throughput scenarios. Aerospikestory [Ask HN: What Papers and Resources Are Best to Learn NoSQL Concepts?](https://news.ycombinator.com/item?id=15427932&utm_source=dbweekly&utm_medium=email) Hacker Newsopinion [The Best Features of Postgres 10 for Database Administrators](http://www.cybertec.at/best-of-postgresql-10-for-the-dba/?utm_source=dbweekly&utm_medium=email) Kaarel Moppelopinion [GoCD - Open Source Continuous Delivery Server](https://www.gocd.org/?utm_campaign=gocd_oss&utm_medium=email&utm_source=cooperess_db&utm_content=go_website&utm_term=) — Open source continuous delivery tool specializing in advanced workflow modeling and dependency management. GoCDsponsored [visql: Edit 'Slices' of SQL Databases in Vi/Vim](https://github.com/paulfitz/visql?utm_source=dbweekly&utm_medium=email) — Works with SQLite, MySQL and Postgres. Paul Fitzpatricktools    

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