DB Weekly Issue 145: March 10, 2017

Many SQL Perf Problems Stem from "Unnecessary, Mandatory Work" — Many ORMs and query builders will do wasteful things like SELECT * by default, but it can go a lot further than that.

Google Cloud SQL for PostgreSQL: Fully Managed Postgres on GCP — A beta release but it’ll be available for all Google Cloud users on Monday (March 13).

MongoDB's Hosted MongoDB Service Gets A Free Tier — 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.

Performance Dashboard for Redis — RedisMonitor's interactive visual map of your Redis memory makes it easy to find out why. Starts at just 7ドル per month.

How Modern SQL Databases Come Up with Algorithms You Never Dreamed Of — 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.

Acra: An Open Source Postgres Protection Suite — 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.

MySQL Backup Backdoor Vulnerability Revealed — By crafting a malicious table name, an attacker can execute arbitrary SQL queries and shell commands if the dump file is imported.

What's In the Pipeline for Apache Spark? — Apache Spark creator Matei Zaharia promises Spark will see a variety of new features and enhancements this year, including a standard binary data format.

ScyllaDB Closes 16ドル Million in Funding to Expand Next-Gen Cassandra DB

Confluent Raises 50ドルM to Continue Growing Commercial Arm of Apache Kafka

Amazon RDS – 2016 in Review

How Kafka Redefined Data Processing for the Streaming Age

Google Is Acquiring Data Science Community Kaggle

Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for 20ドル credit

Parsing Addresses in PostgreSQL using the 'address_standardizer' Extension — A project from the PostGIS project that can break an address into its component parts.

Impress Your Coworkers With the NATURAL FULL OUTER JOIN

High-Availability with Redis Sentinels Connecting to Master/Slave

Let's Corrupt a SQL Server Database Together — Mostly a look at what happens when you turn SQL Server’s page verification feature off.

HopFS: Scaling Hierarchical File System Metadata using NewSQL Databases

An Afternoon of Code Golf to Achieve 4x Performance in Redis

Running Spark SQL CERN Queries 5x Faster on SnappyData

Google Cloud Spanner: Our First Impressions

SQL Source Control: track each change to your SQL Server database — Get a full history in your source control system. See who made changes, what they did and why. See how

Trilogy: A New Database Agnostic SQL-based Testing Framework