---
title: "This week's database news, issue 71"
publication: "DB Weekly"
issue: 71
published_at: "2015-09-18"
canonical_url: "https://dbweekly.com/issues/71"
---

Database Weekly 71   . 

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

[Database Weekly](http://dbweekly.com) Issue 71 — September 18, 2015     

Featured [Benchmarking Aurora vs MySQL: Is Amazon’s New DB 5x Faster?](http://blog.takipi.com/benchmarking-aurora-vs-mysql-is-amazons-new-db-really-5x-faster/?utm_source=dbweekly&utm_medium=email) — Amazon’s Aurora MySQL-compatible database boasts up to a 5x performance increase, but how does it fare in reality? Alex Zhitnitsky [What is the Actual Definition of First Normal Form (1NF)?](http://www.vertabelo.com/blog/technical-articles/what-is-the-actual-definition-of-first-normal-form-1nf?utm_source=dbweekly&utm_medium=email) — “We have precise definitions for other normal forms and there is no generally accepted definition of 1NF.” Konrad Zdanowskitutorial [The Magic of SQL: The 4 Jacks](https://www.youtube.com/watch?v=zgXstJZETm0&utm_source=dbweekly&utm_medium=email) — The ‘SQL Wizard’ takes a database-leaning look at an old card trick, uses SQL to replicate it, and then shows some practical applications. YouTubevideo [VividCortex - the New Face of Database Monitoring](http://t.sidekickopen13.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2F%3Futm_source%3Dpaid%26utm_medium%3Ddbw&si=6148852320567296&pi=5783cdb1-275a-4db4-ffcc-3eff454d2604) — VividCortex is the best way to see what is happening on your production servers. Unlike traditional monitoring, we measure and analyze the system’s work and resource consumption. This leads directly to better performance for IT as a whole, at reduced cost and effort. Vivid Cortexsponsored [![\](https://copm.s3.amazonaws.com/6f0f4bb4.png)](http://t.sidekickopen13.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2F%3Futm_source%3Dpaid%26utm_medium%3Ddbw&si=6148852320567296&pi=5783cdb1-275a-4db4-ffcc-3eff454d2604) [Pinterest Open-sources Terrapin, A Tool for Serving Data From Hadoop](http://venturebeat.com/2015/09/14/pinterest-open-sources-terrapin-a-tool-for-serving-data-from-hadoop/?utm_source=dbweekly&utm_medium=email) — Terrapin is a new piece of open-source software designed to efficiently push data out of Hadoop and make it available for other systems to use. VentureBeat [Tackling Your Troubles – Building a Bug and Problem Database](http://www.vertabelo.com/blog/technical-articles/tackling-your-troubles-building-a-bug-and-problem-database?utm_source=dbweekly&utm_medium=email) — A look at creating the logical model for a problem or “bug” reporting system. Andrew Wolfetutorial [Bye Bye MySQL and MongoDB. Guten Tag PostgreSQL](https://www.userlike.com/en/blog/2015/10/09/bye-by-mysql-and-mongodb-guten-tag-postgresql?utm_source=dbweekly&utm_medium=email) — For a long time MongoDB and MySQL had a leg up on Postgres, one for user experience and the other for well… replication. Postgres has come a long way since those days and now is seen as a replacement for both as shown here. Userlikeopinion [Heroku Data Links with Postgres and Redis](http://blog.codeship.com/heroku-data-links-postgres-redis/?utm_source=dbweekly&utm_medium=email) — Heroku has dramatically simplified the process of using Foreign Data Wrappers with PostgreSQL and Redis via its Data Links feature. Barry Jones [Pentesting Redis Servers](http://averagesecurityguy.info/2015/09/17/pentesting-redis-servers/?utm_source=dbweekly&utm_medium=email) — “By default the Redis server does not require authentication for client access. This is not a problem if Redis is only listening on localhost but often it is not.” AverageSecurityGuytutorial In brief [Intel Exec: Extracting Value From Big Data Remains Elusive](http://www.datanami.com/2015/09/08/intel-exec-extracting-value-from-big-data-remains-elusive/?utm_source=dbweekly&utm_medium=email) Datanaminews [PostgreSQL for MySQL Administrators](https://opslife.org/postgresql-for-mysql-administrators/?utm_source=dbweekly&utm_medium=email) Daniel Haucktutorial [Finding The Salt with SQL Inception](http://blog.silentsignal.eu/2015/09/17/finding-the-salt-with-sql-inception/?utm_source=dbweekly&utm_medium=email) — A look at how [Duncan](https://github.com/silentsignal/duncan), a blind SQL injector skeleton, was used to perform an SQL injection exploit. Silent Signal Techblogtutorial [Deep Dive SQL Workload Analysis using pt-query-digest](http://www.severalnines.com/blog/become-mysql-dba-blog-series-deep-dive-sql-workload-analysis-using-pt-query-digest?utm_source=dbweekly&utm_medium=email) — Part of a ‘Become a MySQL DBA’ blog series. Severalninestutorial [SQL in CockroachDB: Mapping Table Data to Key-Value Storage](http://www.cockroachlabs.com/blog/sql-in-cockroachdb-mapping-table-data-to-key-value-storage/?utm_source=dbweekly&utm_medium=email) Cockroach Labstutorial [Setting Up A Data Warehouse with AWS Redshift and Ruby](https://www.credible.com/code/setting-up-a-data-warehouse-with-aws-redshift-and-ruby/?utm_source=dbweekly&utm_medium=email) Credible Labstutorial [Graph Databases for Beginners to Get Started with](http://graphtutorial.com/database/graph-databases-for-beginners-to-get-started-with?utm_source=dbweekly&utm_medium=email) Kevin Issacopinion [EdgeDB: A Next Generation Object Database](http://edgedb.com/?utm_source=dbweekly&utm_medium=email) — Not yet available but it looks interesting. MagicStacktools [Envelope: A Webapp Dev Platform on top of Postgres](http://envelope.xyz/?utm_source=dbweekly&utm_medium=email) — Envelope is a new approach to building RESTful applications. It provides an app server out of the box that sits in front of your database and provides a direct API for writing JS apps against it. Workflow Products [NodeRedis 1.0 Release: A Node.js Redis Client](https://github.com/NodeRedis/node_redis?utm_source=dbweekly&utm_medium=email) — A key milestone for a library that provides a complete Redis client for Node developers. NodeRediscode [Kingshard: A High-Performance Proxy for MySQL](https://github.com/flike/kingshard?utm_source=dbweekly&utm_medium=email) Chen Feicode    

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