---
title: "This week's database news, issue 123"
publication: "DB Weekly"
issue: 123
published_at: "2016-09-23"
canonical_url: "https://dbweekly.com/issues/123"
---

Database Weekly 123   . 

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

[Database Weekly](http://dbweekly.com) Issue 123 — September 23, 2016     

Featured [Pushing Database Scalability Up And Out With GPUs](http://www.nextplatform.com/2016/09/22/pushing-database-scalability-gpus/?utm_source=dbweekly&utm_medium=email) — 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. Timothy Prickett Morganstory [Apache CouchDB 2.0 Final Now Available](https://blog.couchdb.org/2016/09/20/2-0/?utm_source=dbweekly&utm_medium=email) — CouchDB 2.0 is 99% API compatible with the 1.x series and most applications should continue to just work. CouchDBnews [How Not To Use Cassandra Like An RDBMS (and What Will Happen If You Do)](https://opencredo.com/how-not-to-use-cassandra-like-an-rdbms-and-what-will-happen-if-you-do/?utm_source=dbweekly&utm_medium=email) — Cassandra isn’t an RDMS, but it has some features that make it look a bit like one. This post reviews some example scenarios. Dominic Foxtutorial [Understand your users.](http://www.launchbit.com/taz/11159-6607-111) — Running a complex app? Record, analyze & watch live sessions of your users Jaco Analyticssponsored [![\](https://copm.s3.amazonaws.com/71cd97ee.png)](http://www.launchbit.com/taz/11159-6607-111) [A SQL Symbol Cheat Sheet](https://periscopedata.com/blog//sql-symbol-cheatsheet.html?utm_source=dbweekly&utm_medium=email) — A handy reference for a variety of symbols and operators you can use in SQL. Periscopetutorial [Introducing MySQL InnoDB Cluster](http://mysqlserverteam.com/introducing-mysql-innodb-cluster-mysql-ha-out-of-box-easy-to-use-high-availability/?utm_source=dbweekly&utm_medium=email) — 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.](https://www.youtube.com/watch?v=JWy7ZLXxtZ4) MySQL Server Teamtools [Scalable Stream Processing: A Survey of Storm, Samza, Spark and Flink](https://medium.baqend.com/real-time-stream-processors-a-survey-and-decision-guidance-6d248f692056?utm_source=dbweekly&utm_medium=email) — A thorough overview of popular distributed stream processing systems highlighting their similarities, differences and trade-offs taken in their respective designs. Wolfram Wingerathstory [RedRaft: Experimental Redis + Raft Server Implementation](https://github.com/tidwall/redraft?utm_source=dbweekly&utm_medium=email) — [Raft](https://raft.github.io/) is a consensus algo for multiple servers to agree on values in order to provide fault-tolerance. Josh Bakercode Jobs [Stop Applying to Jobs - Let Companies Come To You](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — 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. Hired.​com In brief [AWS Redshift Feels The Heat](https://www.datanami.com/2016/09/22/aws-redshift-feels-heat/?utm_source=dbweekly&utm_medium=email) — Redshift is taking a beating this week, with competitors Oracle Corp. and Cloudera claiming their platforms run faster for less money. Datanaminews [Announcing Citus MX: Scaling Postgres to Over 500k Writes Per Second](https://www.citusdata.com/blog/2016/09/22/announcing-citus-mx/?utm_source=dbweekly&utm_medium=email) — The private beta of Citus MX is now available. Citus Datanews [Digging in On Cloud SQL Automatic Storage Increases](https://cloudplatform.googleblog.com/2016/09/digging-in-on-Cloud-SQL-automatic-storage-increases.html?utm_source=dbweekly&utm_medium=email) — There’s a new setting in the storage dialog of Cloud SQL Second Generation: “Enable automatic storage increase.” Google Cloud Platformnews [Connecting R and Compose PostgreSQL](https://www.compose.com/articles/connecting-r-and-compose-postgresql/?utm_source=cooper&utm_medium=newsletter&utm_campaign=postgresql-and-r) — Learn how to connect R, the language used by data scientists and statisticians, to PostgreSQL with RPostgreSQL and RPostgres. Composetutorial sponsored [Improve PostgreSQL On Windows Performance by 100%](http://www.openscg.com/2016/09/improve-postgresql-windows-performance-by-100/?utm_source=dbweekly&utm_medium=email) David Radertutorial [Tracking KPIs using SQL for Effective Revenue Growth Analysis](https://periscopedata.com/blog//effective-revenue-chart.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Building A Scalable MySQL Proxy in Rust](http://www.agildata.com/building-scalable-mysql-proxy-rust/?utm_source=dbweekly&utm_medium=email) AgilDatatutorial [Moving Average Pipeline Aggregations in Elasticsearch](https://qbox.io/blog/moving-average-pipeline-aggregations-elasticsearch?utm_source=dbweekly&utm_medium=email) Vineeth Mohantutorial [Dynamic Pivot Tables with JSON and PostgreSQL](http://bender.io/2016/09/18/dynamic-pivot-tables-with-json-and-postgresql/?utm_source=dbweekly&utm_medium=email) Andrew Bendertutorial [Can Hadoop Be Simple Again?](https://www.datanami.com/2016/09/19/can-hadoop-simple/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [N+1 Queries Are Hardly A Feature](https://ayende.com/blog/175457/n-1-queries-are-hardly-a-feature?utm_source=dbweekly&utm_medium=email) Ayende Rahienopinion [New DreamFactory cache service supports Redis, memcached, and local storage](http://blog.dreamfactory.com/new-dreamfactory-cache-service-supports-redis-memcahed-and-local-storage?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=2-3) — Flexible and fast, DreamFactory’s new Cache Service is a powerful tool for API automation. DreamFactorytools sponsored [Protobuf Query: Run SQL Queries over Protocol Buffers](https://github.com/na-ka-na/object-query/tree/master/src/protobuf-query?utm_source=dbweekly&utm_medium=email) Sanchay Harnejacode [ActorDB: A Distributed SQL Database with Linear Scalability](http://www.actordb.com/?utm_source=dbweekly&utm_medium=email) ActorDBcode [BedquiltDB v2: A JSON Document Store Built on Postgres](http://bedquiltdb.github.io/v2.html?utm_source=dbweekly&utm_medium=email) — Version 2 includes new query operators for matching JSON documents, and you can now get up and running fast with a simple Docker image. Shane Kilkellycode    

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