#201 — April 27, 2018

Read on the Web

Database Weekly

Using SQL to Query Kafka, MongoDB, MySQL, PostgreSQL and Redis with PrestoPresto is a distributed SQL query engine by Facebook that can connect to other data sources, as demonstrated here.

Mark Litwintschik

ClusterControl 1.6: Automation and Management of Open Source Databases in the Cloud — Supports deployments of MySQL, MariaDB, MongoDB, and PostgreSQL clusters on AWS, Azure and Google Cloud.

Severalnines

Linux Cloud Hosting Starting at 1GB of RAM for $5/mo — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you’re ready to deploy your server. Get $20 credit on a new account.

Linode Cloud Hosting sponsor

Google's BigQuery Gaining Steam As Cloud Warehouse Wars Heat Up — BigQuery is catching up quickly with cloud data warehouse king Amazon Redshift, while Microsoft and others have plans of their own.

Datanami

Cloud Analytics Engines Falling Short, Survey Finds — Apparently the cloud the best place to run large analytics workloads but at the same time, people are saying the scale isn’t quite there.

Datanami

'Yes, I'm Forking Redis' — A developer explains why he’s forking popular data structure server Redis to add native TLS support and transactions in Redis Lua scripts.

Josiah Carlson

One Giant Leap For SQL: MySQL 8.0 Released — We mentioned the launch last week but this is a neat roundup of what’s new in case you missed it.

Markus Winand

▶  Using AWS Snowball Edge and AWS DMS for Database Migration — AWS’ Snowball is a 100TB drive they send out to you so you can easily migrate data to AWS. It’s interesting to see the practicalities of the process here.

Amazon Web Services

Google Cloud MemoryStore (Almost) In Beta — Cloud Memorystore provides a fully managed in-memory data store service and is gaining Redis support next month.

Google Cloud

NoSQL Database Company ScyllaDB Raises $10 Million Series C — ScyllaDB is a performance-focused drop-in replacement for Cassandra.

Jason D. Rowley

Amazon EC2 Now Offers AMIs for Microsoft SQL Server on Ubuntu and Amazon Linux 2

Amazon Web Services, Inc.

Get Optimised MongoDB Query Performance with Studio 3T — Read the latest article in our tutorial series on MongoDB performance which focuses on the Profiler and more.

Studio 3T sponsor

How To Index Your Database — Think you knew about indexes, the slides from this recent talk may still teach you a thing or two.

Baron Schwartz

An Overview of Database Indexing for MongoDB

Akash Kathiriya

A Quick Start Guide to MySQL 8.0's Document Store — Based around using the Node.js connector.

Rui Quelhas

Anonymising Email Addresses for GDPR and Safe Development — A simple SQL statement to update a user table.

Pete Graham

▶  Video: Learn How to Design Open Source DBs for HA

Severalnines sponsor

Ask Reddit: What's The Best Database for A Chat Application? — A variety of answers here ranging from Cassandra (certainly the favorite) and Postgres to Redis and SQLite(!)

Reddit

SleekDB: A 30Kb Document Database for PHP — Pretty simple but may be useful for PHP scenarios.

Kazi Hasan