DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 71 — September 18, 2015
Featured
Benchmarking Aurora vs MySQL: Is Amazon’s New DB 5x Faster? — 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)? — “We have precise definitions for other normal forms and there is no generally accepted definition of 1NF.”
Konrad Zdanowski    tutorial   
The Magic of SQL: The 4 Jacks — The ‘SQL Wizard’ takes a database-leaning look at an old card trick, uses SQL to replicate it, and then shows some practical applications.
YouTube    video   
VividCortex - the New Face of Database Monitoring — 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 Cortex    sponsored   
Pinterest Open-sources Terrapin, A Tool for Serving Data From Hadoop — 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 — A look at creating the logical model for a problem or “bug” reporting system.
Andrew Wolfe    tutorial   
Bye Bye MySQL and MongoDB. Guten Tag PostgreSQL — 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.
Userlike    opinion   
Heroku Data Links with Postgres and Redis — 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 — “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.”
AverageSecurityGuy    tutorial   
In brief
Intel Exec: Extracting Value From Big Data Remains Elusive
Datanami    news   
PostgreSQL for MySQL Administrators
Daniel Hauck    tutorial   
Finding The Salt with SQL Inception — A look at how Duncan, a blind SQL injector skeleton, was used to perform an SQL injection exploit.
Silent Signal Techblog    tutorial   
Deep Dive SQL Workload Analysis using pt-query-digest — Part of a ‘Become a MySQL DBA’ blog series.
Severalnines    tutorial   
SQL in CockroachDB: Mapping Table Data to Key-Value Storage
Cockroach Labs    tutorial   
Setting Up A Data Warehouse with AWS Redshift and Ruby
Credible Labs    tutorial   
Graph Databases for Beginners to Get Started with
Kevin Issac    opinion   
EdgeDB: A Next Generation Object Database — Not yet available but it looks interesting.
MagicStack    tools   
Envelope: A Webapp Dev Platform on top of Postgres — 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 — A key milestone for a library that provides a complete Redis client for Node developers.
NodeRedis    code   
Kingshard: A High-Performance Proxy for MySQL
Chen Fei    code   
« Prev
Next »