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.
Timothy Prickett Morgan
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.
MySQL Server Team
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
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.”
Google Cloud Platform
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.