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

Database Weekly 83   . 

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

[Database Weekly](http://dbweekly.com) Issue 83 — December 11, 2015     

Featured [MongoDB 3.2 Released: 'A Giant Leap'](https://www.mongodb.com/mongodb-3.2?utm_source=dbweekly&utm_medium=email) — The faster, compressable WiredTiger storage engine is now the default. Document validation can now be performed at database level. Left outer joins are now possible, and more. MongoDBnews [The Next Generation of Managed MySQL Offerings On Cloud SQL](http://googlecloudplatform.blogspot.com/2015/12/the-next-generation-of-managed-MySQL-offerings-on-Cloud-SQL.html?utm_source=dbweekly&utm_medium=email) — Google Cloud SQL is an easy-to-use service that delivers fully managed MySQL databases and the second ‘generation’ of it is now in beta. It can scale up to 10TB datasets, 15k IOPS and 104GB of RAM per instance. Google Cloud Platformnews [Couchbase Server 4.1 Released](http://blog.couchbase.com/2015/december/introducing-couchbase-server-4.1?utm_source=dbweekly&utm_medium=email) — Couchbase Server 4.1 brings massive improvements to query functionality and performance including support for common SQL statements in N1QL. (“you can now manipulate JSON documents with N1QL, in the same manner as you would manipulate tables with SQL”) Couchbasenews [Plug Email Into Your App with Mailgun](https://documentation.mailgun.com/quickstart-sending.html?utm_source=dbweeklyDec11&utm_medium=newsletter&utm_campaign=sendemaildocs#how-to-start-sending-email) — Send email in your language of choice using SMTP or Mailgun's RESTful API. The first 10,000 emails are free. Read our documentation and start testing now. Mailgunsponsored [![\](https://copm.s3.amazonaws.com/8cff7037.png)](https://documentation.mailgun.com/quickstart-sending.html?utm_source=dbweeklyDec11&utm_medium=newsletter&utm_campaign=sendemaildocs#how-to-start-sending-email) [The MongoDB Statbox: Graphs of Stats in 5cm by 6cm](https://www.compose.io/articles/the-mongodb-statbox/?utm_source=dbweekly&utm_medium=email) — Using just a Pi Zero, a Unicorn Hat, a slice of Python and a plug-in of Wifi, find out how you can turn you database stats into shining, physical beacons of information. DJ Walker-Morgan [q: Run SQL Directly on CSV or TSV Files](https://github.com/harelba/q?utm_source=dbweekly&utm_medium=email) — A command line tool that allows execution of SQL-like queries on CSVs/TSVs. It treats ordinary files as database tables, and supports SQL constructs like WHERE, GROUP BY, JOINs etc. Harel Ben-Attiatools [Scaling to 100M: MySQL is a Better NoSQL](http://engineering.wix.com/2015/12/10/scaling-to-100m-mysql-is-a-better-nosql/?utm_source=dbweekly&utm_medium=email) — At Wix, they’re using MySQL as a glorified key/value system for storing documents rather than a dedicated NoSQL document database. Wix Engineeringopinion [Meet the Avant-Garde of New Relational Databases](http://www.datanami.com/2015/11/27/meet-the-avant-garde-of-new-relational-databases/?utm_source=dbweekly&utm_medium=email) — Gartner is advising clients to look at the ‘avant garde’ of relational databases, such as offerings from NuoDB, VoltDB and MemSQL. Alex Woodie [Architecting Distributed Databases for Failure](http://imply.io/post/2015/12/10/failure.html?utm_source=dbweekly&utm_medium=email) — Being prepared for failure in a distributed system is essential. Here, an engineer shares his experiences of building an open source distributed data store and the contingencies taken to survive outages. Fangjin Yang [Building Real-Time Dashboard Apps with Flink, Elasticsearch & Kibana](https://www.elastic.co/blog/building-real-time-dashboard-applications-with-apache-flink-elasticsearch-and-kibana?utm_source=dbweekly&utm_medium=email) — A demonstration of building a real-time dashboard solution for stream data analytics using Apache Flink (a streamed data processor), Elasticsearch (the document database and search server, and Kibana (Elastic’s data exploration tool). Fabian Hueske Jobs [Your Dream Job Awaits.](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_campaign=q4_15-petercooperpress&utm_term=sponsored&utm_content=121115-dreamjob) — Hired makes finding a job you love easier and more transparent than ever before. See what the hype is about and join Hired today. Hired.​com In brief [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+autoscaling+performance) — Seamless scaling and analytics backed by support from engineers who have been scaling Redis for years. RedisGreentools sponsored [MapR Introduces Streams to Compete with Kafka](http://www.datanami.com/2015/12/08/mapr-introduces-streams-to-compete-with-kafka/?utm_source=dbweekly&utm_medium=email) — Streams is compatible with real-time streaming analytics tools such as Apache Storm and Spark Streaming. Datanaminews [Release Notes for MongoDB 3.2](https://docs.mongodb.org/manual/release-notes/3.2/?utm_source=dbweekly&utm_medium=email) MongoDBnews [The First Annual PGConf Silicon Valley Wrap Up](https://www.citusdata.com/blog/25-terry/344-first-annual-pgconf-silicon-valley-wrap-up?utm_source=dbweekly&utm_medium=email) Citus Datanews [Database Design for the Dental Office](http://www.vertabelo.com/blog/technical-articles/database-design-for-the-dental-office?utm_source=dbweekly&utm_medium=email) Emil Drkušićtutorial [SQL GROUP BY and Functional Dependencies: A Useful Feature](http://blog.jooq.org/2015/12/10/sql-group-by-and-functional-dependencies-a-very-useful-feature/?utm_source=dbweekly&utm_medium=email) Data Geekerytutorial [Introduction to Elasticsearch Analyzers](https://qbox.io/blog/introduction-to-elasticsearch-analyzers?utm_source=dbweekly&utm_medium=email) — A look at what’s involved when Elasticsearch performs queries, particularly with regard to inverted indexes and running analyzers over incoming documents. Vineeth Mohantutorial [Parsing Java 8 Streams Into SQL](http://ageofjava.blogspot.com/2015/12/when-java-8-was-released-and-people.html?utm_source=dbweekly&utm_medium=email) Emil Forslundtutorial [Top 10 Performance Tuning Techniques for Amazon Redshift](http://blogs.aws.amazon.com/bigdata/post/Tx31034QG0G3ED1/Top-10-Performance-Tuning-Techniques-for-Amazon-Redshift?utm_source=dbweekly&utm_medium=email) Amazontutorial [SQLite: The Database at the Edge of the Network](https://www.youtube.com/watch?v=Jib2AmRb_rk&utm_source=dbweekly&utm_medium=email) Dr.​ Richard Hippvideo [287 Million Events/day and 1 Engineer: How I Built Quizlet's Data Pipeline with BigQuery and Go](https://quizlet.com/blog/287-million-events-per-day-and-1-engineer-how-i-built-quizlets-data-pipeline-with-bigquery-and-go?utm_source=dbweekly&utm_medium=email) Alec Winogradopinion [What's The Best Database for An Analyst?](https://blog.modeanalytics.com/best-database-for-analysts/?utm_source=dbweekly&utm_medium=email) Modeopinion [A Postmortem of a Server Compromised Due to Publicly Accessible Redis](http://kevinchen.co/blog/postmortem-server-compromised/?utm_source=dbweekly&utm_medium=email) Kevin Chenopinion [How to Address Top Challenges of Database Management](http://data-informed.com/how-to-address-top-challenges-of-database-management/?utm_source=dbweekly&utm_medium=email) Pierre Frickeopinion [An Unemotional Logical Look At SQL Server Naming Conventions](http://www.vertabelo.com/blog/technical-articles/an-unemotional-logical-look-at-sql-server-naming-conventions?utm_source=dbweekly&utm_medium=email) Jeffrey J Kelleropinion [Avoiding Three Common Pitfalls of Data Lakes](http://data-informed.com/avoiding-three-common-pitfalls-data-lakes/?utm_source=dbweekly&utm_medium=email) Ben Szekelyopinion [migr8: A Concurrent Redis Migration Utility, Written in Go](http://product.reverb.com/2015/12/05/introducing-migr8-a-concurrent-redis-migration-utility-written-in-go/?utm_source=dbweekly&utm_medium=email) Reverbtools [Sphinx: Distributed Execution of Interactive SQL Queries on Big Spatial Data [PDF\]](http://www-users.cs.umn.edu/~eldawy/publications/2015_SIGSPATIAL_Sphinx.pdf?utm_source=dbweekly&utm_medium=email) Eldawy, Elganainy et al.​    

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