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 Web Services news
Microsoft Azure 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
Amazon Web Services tutorial
Amazon Web Services tutorial
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
Hyperia s.r.o. code