Issue 168 — August 18, 2017
How Hardware Drives The Shape Of Databases To Come — A catch up with database pioneer Michael Stonebraker on what new compute, storage and networking technologies mean for the future of databases.
Timothy Prickett Morgan opinion
SQLCheck: Automatically Identify Anti-Patterns in SQL Queries — A tool that works with multiple SQL dialects and looks for common anti-patterns that lead to performance problems.
Joy Arulraj tools
AWS Glue: A New Extract, Transfer, and Load (ETL) Service — A new managed service from AWS for ETL jobs. Uses Spark under the hood and in one region only for now.
Amazon Web Services, Inc. tools
State of Production Database Performance 2017 — In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other.
VividCortex sponsored
A Primer on Database Replication — Increasing speed and resilience is great, but there are also costs and complexity associated with replicating databases, as explored here.
AlphaSights Engineering tutorial
Migrating 1200 Databases From MySQL to Postgres — A company had a separate DB for each user so moving to Postgres demanded serious care.
Gabriel Garrido Calvo story
PostgreSQL Gets a Fix for a Passwordless Authentication Flaw — Newly released versions of PostgreSQL fix three security vulnerabilities and over 50 other bugs.
Lucian Constantin news
Migrating Existing Datastores from Redis to ElastiCache — How an app with over one million users moved from regular Redis over to AWS ElastiCache.
Nishant Gupta story
TechCrunch news
20ドル Free on a new Linode account — Linux cloud hosting starting at 1GB of RAM for 5ドル/mo. Use promo code DB20 for 20ドル credit.
Linode Cloud Hosting sponsored
Data Modelling a Clinic Management System — The latest in Vertabelo’s data modelling series.
Emil Drkušić tutorial
Brandur Leach tutorial
Google Cloud Platform Blog tutorial
How Pippa Built a Data Pipeline for 400 Million Podcast listens — ... and cut its AWS bill in half while using Lambda and Kinesis Firehose.
Pippa story
Datanami story
Building a Stack Overflow Clone with Dgraph and React — Dgraph is a fast, distributed graph database system.
Sung Won Cho story
Eventn - Data Processing Microservices — Connect directly to a database and deploy RESTful services for ETL, SQL analytics or data processing.
Eventn sponsored
Piotr Kononow opinion
SQLite: The Universal SQL Database Engine — It’s the most widely deployed database of all.
Linode opinion
Yang Wang opinion
appbase tools