---
title: "This week's database news, issue 125"
publication: "DB Weekly"
issue: 125
published_at: "2016-10-07"
canonical_url: "https://dbweekly.com/issues/125"
---

Database Weekly 125   . 

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

[Database Weekly](http://dbweekly.com) Issue 125 — October 7, 2016     

Featured [Data Denormalization Is Broken](https://hackernoon.com/data-denormalization-is-broken-7b697352f405?utm_source=dbweekly&utm_medium=email) — Why it’s hard to write good app-layer code for everyday business logic. _“I think the database is overdue for a paradigm shift in the way it handles denormalization. I predict powerful denormalization engines will be invented in the next few years.”_ Liron Shapiraopinion [Neural Redis: Neural Networks Module for Redis](https://github.com/antirez/neural-redis?utm_source=dbweekly&utm_medium=email) — A module that implements feed-forward neural networks as a native data type in Redis. The goal is to provide a simple way for anyone to get started with machine learning. Salvatore Sanfilippocode [Why You Should Design Your Database to Optimize for Statistics](https://blog.jooq.org/2016/10/05/why-you-should-design-your-database-to-optimise-for-statistics/?utm_source=dbweekly&utm_medium=email) — Databases are increasingly being used to collect together aggregate data, histograms and overall statistics. Keep this in mind when designing things. JOOQtutorial [How can you help your team write better, shareable SQL faster?](http://www.red-gate.com/products/sql-development/sql-prompt/resources/?utm_source=dbweekly&utm_medium=displayemail&utm_content=stop_bad_sql_1&utm_campaign=sqlprompt&utm_term=email-25069) — Learn more with our free video tips that show how SQL Prompt lets you write, refactor, and share SQL. An add-in for SQL Server Management Studio and Visual Studio, it strips away the repetition of coding and standardizes it everywhere. Red Gatesponsored [![\](https://copm.s3.amazonaws.com/bd8467b2.png)](http://www.red-gate.com/products/sql-development/sql-prompt/resources/?utm_source=dbweekly&utm_medium=displayemail&utm_content=stop_bad_sql_1&utm_campaign=sqlprompt&utm_term=email-25069) [RethinkDB Is Shutting Down](https://rethinkdb.com/blog/rethinkdb-shutdown/?utm_source=dbweekly&utm_medium=email) — The business behind RethinkDB, an innovative open source realtime database, is closing down and its employees moving to Stripe. The project will live on as open source, however. RethinkDBnews [Lessons From MySQL Database Failure](https://www.youtube.com/watch?v=OSY79Mo9YSw&index=8&list=PLK4VB0cauli5wibROcQI75n18FVzkDR2B&utm_source=dbweekly&utm_medium=email) — Backups, verification, replication, and database security are covered in this 31-minute talk looking at lessons learnt from MySQL failures at scale. Colin Charlesvideo [Accelerating Slow Databases That Wear People Down](http://www.nextplatform.com/2016/10/05/accelerating-slow-databases-wear-people/?utm_source=dbweekly&utm_medium=email) — A look at how a frustration with database speeds inspired the creator of MapD and how MapD is using various techniques to boost database performance. Timothy Prickett Morganopinion [The Third Age of Data](https://www.datanami.com/2016/10/06/third-age-data/?utm_source=dbweekly&utm_medium=email) — The massive amounts of data being generated hold the promise of ever-greater insight, but only for those who successfully process and harness the flood of information. Jeff Cobbopinion [Debugging PostgreSQL Performance, The Hard Way](https://www.justwatch.com/blog/post/debugging-postgresql-performance-the-hard-way/?utm_source=dbweekly&utm_medium=email) — When JustWatch saw a disproportionate increase in database reads they decided to find out why — instead of just throwing money at the problem. JustWatchstory Jobs [Don't Get Frustrated Job Hunting - Get Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-dbweekly) — Sick of pushy recruiters, and dead end interviews? Try Hired to hear from top tier companies, and only talk to relevant companies. Hired In brief [RethinkDB Needs A New Home](https://docs.google.com/a/cooperpress.com/forms/d/e/1FAIpQLSc1yY2qy25viVc8MiM0XCsyMCpbalgzXrpT3MQAd_d3C1-jhA/viewform?c=0&w=1&utm_source=dbweekly&utm_medium=email) — A form looking for feedback on how RethinkDB should be handled by the open source community. _Note: This form is not managed by the RethinkDB team, but by open source contributors._ google.​comnews [Introducing MariaDB MaxScale 2.0](https://mariadb.com/blog/introducing-mariadb-maxscale-20-ga?utm_source=dbweekly&utm_medium=email) — MaxScale is a database proxy that sits between the application and database layer. MariaDBnews [MySQL 8.0 Labs: JSON Aggregation Functions](http://mysqlserverteam.com/mysql-8-0-labs-json-aggregation-functions/?utm_source=dbweekly&utm_medium=email) Catalin Besleaganews [ScyllaDB now on Compose](https://www.compose.com/articles/getting-started-with-composes-scylladb/?utm_source=cooper&utm_medium=newsletter&utm_content=getting-started-scylladb) — Blazing fast replacement for Cassandra that boasts 1M transactions sec/node. Get ScyllaDB started with your favourite runtimes. Composesponsored [How to Solve 5 Elasticsearch Performance and Scaling Problems](https://www.datadoghq.com/blog/elasticsearch-performance-scaling-problems/?utm_source=dbweekly&utm_medium=email) — Five common Elasticsearch challenges, and how to deal with them. Emily Changtutorial [Working with SQLite Databases using Python and Pandas](https://www.dataquest.io/blog/python-pandas-databases/?utm_source=dbweekly&utm_medium=email) Vik Paruchuritutorial [Pairing LLVM JIT with PostgreSQL Can Speed Up Database Performance](http://www.phoronix.com/scan.php?page=news_item&px=LLVM-JIT-PostgreSQL&utm_source=dbweekly&utm_medium=email) — LLVM JIT is used for just-in-time compilation of queries. Dmitry Melnikvideo [How MongoDB Helps Telefonica Digital Accelerate Time to Market](https://www.mongodb.com/presentations/business-track-how-mongodb-helps-telefonica-digital-accelerate-time-market?jmp=twt&utm_source=dbweekly&utm_medium=email) — Why telecommunications giant Telefonica migrated from Oracle to MongoDB. _37 minutes_. MongoDBvideo [Yandex Mail's Oracle to Postgres Success Story](https://www.youtube.com/watch?v=-SS4R1sFH3c&utm_source=dbweekly&utm_medium=email) YouTubevideo [Has Big Data Peaked?](https://www.datanami.com/2016/10/04/big-data-peaked/?utm_source=dbweekly&utm_medium=email) — Fewer companies are planning to invest in big data projects over the next two years due to concerns over ROI. Alex Woodieopinion [6 Reasons to Choose PostgreSQL 9.6](http://blog.taadeem.net///english/2016/10/01/6_reasons_to_choose_PostgreSQL_9.6?utm_source=dbweekly&utm_medium=email) Damien Clochardopinion [When A Disk Cache Performs Better Than An In-Memory Cache (Befriending The .NET GC)](http://www.productiverage.com/when-a-disk-cache-performs-better-than-an-inmemory-cache-befriending-the-net-gc?utm_source=dbweekly&utm_medium=email) Productive Danstory [Get real-time visibility into dynamic environments with Datadog](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — One-line installation. Two-minute configuration. Total infrastructure observability is a couple clicks away. Datadogsponsored [Mirage: An Online GUI for Writing Elasticsearch Queries](http://appbaseio.github.io/mirage/?utm_source=dbweekly&utm_medium=email) appbaseio.​github.​iotools [elasticsearch_loader: Batch Load Data Files into Elasticsearch](https://github.com/Moshe/elasticsearch_loader?utm_source=dbweekly&utm_medium=email) Moshe Zadatools [ZSON: A PostgreSQL Extension for Transparent JSONB Compression](https://github.com/afiskon/zson?utm_source=dbweekly&utm_medium=email) Aleksander Alekseevcode [pgmigrate: Simple Tool to Evolve PostgreSQL Schemas Easily](https://github.com/yandex/pgmigrate?utm_source=dbweekly&utm_medium=email) — Yandex just completed one of the larger Postgres migrations from MySQL and have now open sourced their tool to make it easier to evolve. Yandexcode    

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