#168: How Hardware Drives The Shape Of Databases To Come

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

Database Weekly 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   MongoDB Has Filed Confidentially For IPO? 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   How Postgres Makes Transactions Atomic Brandur Leach   tutorial   How to Analyze Fastly Real-Time Streaming Logs with BigQuery 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   The 3 Roles Needed for the Modern Data Team 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   9 Reasons Why There Are No Foreign Keys in Your Database Piotr Kononow   opinion   SQLite: The Universal SQL Database Engine — It’s the most widely deployed database of all. Linode   opinion   SQLite vs MySQL vs PostgreSQL: An RDBMS Comparison Yang Wang   opinion   Dejavu 1.0: The Missing Web UI for Elasticsearch appbase   tools   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