DB Weekly Issue 77: October 30, 2015

A Certain Tendency Of The Database Community — "We posit that striving for distributed systems that provide ‘single system image’ semantics is fundamentally flawed and at odds with how systems operate in the physical world."

Speed with Ease – NoSQL on the Google Cloud Platform — A look at how a big data architect and an engineer got Aerospike to serve 4 million transactions per second on a 20 node Google Cloud cluster.

Have you got SQL fingers? — Watch these free SQL Prompt tips videos for SQL writing hints from top SQL Server MVPs. SQL Prompt is the SQL code productivity add-in for SQL Server Management Studio and Visual Studio. Find out how easily you can write SQL.

How to Find the Closest Subset Sum with SQL — A great demonstration of SQL’s power on a task whose solution isn’t immediately obvious.

Why NoSQL Will Only Let You Perform Transactions On A Single Data Item — A look at why NoSQL systems such as MongoDB, Cassandra, HBase, and Riak only provide support for transactions when working with a single key.

gpdb: Pivotal Greenplum Database — Greenplum, a massively parallel processing database, is one of many databases that started with Postgres then built on top of it. It’s now fully open source.

Top 10 Most Common T-SQL Database Scripts — What are the scripts that a working DBA uses so often that they become part of the ‘muscle memory’? Grant Fritchey asked the question on the forums of SQL Server Central.

Microsoft, Oracle, AWS are the Top Database Leaders, According to Gartner

Oracle Enterprise Manager for MySQL v3 Now Available

MySQL Servers Hijacked with Malware to Perform DDoS Attacks

Gartner placed EnterpriseDB in the Leaders Quadrant for a 2nd year — Gartner placed EnterpriseDB in the Leaders Quadrant for the 2nd year running, alongside the market’s largest commercial giants. Find out more about Gartner’s insights and recommendations by downloading Gartner's The State of Open-Source RDBMS, 2015.

Pinterest Open-Sources Its MySQL Management Tools

Couchbase LINQ Provider Released: LINQ + N1QL + Couchbase

Secondary Indexing with Redis

How to Choose A NoSQL Analytics System

cassandradump: A Data Exporting Tool for Cassandra, inspired by mysqldump

Test the Distributed Open Source RDBMS for Real-Time Big Data on PostgreSQL — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain real-time insights.

Introducing Agate: A Better Data Analysis Library for Journalists — It’s a Python library.

PGJSON: Use Postgres As A Zero-Config NoSQL Database from Node

Hedis: Retrieve Data From Any Database via Redis — A ‘hyper Redis’ that acts as a proxy of sorts to other databases, caching their responses.

react-native-sqlite-storage: SQLite Native Plugin for React Native

Rethinking SIMD Vectorization for In-Memory Databases [PDF] — An academic paper.