--- title: "#175: Ten Cool SQL Optimisations" publication: "DB Weekly" issue: 175 published_at: "2017-10-06" canonical_url: "https://dbweekly.com/issues/175" --- Database Weekly 175 This week's database news -[Read this on the Web](http://dbweekly.com/issues/175) [Database Weekly](http://dbweekly.com) Issue 175 — October 6, 2017 [Streams: A New General Purpose Data Structure for Redis](http://antirez.com/news/114?utm_source=dbweekly&utm_medium=email) — The creator of Redis looks at the use cases for streams and how they’re going to become available in Redis. Salvatore Sanfilipponews [Scaling GitLab's Database](https://about.gitlab.com/2017/10/02/scaling-the-gitlab-database/?utm_source=dbweekly&utm_medium=email) — GitLab is a popular git repository host, and this is an in-depth look at the challenges faced scaling their Postgres setup. Yorick Petersestory [A Journey From Redis 2 to Redis 3 Without Site Downtime](http://engineering.skybettingandgaming.com/2017/09/25/redis-2-to-redis-3/?utm_source=dbweekly&utm_medium=email) — How a major gaming site managed to upgrade its Redis databases from version 2 to 3 without any downtime. Craig Stewartstory [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 Hostingsponsored [![\](https://copm.s3.amazonaws.com/27d43618.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [10 Cool SQL Optimisations That Do Not Depend On The Cost Model](https://blog.jooq.org/2017/09/28/10-cool-sql-optimisations-that-do-not-depend-on-the-cost-model/?utm_source=dbweekly&utm_medium=email) — A collection of simple optimisations that can be implemented purely based on metadata (e.g. constraints) and the query itself. JOOQtutorial [PostgreSQL 10 Released](https://www.postgresql.org/about/news/1786/?utm_source=dbweekly&utm_medium=email) — The popular open source database includes native logical replication, declarative table partitioning, and improved query parallelism. [More on what’s new here](https://wiki.postgresql.org/wiki/New_in_postgres_10). Postgres.​orgnews [Introducing Cloud Firestore: Google's New Document Database for Apps](https://firebase.googleblog.com/2017/10/introducing-cloud-firestore.html?utm_source=dbweekly&utm_medium=email) — A fully-managed NoSQL document database for mobile and web app development. Alex Dufetelnews [Technical Product Management Like a Boss: Craig Kerstiens](https://theaccidentalengineer.com/technical-product-management-craig-kerstiens-citus-db/?utm_source=dbweekly&utm_medium=email) — An interesting interview with Craig Kerstiens of Citus Data (who also curates [our Postgres newsletter](https://postgresweekly.com/)) on why every product manager should learn SQL, how Citus Data is taking advantage of some new PostgreSQL features, and more. Max Mautnervideo [MongoDB on Building a Global Database-as-a-Service](https://www.youtube.com/watch?v=vHuIFM9cyik&utm_source=dbweekly&utm_medium=email) — The product manager of MongoDB’s _Atlas_ hosted service briefly explains how it was built on AWS. Andrew Davidsonvideo [One Million Tables in MySQL 8.0](https://www.percona.com/blog/2017/10/01/one-million-tables-mysql-8-0/?utm_source=dbweekly&utm_medium=email) — Creating one million tables in MySQL and testing the performance. Alexander Rubinstory [Serverless Database Computing with Azure Functions and Cosmos DB](https://docs.microsoft.com/en-us/azure/cosmos-db/serverless-computing-database?utm_source=dbweekly&utm_medium=email) — 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 Azuretutorial [HoTTSQL: Proving Query Rewrites with Univalent SQL Semantics](https://blog.acolyer.org/2017/10/05/hottsql-proving-query-rewrites-with-univalent-sql-semantics/?utm_source=dbweekly&utm_medium=email) — A look at a paper covering a technique for proving that rewritten, optimized SQL queries maintain the semantics of the original query. the morning paperstory [Amazon EC2 Instances Now Support Microsoft SQL Server 2017](https://aws.amazon.com/about-aws/whats-new/2017/10/amazon-ec2-instances-now-support-microsoft-sql-server-2017/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [New Azure VM Images for SQL Server 2017 on Linux and Windows](https://azure.microsoft.com/en-us/blog/announcing-new-azure-vm-images-sql-server-2017-on-linux-and-windows/?utm_source=dbweekly&utm_medium=email) Microsoft Azurenews [Alibaba Is Leading A $27M Investment in Open Source Database Startup MariaDB](https://techcrunch.com/2017/09/29/alibaba-mariadb/?utm_source=dbweekly&utm_medium=email) Jon Russellnews [Performance Analytics for Amazon Redshift](https://www.intermix.io/dbweekly) — When it comes to Amazon Redshift, there’s an elephant in the room. Everyone is struggling. intermix.​iosponsored [Migrating a SQL Server Database to a MySQL-Compatible Database Engine](https://aws.amazon.com/blogs/database/migrating-a-sql-server-database-to-a-mysql-compatible-database-engine/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicestutorial [Preprocessing Data in Amazon Kinesis Analytics with AWS Lambda](https://aws.amazon.com/blogs/big-data/preprocessing-data-in-amazon-kinesis-analytics-with-aws-lambda/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicestutorial [Different I/O Access Methods in Linux and What We Chose for ScyllaDB](http://www.scylladb.com/2017/10/05/io-access-methods-scylla/?utm_source=dbweekly&utm_medium=email) Avi Kivitystory [HumongouS.io: A universal admin interface for MongoDB](https://www.humongous.io/) — Generate an enterprise grade admin interface for your MongoDB database with support for joins, smart forms & charts. HumongouS.​iosponsored [memcache-info: A Simple Way to Show Information About Memcache](https://github.com/hyperia-sk/memcache-info?utm_source=dbweekly&utm_medium=email) Hyperia s.​r.​o.​ code Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/175) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK