---
title: "This week's database news, issue 93"
publication: "DB Weekly"
issue: 93
published_at: "2016-02-26"
canonical_url: "https://dbweekly.com/issues/93"
---

Database Weekly 93   . 

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

[Database Weekly](http://dbweekly.com) Issue 93 — February 26, 2016     

Featured [rqlite: Replicated SQLite using the Raft Consensus Protocol](https://github.com/otoolep/rqlite?utm_source=dbweekly&utm_medium=email) — 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'Toolecode [Ask HN: How to Handle 50GB of Transaction Data Each Day?](https://news.ycombinator.com/item?id=11157829&utm_source=dbweekly&utm_medium=email) — 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](https://moz.com/devblog/moz-analytics-db-free/?utm_source=dbweekly&utm_medium=email) — 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](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&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/0eb540bf.png)](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=primary&utm_term=findout+autoscaling+performance) [Building a Streaming Search Platform](http://insightdataengineering.com/blog/streaming-search/index.html?utm_source=dbweekly&utm_medium=email) — 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](https://github.com/ramnes/awesome-mongodb?utm_source=dbweekly&utm_medium=email) — About 60 links for you to enjoy. Guillaume Gelin [Spark 2.0 to Introduce New 'Structured Streaming' Engine](http://www.datanami.com/2016/02/25/spark-2-0-to-introduce-new-structured-streaming-engine/?utm_source=dbweekly&utm_medium=email) — A new ‘Structured Streaming’ engine that leans on the Spark SQL API to simplify the development of real-time, continuous big data apps. Datanaminews [Amazon RDS Now Supports MySQL 5.7](https://aws.amazon.com/about-aws/whats-new/2016/02/amazon-rds-now-supports-mysql-5-7/?utm_source=dbweekly&utm_medium=email) — 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. Amazonnews [SQL-on-Hadoop Test: Each Engine Has 'Sweet Spots'](http://www.datanami.com/2016/02/25/sql-on-hadoop-test-each-engine-has-sweet-spots/?utm_source=dbweekly&utm_medium=email) — With business intelligence being one of Hadoop’s key uses, the role of SQL-on-Hadoop engines has become significant. Datanamiopinion [30 Years Ago: The Rise, Fall and Survival of Ashton-Tate's dBASE](http://www.eweek.com/database/30-years-ago-the-rise-fall-and-survival-of-ashton-tates-dbase.html?utm_source=dbweekly&utm_medium=email) — Well this takes me back. You may also enjoy [A Personal History of dBASE](http://www.jpmartel.com/bu03_b.htm). Darryl Taft Jobs [Cassandra Infrastructure Engineer](https://www.heroku.com/careers/67) — 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](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_term=cat-tech-database&utm_content=stopapplyingtojobs&utm_campaign=q1-16&utm_location=us) — 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](http://orientdb.com/orientdb-labs/?utm_source=dbweekly&utm_medium=email) OrientDBnews [RavenDB Passed Half A Million Downloads](https://ayende.com/blog/173409/ravendb-passed-half-a-million-downloads?utm_source=dbweekly&utm_medium=email) Oren Eininews [Google Releases Cloud Processor For Hadoop, Spark](http://www.datanami.com/2016/02/24/google-releases-cloud-processor-for-hadoop-spark/?utm_source=dbweekly&utm_medium=email) Datanaminews [Portfolio Risk Analysis in SQL](https://periscopedata.com/blog//portfolio-risk-analysis-in-sql.html?utm_source=dbweekly&utm_medium=email) — A quick look at doing some math with SQL to calculate the risk within an investment portfolio. Periscopetutorial [Buffering SQL Writes with Redis](http://blog.getsentry.com/2016/02/23/buffering-sql-writes-with-redis.html?utm_source=dbweekly&utm_medium=email) David Cramertutorial [Apache Spark Machine Learning Tutorial](https://www.mapr.com/blog/apache-spark-machine-learning-tutorial?utm_source=dbweekly&utm_medium=email) Carol McDonaldtutorial [Foreign Data Wrappers with PostgreSQL and PHP](http://gonzalo123.com/2016/02/22/foreign-data-wrappers-with-postgresql-and-php/?utm_source=dbweekly&utm_medium=email) Gonzalo Ayusotutorial [Saving memory in Redis with MessagePack and Lua scripts](http://blog.backslash.fr/optimizing-redis-memory-usage-with-messagepack-optimistic-locking-transaction-and-lua-script/?utm_source=dbweekly&utm_medium=email) Adrien Moreaututorial [The Lambda Architecture Simplified](http://www1.memsql.com/lambda-architecture.html?utm_source=email&utm_medium=dbnews&utm_content=whitepaper&utm_campaign=lambda) — A guide to building a scalable data architecture for real-time workloads. MemSQLtutorial sponsored [Why Has an Index Broken My Query?](https://www.youtube.com/watch?v=JrzAGLOcswo&utm_source=dbweekly&utm_medium=email) The Magic of SQLvideo [Scaling ElasticSearch at Synthesio](http://www.slideshare.net/Synthesio/scaling-elasticsearch-at-synthesio?utm_source=dbweekly&utm_medium=email) Fred de Villamil [Why (and how to) Redis with your MongoDB](https://www.compose.io/articles/why-and-how-to-redis-with-your-mongodb/?utm_source=dbweekly&utm_medium=email) Compose.​ioopinion [Protector: A Circuit Breaker for Time Series Databases](http://tech.trivago.com/2016/02/23/protector/?utm_source=dbweekly&utm_medium=email) — 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. Trivagotools [Unlimited Scalability & Unprecedented Speed with In-Memory Computing](http://www.gridgain.com/products/in-memory-data-fabric/?utm_source=dbweekly&utm_medium=email) — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture. GridGain In-Memory Data Fabrictools sponsored [restdb.io - The Plug And Play Database Service](https://restdb.io/?utm_source=dbweekly&utm_medium=email) — Aimed at people who want a database in the cloud with no coding to get going. RestDBtools [Rpubsub: Simple Command Line Utilities for Redis Pub/Sub](http://ajguenther.com/rpubsub/?utm_source=dbweekly&utm_medium=email) Andrew Guenthertools    

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