#175: Ten Cool SQL Optimisations

This week's database news - Read this on the Web

Database Weekly Issue 175 — October 6, 2017

Streams: A New General Purpose Data Structure for Redis — The creator of Redis looks at the use cases for streams and how they’re going to become available in Redis. Salvatore Sanfilippo   news   Scaling GitLab's Database — GitLab is a popular git repository host, and this is an in-depth look at the challenges faced scaling their Postgres setup. Yorick Peterse   story   A Journey From Redis 2 to Redis 3 Without Site Downtime — How a major gaming site managed to upgrade its Redis databases from version 2 to 3 without any downtime. Craig Stewart   story   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   sponsored   10 Cool SQL Optimisations That Do Not Depend On The Cost Model — A collection of simple optimisations that can be implemented purely based on metadata (e.g. constraints) and the query itself. JOOQ   tutorial   PostgreSQL 10 Released — The popular open source database includes native logical replication, declarative table partitioning, and improved query parallelism. More on what’s new here. Postgres.​org   news   Introducing Cloud Firestore: Google's New Document Database for Apps — A fully-managed NoSQL document database for mobile and web app development. Alex Dufetel   news   Technical Product Management Like a Boss: Craig Kerstiens — An interesting interview with Craig Kerstiens of Citus Data (who also curates our Postgres newsletter) on why every product manager should learn SQL, how Citus Data is taking advantage of some new PostgreSQL features, and more. Max Mautner   video   MongoDB on Building a Global Database-as-a-Service — The product manager of MongoDB’s Atlas hosted service briefly explains how it was built on AWS. Andrew Davidson   video   One Million Tables in MySQL 8.0 — Creating one million tables in MySQL and testing the performance. Alexander Rubin   story   Serverless Database Computing with Azure Functions and Cosmos DB — Learn how Azure Cosmos DB (MS’s globally distributed multi-model database) and Azure Functions can be used together to create event-driven serverless computing apps. Microsoft Azure   tutorial   HoTTSQL: Proving Query Rewrites with Univalent SQL Semantics — A look at a paper covering a technique for proving that rewritten, optimized SQL queries maintain the semantics of the original query. the morning paper   story   Amazon EC2 Instances Now Support Microsoft SQL Server 2017 Amazon Web Services   news   New Azure VM Images for SQL Server 2017 on Linux and Windows Microsoft Azure   news   Alibaba Is Leading A $27M Investment in Open Source Database Startup MariaDB Jon Russell   news   Performance Analytics for Amazon Redshift — When it comes to Amazon Redshift, there’s an elephant in the room. Everyone is struggling. intermix.​io   sponsored   Migrating a SQL Server Database to a MySQL-Compatible Database Engine Amazon Web Services   tutorial   Preprocessing Data in Amazon Kinesis Analytics with AWS Lambda Amazon Web Services   tutorial   Different I/O Access Methods in Linux and What We Chose for ScyllaDB Avi Kivity   story   HumongouS.io: A universal admin interface for MongoDB — Generate an enterprise grade admin interface for your MongoDB database with support for joins, smart forms & charts. HumongouS.​io   sponsored   memcache-info: A Simple Way to Show Information About Memcache Hyperia s.​r.​o.​   code   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK