---
title: "This week's database news, issue 77"
publication: "DB Weekly"
issue: 77
published_at: "2015-10-30"
canonical_url: "https://dbweekly.com/issues/77"
---

Database Weekly 77   . 

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

[Database Weekly](http://dbweekly.com) Issue 77 — October 30, 2015     

Featured [A Certain Tendency Of The Database Community](https://christophermeiklejohn.com/lasp/erlang/2015/10/27/tendency.html?utm_source=dbweekly&utm_medium=email) — “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.” Christopher Meiklejohnopinion [Speed with Ease – NoSQL on the Google Cloud Platform](http://googlecloudplatform.blogspot.com/2015/10/speed-with-Ease-NoSQL-on-the-Google-Cloud-Platform.html?utm_source=dbweekly&utm_medium=email) — 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. Google Cloud Platform Blog [Have you got SQL fingers?](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24174#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.](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly=displayemail=sqlfingers_v2=sqlprompt=email-24166#sql-fingers) sqlpromptsponsored [![\](https://copm.s3.amazonaws.com/e2ad2112.gif)](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24174#sql-fingers) [How to Find the Closest Subset Sum with SQL](http://blog.jooq.org/2015/10/26/how-to-find-the-closest-subset-sum-with-sql/?utm_source=dbweekly&utm_medium=email) — A great demonstration of SQL’s power on a task whose solution isn’t immediately obvious. Data Geekery [Why NoSQL Will Only Let You Perform Transactions On A Single Data Item](http://dbmsmusings.blogspot.com/2015/10/why-mongodb-cassandra-hbase-dynamodb_28.html?utm_source=dbweekly&utm_medium=email) — A look at why NoSQL systems such as MongoDB, Cassandra, HBase, and Riak only provide support for transactions when working with a single key. DBMS Musings [gpdb: Pivotal Greenplum Database](https://github.com/greenplum-db/gpdb?utm_source=dbweekly&utm_medium=email) — 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. Pivotalcode [Top 10 Most Common T-SQL Database Scripts](https://www.simple-talk.com/sql/t-sql-programming/top-10-most-common-database-scripts/?utm_source=dbweekly&utm_medium=email) — 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. Simple Talk In brief [Microsoft, Oracle, AWS are the Top Database Leaders, According to Gartner](http://www.techrepublic.com/article/microsoft-oracle-aws-are-the-top-database-leaders-according-to-gartner/?utm_source=dbweekly&utm_medium=email) TechRepublicnews [Oracle Enterprise Manager for MySQL v3 Now Available](https://blogs.oracle.com/MySQL/entry/oracle_enterprise_manager_for_mysql1?utm_source=dbweekly&utm_medium=email) Oraclenews tools [MySQL Servers Hijacked with Malware to Perform DDoS Attacks](http://www.symantec.com/connect/blogs/mysql-servers-hijacked-malware-perform-ddos-attacks?utm_source=dbweekly&utm_medium=email) Symantec Connect Communitynews [Gartner placed EnterpriseDB in the Leaders Quadrant for a 2nd year](http://info.enterprisedb.com/Gartner-MQ-2015.html?src=gartner-mq-edb-home-slide2015?utm_source=cooperpress&utm_medium=email&utm_campaign=gartnermq2015&utm_source=dbweekly) — 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. EnterpriseDBnews sponsored [Pinterest Open-Sources Its MySQL Management Tools](https://engineering.pinterest.com/blog/open-sourcing-pinterest-mysql-management-tools?utm_source=dbweekly&utm_medium=email) Pinterest Engineeringnews tools [Couchbase LINQ Provider Released: LINQ + N1QL + Couchbase](http://blog.couchbase.com/2015/october/linq-n1ql-and-couchbase-oh-mai-linq2couchbase-ga?utm_source=dbweekly&utm_medium=email) Couchbasenews [Secondary Indexing with Redis](http://redis.io/topics/indexes?utm_source=dbweekly&utm_medium=email) Redistutorial [How to Choose A NoSQL Analytics System](http://www.infoworld.com/article/2983953/nosql/how-to-choose-a-nosql-analytics-system.html?utm_source=dbweekly&utm_medium=email) InfoWorldopinion [cassandradump: A Data Exporting Tool for Cassandra, inspired by mysqldump](https://github.com/gianlucaborello/cassandradump?utm_source=dbweekly&utm_medium=email) Gianluca Borellotools [Test the Distributed Open Source RDBMS for Real-Time Big Data on PostgreSQL](http://info.citusdata.com/BigDataDBW.html?utm_source=dbweekly&utm_medium=email) — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain [real-time insights](http://info.citusdata.com/BigDataPW3.html). Citus Datatools sponsored [Introducing Agate: A Better Data Analysis Library for Journalists](https://source.opennews.org/en-US/articles/introducing-agate/?utm_source=dbweekly&utm_medium=email) — It’s a Python library. OpenNewstools [PGJSON: Use Postgres As A Zero-Config NoSQL Database from Node](https://github.com/fiatjaf/pgjson?utm_source=dbweekly&utm_medium=email) Giovannicode [Hedis: Retrieve Data From Any Database via Redis](https://github.com/hedisdb/hedis?utm_source=dbweekly&utm_medium=email) — A ‘hyper Redis’ that acts as a proxy of sorts to other databases, caching their responses. github.​comcode [react-native-sqlite-storage: SQLite Native Plugin for React Native](https://github.com/andpor/react-native-sqlite-storage?utm_source=dbweekly&utm_medium=email) Andrzej Porebskicode [Rethinking SIMD Vectorization for In-Memory Databases [PDF\]](http://www.cs.columbia.edu/~orestis/sigmod15.pdf?utm_source=dbweekly&utm_medium=email) — An academic paper. Polychroniou, Raghavan and Ross    

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