DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
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
SlashDB Can Turn Any Data Source Into A Website
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   
Making Big Data Work for a Major Oil and Gas Equipment Manufacturer
Datanami    opinion   
SQL Joins For Data Analysis
Periscope    tutorial   
Calculating Active Users in SQL
Andy Granowitz    tutorial   
How to Install Elasticsearch on Ubuntu 14.04
Muhammad Panji    tutorial   
Streaming MySQL Binary Logs for Backup
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   
Elasticsearch-SQL: Query Elasticsearch with an SQL Syntax
GitHub    tools   
Is Your Redis Server Safe? — Checks your port 6379 isn’t open.
Whitesmith    tools   
SQL Schema Naming Conventions
Paul M.​ Jones    opinion   
Why You Need (and Don’t Need) A NoSQL Database
Andrew Liu    opinion   
Top 10 Priorities for A Successful Hadoop Implementation
TechRepublic    opinion   
Scaling MongoDB at Kadira
Arunoda Susiripala    opinion   
ActorDB - How and Why We Run SQLite On Top of LMDB
Bikoda    opinion   
PostgreSQL, The PCI Compliant Database [PDF]
Christophe Pettus    opinion   
When to Use SQL for Analysis
Segment    opinion   
PearlDB: A Durable HTTP Key-Value Pair Database — Completely written in C. Uses LMDB for storage.
github.​com    code   
degdb: A Distributed Economic Graph Database
github.​com    code   
« Prev
Next »