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

Database Weekly 80   . 

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

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

Featured [Elasticsearch as a Time Series Data Store](https://www.elastic.co/blog/elasticsearch-as-a-time-series-data-store?utm_source=dbweekly&utm_medium=email) — Elasticsearch is commonly called a ‘search server’ but it’s ultimately a document database underneath, and it turns out it works well as a time series database too. Felix Barnsteiner [Naming Conventions in Database Modeling](http://www.vertabelo.com/blog/technical-articles/naming-conventions-in-database-modeling?utm_source=dbweekly&utm_medium=email) — Naming conventions are a key part of a well-built data model. Here’s an opinionated look at the basics. Jeffrey Edison [0xDBE: JetBrains' New Database Tools / IDE](https://www.jetbrains.com/dbe/?utm_source=dbweekly&utm_medium=email) — JetBrains are well known for their developer IDEs, but now they’re working on an IDE for DBAs and SQL developers. It’s not quite ready, however. JetBrainstools [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2015b&utm_content=primary&utm_term=findout+autoscaling+performance) — Ever wonder what your Redis server was actually doing? Find out with RedisGreen's dashboard and monitoring tools. RedisGreensponsored [![\](https://copm.s3.amazonaws.com/7cb39ef6.png)](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2015b&utm_content=primary&utm_term=findout+autoscaling+performance) [5 Things We Hate About Spark](http://www.infoworld.com/article/3004460/application-development/5-things-we-hate-about-spark.html?utm_source=dbweekly&utm_medium=email) — Spark has dethroned MapReduce and changed big data forever, but that rapid ascent has been accompanied by frustrations. InfoWorldopinion [MemDB: A Distributed Transactional In-Memory Database](https://github.com/rain1017/memdb?utm_source=dbweekly&utm_medium=email) — It’s MongoDB compatible, but includes ACID transaction support. Yu Xiacode [The Most Popular Relational Databases](https://plumbr.eu/blog/io/most-popular-relational-databases?utm_source=dbweekly&utm_medium=email) — Plumbr monitors a large number of JVMs to detect expensive JDBC operations. Here they share the most common relational databases they see (naturally it’s biased to Java/JVM users). Plumbr [Exploring a Pulitzer-Winning Medicare Investigation with SQL](http://2015.padjo.org/tutorials/sql-walks/exploring-wsj-medicare-investigation-with-sql/?utm_source=dbweekly&utm_medium=email) — Aimed at data journalists, but perhaps a good dataset on which to practice your SQL skills as well. Stanford Computational Journalism Labtutorial In brief [SlashDB Can Turn Any Data Source Into A Website](http://techcrunch.com/2015/06/29/slashdb-can-turn-any-data-source-into-a-website/?utm_source=dbweekly&utm_medium=email) TechCrunchnews tools [The Great DBMS Migration to Open Source](http://www.enterprisedb.com/postgres-plus-edb-blog/ed-boyajian/great-database-migration-open-source-how-guide-pilgrimage?utm_source=cooperpress&utm_medium=nl&utm_campaign=DBmigratblog) — A how-to guide for the pilgrimage, including migration strategies & best practices you can use right now. EnterpriseDBsponsored [Making Big Data Work for a Major Oil and Gas Equipment Manufacturer](http://www.datanami.com/2015/11/16/making-big-data-work-for-a-major-oil-gas-equipment-manufacturer/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [SQL Joins For Data Analysis](https://periscopedata.com/blog//sql-joins-data-analysis.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Calculating Active Users in SQL](https://www.wagonhq.com/blog/active-users-in-sql?utm_source=dbweekly&utm_medium=email) Andy Granowitztutorial [How to Install Elasticsearch on Ubuntu 14.04](https://hostpresto.com/community/tutorials/how-to-install-elastic-search-on-ubuntu-14-04/?utm_source=dbweekly&utm_medium=email) Muhammad Panjitutorial [Streaming MySQL Binary Logs for Backup](http://blog.balazspocze.me/2015/11/16/streaming-mysql-binary-logs-for-backup/?utm_source=dbweekly&utm_medium=email) Balázs Pőczetutorial [Optimizing MySQL for High Concurrency on Amazon RDS](http://tech.noredink.com/post/133347435578/optimizing-mysql-for-high-concurrency-on-amazon?utm_source=dbweekly&utm_medium=email) — Contrary to expectation, disabling the query cache helped a lot. NoRedInk Techtutorial [Test the Distributed Open Source RDBMS for Real-Time Big Data Built on PostgreSQL](http://info.citusdata.com/BigDataDBW.html?utm_source=dbweekly&utm_medium=email) — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain [real-time insights.](http://info.citusdata.com/BigDataPW3.html) Citus Datatools sponsored [Elasticsearch-SQL: Query Elasticsearch with an SQL Syntax](https://github.com/NLPchina/elasticsearch-sql/blob/master/README.md?utm_source=dbweekly&utm_medium=email) GitHubtools [Is Your Redis Server Safe?](https://www.isredisallsafe.com/?utm_source=dbweekly&utm_medium=email) — Checks your port 6379 isn’t open. Whitesmithtools [SQL Schema Naming Conventions](http://paul-m-jones.com/archives/6188?utm_source=dbweekly&utm_medium=email) Paul M.​ Jonesopinion [Why You Need (and Don’t Need) A NoSQL Database](https://medium.com/@aliuy8/why-you-need-and-don-t-need-a-json-document-database-43cde075e248?utm_source=dbweekly&utm_medium=email) Andrew Liuopinion [Top 10 Priorities for A Successful Hadoop Implementation](http://www.techrepublic.com/article/top-10-priorities-for-a-successful-hadoop-implementation/?utm_source=dbweekly&utm_medium=email) TechRepublicopinion [Scaling MongoDB at Kadira](https://kadira.io/blog/other/scaling-mongodb-at-kadira?utm_source=dbweekly&utm_medium=email) Arunoda Susiripalaopinion [ActorDB - How and Why We Run SQLite On Top of LMDB](http://blog.biokoda.com/post/133121776825/actordb-how-and-why-we-run-sqlite-on-top-of-lmdb?utm_source=dbweekly&utm_medium=email) Bikodaopinion [PostgreSQL, The PCI Compliant Database [PDF\]](http://thebuild.com/presentations/pgconfsv-2015-pci.pdf?utm_source=dbweekly&utm_medium=email) Christophe Pettusopinion [When to Use SQL for Analysis](https://segment.com/academy/intro/when-to-use-sql-for-analysis/?utm_source=dbweekly&utm_medium=email) Segmentopinion [PearlDB: A Durable HTTP Key-Value Pair Database](https://github.com/willemt/pearldb?utm_source=dbweekly&utm_medium=email) — Completely written in C. Uses LMDB for storage. github.​comcode [degdb: A Distributed Economic Graph Database](https://github.com/degdb/degdb?utm_source=dbweekly&utm_medium=email) github.​comcode    

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