DB Weekly Issue 93: February 26, 2016

Issue 93 — February 26, 2016

Featured

rqlite: Replicated SQLite using the Raft Consensus Protocol — A distributed system that provides a replicated SQLite database. It’s written in Go and uses Raft to achieve consensus across all the instances of the SQLite databases.

Philip O'Toole code

Ask HN: How to Handle 50GB of Transaction Data Each Day? — An interesting discussion on Hacker News about how to handle large amounts of data arriving on a continuous basis.

Hacker News

Moving from MySQL to a 'Database-Free' Architecture — A look at how a busy search data service moved from MySQL to a programming language specific binary marshalling approach, and why.

Moz

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

Building a Streaming Search Platform — An interesting story of how several developers approached building a search platform for streaming data using Storm and Redis.

Ryan Walker

Awesome MongoDB: A Curated Set of MongoDB Resources — About 60 links for you to enjoy.

Guillaume Gelin

Spark 2.0 to Introduce New 'Structured Streaming' Engine — A new ‘Structured Streaming’ engine that leans on the Spark SQL API to simplify the development of real-time, continuous big data apps.

Datanami

Amazon RDS Now Supports MySQL 5.7 — 5.7 not only offers better performance and security, but also a native JSON data type and built-in JSON functions for working with documents.

Amazon

SQL-on-Hadoop Test: Each Engine Has 'Sweet Spots' — With business intelligence being one of Hadoop’s key uses, the role of SQL-on-Hadoop engines has become significant.

Datanami

30 Years Ago: The Rise, Fall and Survival of Ashton-Tate's dBASE — Well this takes me back. You may also enjoy A Personal History of dBASE.

Darryl Taft

Jobs

Cassandra Infrastructure Engineer — Ever had to deal with massive SSTable bloat? Come join us and help run Cassandra at scale.

Heroku

Stop Applying to Jobs - Let Companies Apply to You — On Hired, sign up in 10 minutes and get offers from top companies like Facebook, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Try it today.

Hired.com

In brief

OrientDB 2.2 Beta Released

OrientDB news

RavenDB Passed Half A Million Downloads

Oren Eini news

Google Releases Cloud Processor For Hadoop, Spark

Datanami news

Portfolio Risk Analysis in SQL — A quick look at doing some math with SQL to calculate the risk within an investment portfolio.

Periscope

Buffering SQL Writes with Redis

David Cramer

Apache Spark Machine Learning Tutorial

Carol McDonald

Foreign Data Wrappers with PostgreSQL and PHP

Gonzalo Ayuso

Saving memory in Redis with MessagePack and Lua scripts

Adrien Moreau

The Lambda Architecture Simplified — A guide to building a scalable data architecture for real-time workloads.

MemSQL sponsored

Why Has an Index Broken My Query?

The Magic of SQL video

Scaling ElasticSearch at Synthesio

Fred de Villamil

Why (and how to) Redis with your MongoDB

Compose.io

Protector: A Circuit Breaker for Time Series Databases — A circuit breaker limits CPU and memory usage for each query, preventing out-of-memory exceptions. This system is aimed at InfluxDB for now but may be extended over time.

Trivago tools

Unlimited Scalability & Unprecedented Speed with In-Memory Computing — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture.

GridGain In-Memory Data Fabric tools sponsored

restdb.io - The Plug And Play Database Service — Aimed at people who want a database in the cloud with no coding to get going.

RestDB tools

Rpubsub: Simple Command Line Utilities for Redis Pub/Sub

Andrew Guenther tools