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

Database Weekly 145   . 

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

[Database Weekly](http://dbweekly.com) Issue 145 — March 10, 2017     

Featured [Many SQL Perf Problems Stem from “Unnecessary, Mandatory Work”](https://blog.jooq.org/2017/03/08/many-sql-performance-problems-stem-from-unnecessary-mandatory-work/?utm_source=dbweekly&utm_medium=email) — Many ORMs and query builders will do wasteful things like `SELECT *` by default, but it can go a lot further than that. JavaOOQstory [Google Cloud SQL for PostgreSQL: Fully Managed Postgres on GCP](https://cloud.google.com/sql/docs/postgres/?utm_source=dbweekly&utm_medium=email) — A beta release but it’ll be available for all Google Cloud users on Monday (March 13). Google Cloud Platformnews [MongoDB's Hosted MongoDB Service Gets A Free Tier](https://www.linkedin.com/pulse/introducing-m0-free-tier-mongodb-atlas-jay-gordon?published=t&utm_source=dbweekly&utm_medium=email) — [Atlas](https://www.mongodb.com/cloud/atlas) is MongoDB’s own MongoDB-as-a-service offering, and now has a free ‘starting point’ tier that provides a 3 node cluster with 512MB storage. Jay Gordonnews [Performance Dashboard for Redis](https://dashboard.redisgreen.net/redismonitor_sign_up?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=perf+dashboard) — RedisMonitor's interactive visual map of your Redis memory makes it easy to find out why. Starts at just $7 per month. Redisgreensponsored [![\](https://copm.s3.amazonaws.com/ed5ef360.png)](https://dashboard.redisgreen.net/redismonitor_sign_up?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=perf+dashboard) [How Modern SQL Databases Come Up with Algorithms You Never Dreamed Of](https://www.youtube.com/watch?v=wTPGW1PNy_Y&utm_source=dbweekly&utm_medium=email) — A 50 minute talk from an SQL superfan on the beauty of how SQL-based databases figure out how to obtain the desired results we declare. Lukas Edervideo [Acra: An Open Source Postgres Protection Suite](https://github.com/cossacklabs/acra?utm_source=dbweekly&utm_medium=email) — Tools to secure Postgres databases in distributed environments. Selectively encrypt sensitive records and detect potential intrusions and SQL injections. Mongo and MySQL support promised soon. Cossack Labstools [MySQL Backup Backdoor Vulnerability Revealed](https://blog.tarq.io/cve-2016-5483-backdooring-mysqldump-backups/?utm_source=dbweekly&utm_medium=email) — By crafting a malicious table name, an attacker can execute arbitrary SQL queries and shell commands if the dump file is imported. Chris Tarquininews [What's In the Pipeline for Apache Spark?](https://www.datanami.com/2017/03/06/whats-pipeline-apache-spark/?utm_source=dbweekly&utm_medium=email) — Apache Spark creator Matei Zaharia promises Spark will see a variety of new features and enhancements this year, including a standard binary data format. Datanaminews In brief [ScyllaDB Closes $16 Million in Funding to Expand Next-Gen Cassandra DB](http://www.scylladb.com/press-release/scylladb-closes-16-million-series-b-funding-expand-next-generation-cassandra-database/?utm_source=dbweekly&utm_medium=email) ScyllaDBnews [Confluent Raises $50M to Continue Growing Commercial Arm of Apache Kafka](https://techcrunch.com/2017/03/07/confluent-raises-50m-to-continue-growing-commercial-arm-of-apache-kafka/?utm_source=dbweekly&utm_medium=email) TechCrunchnews [Amazon RDS – 2016 in Review](https://aws.amazon.com/blogs/aws/amazon-rds-2016-in-review/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [How Kafka Redefined Data Processing for the Streaming Age](https://www.datanami.com/2017/03/07/kafka-redefined-data-processing-streaming-age/?utm_source=dbweekly&utm_medium=email) Datanaminews [Google Is Acquiring Data Science Community Kaggle](https://techcrunch.com/2017/03/07/google-is-acquiring-data-science-community-kaggle/?utm_source=dbweekly&utm_medium=email) TechCrunchnews [Put your DB into overdrive on Linode’s SSD servers.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for $20 credit linodesponsored [Parsing Addresses in PostgreSQL using the 'address_standardizer' Extension](http://dba.stackexchange.com/questions/165915/how-do-i-parse-addresses-in-postgresql/165916?utm_source=dbweekly&utm_medium=email#165916) — A project from the PostGIS project that can break an address into its component parts. Stack Exchangetutorial [Impress Your Coworkers With the NATURAL FULL OUTER JOIN](https://blog.jooq.org/2017/03/07/impress-your-coworkers-with-a-sql-natural-full-outer-join/?utm_source=dbweekly&utm_medium=email) JavaOOQtutorial [High-Availability with Redis Sentinels Connecting to Master/Slave](https://scalegrid.io/blog/high-availability-with-redis-sentinels-connecting-to-redis-masterslave-sets/?utm_source=dbweekly&utm_medium=email) ScaleGridtutorial [Let's Corrupt a SQL Server Database Together](https://www.brentozar.com/archive/2017/02/lets-corrupt-sql-server-database-together/?utm_source=dbweekly&utm_medium=email) — Mostly a look at what happens when you turn SQL Server’s page verification feature off. Brent Ozartutorial [HopFS: Scaling Hierarchical File System Metadata using NewSQL Databases](https://blog.acolyer.org/2017/03/06/hopfs-scaling-hierarchical-file-system-metadata-using-newsql-databases/?utm_source=dbweekly&utm_medium=email) the morning paperstory [An Afternoon of Code Golf to Achieve 4x Performance in Redis](https://amplitude.engineering/an-afternoon-of-code-golf-in-lua-to-achieve-4x-performance-in-redis-cd631268f25?utm_source=dbweekly&utm_medium=email) Kurt Norwoodstory [Running Spark SQL CERN Queries 5x Faster on SnappyData](http://www.snappydata.io/blog/running-spark-sql-cern-queries-5x-faster-on-snappydata?utm_source=dbweekly&utm_medium=email) Sudhir Menonstory [Google Cloud Spanner: Our First Impressions](https://opencredo.com/google-spanner-first-look/?utm_source=dbweekly&utm_medium=email) David Borsosopinion [SQL Source Control: track each change to your SQL Server database](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change_v2&utm_campaign=sqlsourcecontrol&utm_term=email-25709) — Get a full history in your source control system. See who made changes, what they did and why. [See how](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly=displayemail=track_every_change_v2=sqlsourcecontrol=email-25709) Red Gatesponsored [Trilogy: A New Database Agnostic SQL-based Testing Framework](http://engineering.pivotal.io/post/trilogy-the-sql-testing-framework/?utm_source=dbweekly&utm_medium=email) Konstantin Semenovtools    

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