#201 — April 27, 2018
Database Weekly
Using SQL to Query Kafka, MongoDB, MySQL, PostgreSQL and Redis with Presto — Presto 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(!)
SleekDB: A 30Kb Document Database for PHP — Pretty simple but may be useful for PHP scenarios.
Kazi Hasan