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

Database Weekly 79   . 

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

[Database Weekly](http://dbweekly.com) Issue 79 — November 13, 2015     

Featured [RethinkDB 2.2 Released: The Modern Real-Time Database](http://rethinkdb.com/blog/2.2-release/?utm_source=dbweekly&utm_medium=email) — RethinkDB is an open source with a fresh, modern approach and strong support for live, realtime data streams, time series, and more. 2.2 brings atomic changefeeds and parallel scans to the table. Ryan Paul [Shipping a New Mindset with SQLite in Windows 10](http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/?utm_source=dbweekly&utm_medium=email) — Windows engineers have been working with the SQLite Core Development team led by Richard Hipp to bring SQLite to Windows 10. Engineering @ Microsoft [How to Find the Longest Consecutive Series of Events in SQL](http://blog.jooq.org/2015/11/07/how-to-find-the-longest-consecutive-series-of-events-in-sql/?utm_source=dbweekly&utm_medium=email) — For example, if you want to see which users of a site logged in every day for a certain number of days. A good look at some powerful SQL. jooq [Make Sure Your Servers Are Ready for the Holiday Traffic with VividCortex](http://www.vividcortex.com/resources/#case-studies?utm_source=paid&utm_medium=dbw) — The holidays are upon us, and you want your systems running smoothly. VividCortex allows everyone on your team to see the affects of their code, so you can prevent problems before they happen, and fix them quickly when they do. Read how we have helped others prepare for peak season traffic. Vivid Cortexsponsored [![\](https://copm.s3.amazonaws.com/35d532a0.png)](http://www.vividcortex.com/resources/#case-studies?utm_source=paid&utm_medium=dbw) [What MongoDB Got Right](https://blog.nelhage.com/2015/11/what-mongodb-got-right/?utm_source=dbweekly&utm_medium=email) — This opinion pieces starts “MongoDB is perhaps the most-widely-mocked piece of software out there right now” before looking at what Mongo has got right and how it might ultimately work out in the future. Nelson Elhage [Apache Cassandra 3.0 Released](https://blogs.apache.org/foundation/entry/the_apache_software_foundation_announces82?utm_source=dbweekly&utm_medium=email) — The popular large-scale, high availability, open source DBMS takes a step forward with new features like materialized views. Apache [Is SQL A Good Place for Business Logic?](http://enterprisecraftsmanship.com/2015/11/11/is-sql-a-good-place-for-business-logic/?utm_source=dbweekly&utm_medium=email) — An argument that placing business domain logic in SQL should be avoided as much as possible. Vladimir Khorikov [Percona Server for MongoDB](https://www.percona.com/software/mongo-database/percona-server-for-mongodb?utm_source=dbweekly&utm_medium=email) — A free, enhanced, fully compatible, drop-in replacement for the MongoDB Community Edition that includes enterprise-grade features and functionality. Perconatools In brief [MySQL for Visual Studio 1.2.5 Released](http://insidemysql.com/mysql-for-visual-studio-1-2-5-has-been-released/?utm_source=dbweekly&utm_medium=email) Inside MySQLnews tools [Mobilize SQL Data Using a REST API Backend](https://www.dreamfactory.com/mobilize-sql-data-using-rest-api-backend?utm_source=dbweekly&utm_medium=email&utm_campaign=dbweekly) — DreamFactory automatically generates REST APIs and provides users with a unified REST API services platform, designed expressly with security in mind. DreamFactorytools sponsored [Spotlight On New Capabilities of Azure SQL Database Geo-Replication](https://azure.microsoft.com/en-us/blog/spotlight-on-new-capabilities-of-azure-sql-database-geo-replication/?utm_source=dbweekly&utm_medium=email) Microsoft Azure Blognews [Hadoop Gets a Security Boost from eBay's Eagle](http://www.datanami.com/2015/11/12/hadoop-gets-a-security-boost-from-ebays-eagle/?utm_source=dbweekly&utm_medium=email) — [Eagle](http://goeagle.io/) is an open source data activity monitoring tool running on Hadoop that has just been accepted as an Apache project. Datanaminews [5 Sure-Fire MySQL Tips To Help Speed Up Your Queries](http://www.happyapps.io/blog/2015-10-20-5-sure-fire-mysql-tips-to-help-speed-up-your-queries?utm_source=dbweekly&utm_medium=email) Happy Appstutorial [How to Use mongo-connector with Elasticsearch](https://blog.jixee.me/how-to-use-mongo-connector-with-elasticsearch/?utm_source=dbweekly&utm_medium=email) Jixeetutorial [Concatenating Rows in Redshift, Postgres, and MySQL](https://periscopedata.com/blog//listagg-group-concat-and-string-agg.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Marketing Attribution in SQL](https://periscopedata.com/blog//marketing-attribution-in-sql.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [A Look at Multi-Threaded Replication Performance in MySQL 5.7](http://mysqlhighavailability.com/multi-threaded-replication-performance-in-mysql-5-7/?utm_source=dbweekly&utm_medium=email) MySQL High Availabilityopinion [Designing Your Database: Top 5 Mistakes to Avoid](http://www.dataversity.net/designing-your-database-top-5-mistakes-to-avoid/?utm_source=dbweekly&utm_medium=email) Henrique Netzkaopinion [10 Tips for Beginning Your Big Data Journey](http://www.datanami.com/2015/11/11/10-tips-for-beginning-your-big-data-journey/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [A First Look At RDS Aurora, by a Consultant at Percona](https://www.percona.com/blog/2015/11/02/first-look-rds-aurora/?utm_source=dbweekly&utm_medium=email) Yves Trudeauopinion [Nobody Loves Graphite Anymore](https://www.vividcortex.com/blog/2015/11/05/nobody-loves-graphite-anymore/?utm_source=dbweekly&utm_medium=email) VividCortexopinion [MongoDB and the Shocking Case of the Missing JOIN ($lookup)](http://slamdata.com/blog/2015/10/21/mongodb-missing-join.html?utm_source=dbweekly&utm_medium=email) John A De Goes [white-glove: Scans Databases for Anomalies Worthy of Developer Attention](https://www.npmjs.com/package/white-glove?utm_source=dbweekly&utm_medium=email) — It’s a Node-based tool. Peter Lyonstools [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2015b&utm_content=link&utm_term=seamless%20autoscaling%20performance) — Seamless scaling and analytics backed by support from engineers who've been scaling Redis for years. RedisGreentools sponsored    

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