DB Weekly Issue 123: September 23, 2016

Pushing Database Scalability Up And Out With GPUs — It turns out what’s good for simulation and machine learning is also good for databases. GPUs are increasingly being seen as the way forward for faster databases.

Apache CouchDB 2.0 Final Now Available — CouchDB 2.0 is 99% API compatible with the 1.x series and most applications should continue to just work.

How Not To Use Cassandra Like An RDBMS (and What Will Happen If You Do) — Cassandra isn’t an RDMS, but it has some features that make it look a bit like one. This post reviews some example scenarios.

Understand your users. — Running a complex app? Record, analyze & watch live sessions of your users

A SQL Symbol Cheat Sheet — A handy reference for a variety of symbols and operators you can use in SQL.

Introducing MySQL InnoDB Cluster — MySQL InnoDB Cluster integrates across MySQL server, Group Replication and MySQL Router for a complete High Availability solution based on InnoDB, all managed through a scriptable API. 5 minute demo.

Scalable Stream Processing: A Survey of Storm, Samza, Spark and Flink — A thorough overview of popular distributed stream processing systems highlighting their similarities, differences and trade-offs taken in their respective designs.

RedRaft: Experimental Redis + Raft Server Implementation — Raft is a consensus algo for multiple servers to agree on values in order to provide fault-tolerance.

Stop Applying to Jobs - Let Companies Come To You — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly.

AWS Redshift Feels The Heat — Redshift is taking a beating this week, with competitors Oracle Corp. and Cloudera claiming their platforms run faster for less money.

Announcing Citus MX: Scaling Postgres to Over 500k Writes Per Second — The private beta of Citus MX is now available.

Digging in On Cloud SQL Automatic Storage Increases — There’s a new setting in the storage dialog of Cloud SQL Second Generation: "Enable automatic storage increase."

Connecting R and Compose PostgreSQL — Learn how to connect R, the language used by data scientists and statisticians, to PostgreSQL with RPostgreSQL and RPostgres.

Improve PostgreSQL On Windows Performance by 100%

Tracking KPIs using SQL for Effective Revenue Growth Analysis

Building A Scalable MySQL Proxy in Rust

Moving Average Pipeline Aggregations in Elasticsearch

Dynamic Pivot Tables with JSON and PostgreSQL

Can Hadoop Be Simple Again?

N+1 Queries Are Hardly A Feature

New DreamFactory cache service supports Redis, memcached, and local storage — Flexible and fast, DreamFactory’s new Cache Service is a powerful tool for API automation.

Protobuf Query: Run SQL Queries over Protocol Buffers

ActorDB: A Distributed SQL Database with Linear Scalability

BedquiltDB v2: A JSON Document Store Built on Postgres — Version 2 includes new query operators for matching JSON documents, and you can now get up and running fast with a simple Docker image.