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).
AWS Database Blog
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
for a 40% discount on general admission and/or training.
2Q PGconf 2017
$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
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.