---
title: "Google's BigQuery Gaining Steam As Cloud Warehouse Wars Heat Up"
publication: "DB Weekly"
issue: 201
published_at: "2018-04-27"
canonical_url: "https://dbweekly.com/issues/201"
---

This week's database news       

#201 — April 27, 2018 

[Read on the Web](https://dbweekly.com/issues/201)   

Database Weekly  

[Using SQL to Query Kafka, MongoDB, MySQL, PostgreSQL and Redis with Presto](http://tech.marksblogg.com/presto-connectors-kafka-mongodb-mysql-postgresql-redis.html) — [Presto](https://prestodb.io/) 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](https://severalnines.com/blog/announcing-clustercontrol-16-automation-and-management-open-source-databases-cloud) — Supports deployments of MySQL, MariaDB, MongoDB, and PostgreSQL clusters on AWS, Azure and Google Cloud. 

Severalnines   [![\](https://copm.s3.amazonaws.com/d548b423.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) 

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — 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](https://www.datanami.com/2018/04/24/googles-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](https://www.datanami.com/2018/04/24/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'](http://www.dr-josiah.com/2018/04/yes-im-forking-redis-ssltls-transactions.html) — 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](https://modern-sql.com/blog/2018-04/mysql-8.0) — 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](https://www.youtube.com/watch?v=6Hw--HE8ILg) — 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](https://cloud.google.com/memorystore/) — 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](https://news.crunchbase.com/news/nosql-database-company-scylladb-raises-10-million-series-c-led-tlv-partners/) — 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](https://aws.amazon.com/about-aws/whats-new/2018/04/amazon-ec2-now-offers-microsoft-sql-server-on-ubuntu-and-amazon-linux-2-amis/) 

Amazon Web Services, Inc.   

[Get Optimised MongoDB Query Performance with Studio 3T](https://studio3t.com/whats-new/mongodb-query-performance/?utm_source=dbweekly&utm_medium=newsletter&utm_campaign=april2018) — 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](https://www.xaprb.com/talks/index-postgresql-database-postgresconf-2018/) — 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](https://severalnines.com/blog/overview-database-indexing-mongodb) 

Akash Kathiriya   

[A Quick Start Guide to MySQL 8.0's Document Store](https://insidemysql.com/mysql-document-store-crud-quick-start/) — Based around using the Node.js connector. 

Rui Quelhas   

[Anonymising Email Addresses for GDPR and Safe Development](http://petegraham.co.uk/anonymising-user-emails-with-sql-in-postgres/) — A simple SQL statement to update a user table. 

Pete Graham   

▶[Video: Learn How to Design Open Source DBs for HA](https://severalnines.com/resources/webinars/designing-open-source-databases-high-availability?utm_campaign=Infrastructure_Campaign_APR_2018&utm_content=replay&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[Ask Reddit: What's The Best Database for A Chat Application?](https://www.reddit.com/r/Database/comments/8dpgyv/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](https://sleekdb.github.io/) — Pretty simple but may be useful for PHP scenarios. 

Kazi Hasan         

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom