---
title: "This week's database news, issue 143"
publication: "DB Weekly"
issue: 143
published_at: "2017-02-24"
canonical_url: "https://dbweekly.com/issues/143"
---

Database Weekly 143   . 

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

[Database Weekly](http://dbweekly.com) Issue 143 — February 24, 2017     

Featured [Google Spanner Inspires CockroachDB To Outrun It](https://www.nextplatform.com/2017/02/22/google-spanner-inspires-cockroachdb-outrun/?utm_source=dbweekly&utm_medium=email) — 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 Morganopinion [Data Opportunities Slipping Through the Cracks](https://www.datanami.com/2017/02/21/data-opportunities-slipping-cracks/?utm_source=dbweekly&utm_medium=email) — 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. Datanamiopinion [Redis on the Raspberry Pi: Adventures in Unaligned Lands](http://antirez.com/news/111?utm_source=dbweekly&utm_medium=email) — 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. Salvatore Sanfilippostory [Practical Scalability Analysis with the Universal Scalability Law](https://www.vividcortex.com/resources/universal-scalability-law/?utm_campaign=DB%20Weekly&utm_source=ppc) — 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. VividCortexsponsored [![\](https://copm.s3.amazonaws.com/dbab68f3.png)](https://www.vividcortex.com/resources/universal-scalability-law/?utm_campaign=DB%20Weekly&utm_source=ppc) [Processing a 'Trillion Rows' Per Second on a Single Machine.. Or Not](https://databricks.com/blog/2017/02/16/processing-trillion-rows-per-second-single-machine-can-nested-loop-joins-fast.html?utm_source=dbweekly&utm_medium=email) — _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 Raducanustory [Redash: Easily Visualize and Share Data from Any Source](https://github.com/getredash/redash?utm_source=dbweekly&utm_medium=email) — An open source alternative to traditional BI suites built up of a sandbox-style environment for SQL queries and a dashboard/visualization tool. Arik Fraimovichtools [How PostgreSQL Is Tested](http://blog.pgconf.us/2017/02/how-postgresql-is-tested.html?utm_source=dbweekly&utm_medium=email) — 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. Joshua Drakevideo [How to Plan and Run Events: An Event Management Data Model](http://www.vertabelo.com/blog/technical-articles/how-to-plan-and-run-events-an-event-management-data-model?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s relational data modelling series. Vertabelotutorial In brief [SQL Server 2016 Developer Edition Now Available in Windows Containers](https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/02/21/sql-server-2016-developer-edition-in-windows-containers/?utm_source=dbweekly&utm_medium=email) Microsoftnews [DataLayer 2017 Conference, Call for Speakers (Austin, TX on May 17)](https://www.compose.com/articles/datalayer-2017-call-for-speakers/?utm_source=dbweekly&utm_medium=email) Composenews [Four Ways to Visualize Big Streaming Data Now](https://www.datanami.com/2017/02/22/four-ways-visualize-big-streaming-data-now/?utm_source=dbweekly&utm_medium=email) Datanaminews [Forrester: Why Application Monitoring Needs Better Database Monitoring](https://www.brighttalk.com/webcast/15241/247903?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=247903) — Hear expert tips on how to fill the gap between APM and the rapidly changing data layer. SelectStarsponsored [Using R with Databases: A Free Course](https://bigdatauniversity.com/courses/using-r-with-databases/?utm_source=dbweekly&utm_medium=email) Big Data University [The Unofficial MySQL 8.0 Optimizer Guide](http://www.unofficialmysqlguide.com/?utm_source=dbweekly&utm_medium=email) Morgan Tockertutorial [Upgrading your MySQL Server Farm](http://mysqlserverteam.com/upgrading-your-mysql-server-farm/?utm_source=dbweekly&utm_medium=email) — A thorough look at what’s involved in upgrading a set of MySQL servers. Geir Hoydalsviktutorial [Real Time Delivery Updates with Slack, MongoDB Atlas & Tailable Cursors](https://medium.com/@nparsons08/real-time-delivery-updates-with-slack-mongodb-atlas-tailable-cursors-802b08b2c6c4?utm_source=dbweekly&utm_medium=email) — Creating a custom Slack chat bot using Node.js, MongoDB Atlas, and MongoDB Compass. Nick Parsonstutorial [Aggregations in MongoDB by Example](https://www.compose.com/articles/aggregations-in-mongodb-by-example/?utm_source=dbweekly&utm_medium=email) John O'Connortutorial [An Idiot’s Guide to Fulltext Search in PostgreSQL](https://lo.calho.st/databases/an-idiots-guide-to-fulltext-search-in-postgresql/?utm_source=dbweekly&utm_medium=email) Travis Micktutorial [Users Table Mutations: 3 Ways of Building and Altering a 'Users' Table](https://hackernoon.com/users-table-mutations-209fa19412d6?utm_source=dbweekly&utm_medium=email) Raphael Httutorial [Get Instant REST APIs for Your Database](https://www.dreamfactory.com/signup?utm_campaign=signup-022417&utm_content=dbweekly&utm_medium=exernal-cooper&utm_source=email&utm_term=db) — DreamFactory turns your database into a comprehensive REST API. Free and open source, [try it now.](https://www.dreamfactory.com/signup?utm_campaign=signup-022417&utm_content=dbweekly&utm_medium=exernal-cooper&utm_source=email=db) DreamFactorysponsored [Testing MongoDB 3.4's Linearizable Reads with Jepsen](https://engineering.mongodb.com/post/testing-linearizability-with-jepsen-and-evergreen-call-me-continuously/?utm_source=dbweekly&utm_medium=email) The MongoDB Engineering Journalstory [Why LINQ Beats SQL](https://www.linqpad.net/WhyLINQBeatsSQL.aspx?utm_source=dbweekly&utm_medium=email) Joseph Albahariopinion [Neo4j vs Dgraph Benchmarks](https://open.dgraph.io/post/benchmark-neo4j/?utm_source=dbweekly&utm_medium=email) — Interesting results though take note the source is Dgraph themselves. Pawan Rawalopinion [An Introduction to the MongoDB Database Profiler](https://www.pythian.com/blog/an-introduction-to-the-mongodb-database-profiler/?utm_source=dbweekly&utm_medium=email) Fernando Ipartools [OmniDB 1.6.5: A Web-Based Tool for Database Management and Conversion](https://github.com/OmniDB/OmniDB?utm_source=dbweekly&utm_medium=email) Rafael Thofehrn Castrotools [A SQLite3 Persistence Layer for Gun](https://github.com/gundb/sqlite?utm_source=dbweekly&utm_medium=email) — [Gun](https://github.com/amark/gun) is a decentralized, ‘offline first’ JavaScript graph database. github.​comcode    

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