Issue 143 — February 24, 2017
Google Spanner Inspires CockroachDB To Outrun It
— In a database market ripe for change, Cockroach has the potential to be Yahoo’s Hadoop and HDFS to Google’s MapReduce and Google File System.
Timothy Prickett Morgan
Data Opportunities Slipping Through the Cracks
— Most companies still struggle to process and analyze the huge amounts of data they have access to, making the database industry ripe for new entrants and new solutions.
Redis on the Raspberry Pi: Adventures in Unaligned Lands
— The creator of Redis talks about how he sees Redis working on the Raspberry Pi and how he’s made them work better together in rich technical detail.
Practical Scalability Analysis with the Universal Scalability Law
— This eBook introduces scalability analysis using Dr. Gunther’s Universal Scalability Law, which models & predicts how systems perform, & illustrates deep truths about scalability. This book outlines why systems fail to scale well & what to do about it.
Processing a 'Trillion Rows' Per Second on a Single Machine.. Or Not
This blog post describes our experience debugging a failing test case caused by a cross join query running “too fast.”
Reynold Xin, Ala Luszczak and Bogdan Raducanu
Redash: Easily Visualize and Share Data from Any Source
— An open source alternative to traditional BI suites built up of a sandbox-style environment for SQL queries and a dashboard/visualization tool.
How PostgreSQL Is Tested
— Want to learn how databases get tested and, in particular, Postgres? This talk from PGConf US digs in to the testing processes the Postgres project uses.
How to Plan and Run Events: An Event Management Data Model
— The latest in Vertabelo’s relational data modelling series.
SQL Server 2016 Developer Edition Now Available in Windows Containers
DataLayer 2017 Conference, Call for Speakers (Austin, TX on May 17)
Four Ways to Visualize Big Streaming Data Now
Forrester: Why Application Monitoring Needs Better Database Monitoring
— Hear expert tips on how to fill the gap between APM and the rapidly changing data layer.
Using R with Databases: A Free Course
Big Data University
The Unofficial MySQL 8.0 Optimizer Guide
Upgrading your MySQL Server Farm
— A thorough look at what’s involved in upgrading a set of MySQL servers.
Real Time Delivery Updates with Slack, MongoDB Atlas & Tailable Cursors
— Creating a custom Slack chat bot using Node.js, MongoDB Atlas, and MongoDB Compass.
Aggregations in MongoDB by Example
An Idiot’s Guide to Fulltext Search in PostgreSQL
Users Table Mutations: 3 Ways of Building and Altering a 'Users' Table
Get Instant REST APIs for Your Database
— DreamFactory turns your database into a comprehensive REST API. Free and open source,
try it now.
Testing MongoDB 3.4's Linearizable Reads with Jepsen
The MongoDB Engineering Journal
Why LINQ Beats SQL
Neo4j vs Dgraph Benchmarks
— Interesting results though take note the source is Dgraph themselves.
An Introduction to the MongoDB Database Profiler
OmniDB 1.6.5: A Web-Based Tool for Database Management and Conversion
Rafael Thofehrn Castro
A SQLite3 Persistence Layer for Gun