---
title: "#168: How Hardware Drives The Shape Of Databases To Come"
publication: "DB Weekly"
issue: 168
published_at: "2017-08-18"
canonical_url: "https://dbweekly.com/issues/168"
---

Database Weekly 168   

This week's database news -[Read this on the Web](http://dbweekly.com/issues/168) 

[Database Weekly](http://dbweekly.com) Issue 168 — August 18, 2017     

[How Hardware Drives The Shape Of Databases To Come](https://www.nextplatform.com/2017/08/15/hardware-drives-shape-databases-come/?utm_source=dbweekly&utm_medium=email) — A catch up with database pioneer Michael Stonebraker on what new compute, storage and networking technologies mean for the future of databases. Timothy Prickett Morganopinion [SQLCheck: Automatically Identify Anti-Patterns in SQL Queries](https://github.com/jarulraj/sqlcheck?utm_source=dbweekly&utm_medium=email) — A tool that works with multiple SQL dialects and looks for common anti-patterns that lead to performance problems. Joy Arulrajtools [AWS Glue: A New Extract, Transfer, and Load (ETL) Service](https://aws.amazon.com/about-aws/whats-new/2017/08/introducing-aws-glue-a-simple-flexible-and-cost-effective-extract-transfer-and-load-etl-service/?utm_source=dbweekly&utm_medium=email) — 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](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production) — In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other. VividCortexsponsored [![\](https://copm.s3.amazonaws.com/8c7a4db6.png)](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production) [A Primer on Database Replication](https://m.alphasights.com/a-primer-on-database-replication-381b319cd032?utm_source=dbweekly&utm_medium=email) — Increasing speed and resilience is great, but there are also costs and complexity associated with replicating databases, as explored here. AlphaSights Engineeringtutorial [Migrating 1200 Databases From MySQL to Postgres](http://psyenix.blogspot.com/2017/08/migrating-1200-db-from-mysql-to-postgres.html?utm_source=dbweekly&utm_medium=email) — A company had a separate DB for each user so moving to Postgres demanded serious care. Gabriel Garrido Calvostory [PostgreSQL Gets a Fix for a Passwordless Authentication Flaw](https://thenewstack.io/passwordless-authentication-flaw-fixed-postgresql/?utm_source=dbweekly&utm_medium=email) — Newly released versions of PostgreSQL fix three security vulnerabilities and over 50 other bugs. Lucian Constantinnews [Migrating Existing Datastores from Redis to ElastiCache](http://engineering.grab.com/migrating-existing-datastores?utm_source=dbweekly&utm_medium=email) — How an app with over one million users moved from regular Redis over to AWS ElastiCache. Nishant Guptastory [MongoDB Has Filed Confidentially For IPO?](https://techcrunch.com/2017/08/15/database-provider-mongodb-has-filed-confidentially-for-ipo/?ncid=rss&utm_source=dbweekly&utm_medium=email) TechCrunchnews [$20 Free on a new Linode account](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Linux cloud hosting starting at 1GB of RAM for $5/mo. Use promo code DB20 for $20 credit. Linode Cloud Hostingsponsored [Data Modelling a Clinic Management System](http://www.vertabelo.com/blog/technical-articles/clinic-management-system-data-model?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s data modelling series. Emil Drkušićtutorial [How Postgres Makes Transactions Atomic](https://brandur.org/postgres-atomicity?utm_source=dbweekly&utm_medium=email) Brandur Leachtutorial [How to Analyze Fastly Real-Time Streaming Logs with BigQuery](http://cloudplatform.googleblog.com/2017/08/how-to-analyze-Fastly-real-time-streaming-logs-with-BigQuery.html?utm_source=dbweekly&utm_medium=email) Google Cloud Platform Blogtutorial [How Pippa Built a Data Pipeline for 400 Million Podcast listens](https://medium.com/bytes-by-pippa/how-pippa-built-a-data-pipeline-for-400-million-podcast-listens-f7af6b43f26e?utm_source=dbweekly&utm_medium=email) — … and cut its AWS bill in half while using Lambda and Kinesis Firehose. Pippastory [The 3 Roles Needed for the Modern Data Team](https://www.datanami.com/2017/08/16/3-roles-needed-modern-data-team/?utm_source=dbweekly&utm_medium=email) Datanamistory [Building a Stack Overflow Clone with Dgraph and React](https://blog.dgraph.io/post/building-graphoverflow/?utm_source=dbweekly&utm_medium=email) — Dgraph is a fast, distributed graph database system. Sung Won Chostory [Eventn - Data Processing Microservices](https://eventn.com?utm_source=dbweekly&utm_medium=email) — Connect directly to a database and deploy RESTful services for ETL, SQL analytics or data processing. Eventnsponsored [9 Reasons Why There Are No Foreign Keys in Your Database](https://dataedo.com/blog/why-there-are-no-foreign-keys-in-your-database-referential-integrity-checks?utm_source=dbweekly&utm_medium=email) Piotr Kononowopinion [SQLite: The Universal SQL Database Engine](https://medium.com/linode-cube/sqlite-the-universal-sql-database-engine-a26199c366fc?utm_source=dbweekly&utm_medium=email) — It’s the most widely deployed database of all. Linodeopinion [SQLite vs MySQL vs PostgreSQL: An RDBMS Comparison](https://medium.com/@yangforbig/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems-afd5afd6566?utm_source=dbweekly&utm_medium=email) Yang Wangopinion [Dejavu 1.0: The Missing Web UI for Elasticsearch](https://github.com/appbaseio/dejavu/releases/1.0.0?utm_source=dbweekly&utm_medium=email) appbasetools    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/168) [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