#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 |