Issue 80 — November 20, 2015
Featured
Elasticsearch as a Time Series Data Store —
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 —
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 —
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.
JetBrains tools
Redis Performance Dashboard and Autoscaling from RedisGreen — Ever wonder what your Redis server was actually doing? Find out with RedisGreen's dashboard and monitoring tools.
RedisGreen sponsored
5 Things We Hate About Spark —
Spark has dethroned MapReduce and changed big data forever, but that rapid ascent has been accompanied by frustrations.
InfoWorld opinion
MemDB: A Distributed Transactional In-Memory Database —
It’s MongoDB compatible, but includes ACID transaction support.
Yu Xia code
The Most Popular Relational Databases —
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 —
Aimed at data journalists, but perhaps a good dataset on which to practice your SQL skills as well.
Stanford Computational Journalism Lab tutorial
In brief
TechCrunch news tools
The Great DBMS Migration to Open Source — A how-to guide for the pilgrimage, including migration strategies & best practices you can use right now.
EnterpriseDB sponsored
Datanami opinion
Periscope tutorial
Andy Granowitz tutorial
Muhammad Panji tutorial
Balázs Pőcze tutorial
Optimizing MySQL for High Concurrency on Amazon RDS —
Contrary to expectation, disabling the query cache helped a lot.
NoRedInk Tech tutorial
Test the Distributed Open Source RDBMS for Real-Time Big Data Built on PostgreSQL — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain real-time insights.
Citus Data tools sponsored
Is Your Redis Server Safe? —
Checks your port 6379 isn’t open.
Whitesmith tools
Paul M. Jones opinion
Andrew Liu opinion
TechRepublic opinion
Arunoda Susiripala opinion
Bikoda opinion
Christophe Pettus opinion
Segment opinion
PearlDB: A Durable HTTP Key-Value Pair Database —
Completely written in C. Uses LMDB for storage.
github.com code
github.com code