Issue 145 — March 10, 2017
Many SQL Perf Problems Stem from “Unnecessary, Mandatory Work”
— Many ORMs and query builders will do wasteful things like
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).
Google Cloud Platform
MongoDB's Hosted MongoDB Service Gets A Free Tier
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 $50M to Continue Growing Commercial Arm of Apache Kafka
Amazon RDS – 2016 in Review
Amazon Web Services
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
the morning paper
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.
Trilogy: A New Database Agnostic SQL-based Testing Framework