---
title: "This week's database news, issue 147"
publication: "DB Weekly"
issue: 147
published_at: "2017-03-24"
canonical_url: "https://dbweekly.com/issues/147"
---

Database Weekly 147   . 

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

[Database Weekly](http://dbweekly.com) Issue 147 — March 24, 2017     

Featured [Developers' Most Loved, Dreaded, Wanted and Used Databases](https://stackoverflow.com/insights/survey/2017/?utm_source=dbweekly&utm_medium=email#technology-most-loved-dreaded-and-wanted-databases) — Insights from 64,000 developers who took Stack Overflow’s latest survey show Redis, Postgres, and Mongo as the ‘most loved’ databases, Oracle the most dreaded, but MySQL and SQL Server the most used overall. Stack Overflownews [Tracking the Money: Scaling Financial Reporting at Airbnb](https://medium.com/airbnb-engineering/tracking-the-money-scaling-financial-reporting-at-airbnb-6d742b80f040?utm_source=dbweekly&utm_medium=email) — Airbnb’s complex payments system is now powered by Apache Spark, stored on a HDFS cluster, and written in Scala — moving away from MySQL. Here’s the story behind the move. Alice Liangstory [Scalable, Available Redis Hosting](http://www.redisgreen.net/?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=ha+memory) — RedisGreen helps companies run some of the largest and most scalable Redis deployments in EC2. Redisgreensponsored [![\](https://copm.s3.amazonaws.com/18cd4eac.png)](http://www.redisgreen.net/?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=ha+memory) [Building a New Database Management System in Academia](http://www.cs.cmu.edu/~pavlo/blog/2017/03/building-a-new-database-management-system-in-academia.html?utm_source=dbweekly&utm_medium=email) — Andy Pavlo of Carnegie Mellon University explains why his group had to build a new database system ([Peloton](http://pelotondb.io/)) rather than use an existing one. Andy Pavlostory [Improving Relevance and Elasticsearch Query Patterns](https://data.blog/2017/03/15/improving-relevance-and-elasticsearch-query-patterns/?utm_source=dbweekly&utm_medium=email) — The tale behind improving result relevance on the WordPress plugin directory’s search feature. Automattictutorial [Hadoop at Strata: Not Exactly 'Failure,' But It's Complicated](https://www.datanami.com/2017/03/20/hadoop-strata-not-exactly-failure-complicated/?utm_source=dbweekly&utm_medium=email) — An update on the recent ‘Has Hadoop failed to deliver the goods?’ narrative from discussions at Strata + Hadoop World. Datanamiopinion [Using Redis as a JSON Store](https://redislabs.com/blog/redis-as-a-json-store/?utm_source=dbweekly&utm_medium=email) — ReJSON is a new Redis module that introduces native capabilities for storing and manipulating JSON values. Itamar Habertools [Tgres: A Go and PostgreSQL-Powered Time Series Data Integrator](https://grisha.org/blog/2017/03/22/tgres-0-dot-10-dot-0b-time-series-with-go-and-postgresql/?utm_source=dbweekly&utm_medium=email) — A Go program which receives time series data via Graphite, Statsd, or even a Web pixel, stores it in PostgreSQL, and provides Graphite-like access to the data. Gregory Trubetskoytools In brief [Realm's Mobile Development Platform Links to PostgreSQL to Tie into Enterprise Data](https://thenewstack.io/realms-mobile-development-platform-links-postgresql-tie-enterprise-data/?utm_source=dbweekly&utm_medium=email) The New Stacknews [Intel Moves Data Closer to CPU With Xpoint SSD](https://www.datanami.com/2017/03/20/intel-moves-data-closer-cpu-xpoint-ssd/?utm_source=dbweekly&utm_medium=email) Datanaminews [DreamFactory REST API platform for databases](https://www.dreamfactory.com/signup?utm_campaign=signup-03-24-17&utm_source=email&utm_medium=external-cooper&utm_term=dbweekly&utm_content=dbweekly) — Develop apps faster. DreamFactory automatically turns any database into a REST API platform in minutes. DreamFactorytools sponsored [Which Hadoop File Format Should I Use?](http://www.jowanza.com/post/158761265324/which-hadoop-file-format-should-i-use?utm_source=dbweekly&utm_medium=email) Jowanza Josephtutorial [Rent What You Need: A Database Model for a Renting Service](http://www.vertabelo.com/blog/technical-articles/rent-what-you-need-a-database-model-for-a-renting-service?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s series of data modelling tutorials. Vertabelotutorial [How to Create an AWS Lambda Function That Uses MongoDB Atlas](https://www.mongodb.com/blog/post/serverless-development-with-nodejs-aws-lambda-mongodb-atlas?utm_source=dbweekly&utm_medium=email) Raphael Londnertutorial [Playing Around with Apache Airflow and BigQuery](http://engineering.pmc.com/2017/03/playing-around-with-apache-airflow-bigquery-62/?utm_source=dbweekly&utm_medium=email) Andrew Maguiretutorial [Sports Follies Exemplify Need for Instant Analysis of Streaming Data](https://www.datanami.com/2017/03/16/sports-follies-exemplify-need-instant-analysis-streaming-data/?utm_source=dbweekly&utm_medium=email) Datanamistory [Live MySQL Schema Changes on Amazon RDS with Percona: A Walkthrough](https://tech.olx.com/live-mysql-schema-changes-on-amazon-rds-with-percona-a-walkthrough-27e46222f1b4?utm_source=dbweekly&utm_medium=email#.66qrftsup) M.​ Rafay Aleemstory [Migrating An Analytics Stack From MongoDB to AWS Redshift](https://medium.com/appaloosa-store-engineering/migrating-our-analytics-stack-from-mongodb-to-aws-redshift-334230d9ef7e?utm_source=dbweekly&utm_medium=email) Appaloosastory [Put your DB into overdrive on Linode’s SSD servers.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for $20 credit linodesponsored [Thanks for the Memcached: Linode's Love Letter to memcached](https://medium.com/linode-cube/thanks-for-the-memcached-805630f5b039?utm_source=dbweekly&utm_medium=email) Linodeopinion [Best Practices for Firebase Realtime Database Development](https://medium.com/@CodeAndBiscuits/best-practices-for-firebase-realtime-database-development-14e8fd133d44?utm_source=dbweekly&utm_medium=email) — Some lessons on how best to use the Firebase platform. Chad Robinsonopinion [5 Signs Your SQL Server Isn't Wearing Pants](https://www.brentozar.com/archive/2017/03/signs-sql-server-isnt-wearing-pants/?utm_source=dbweekly&utm_medium=email) Brent Ozaropinion [How to Choose A NoSQL Database](https://medium.com/@bhavik1st/how-to-choose-a-nosql-database-4adb702e2cd6?utm_source=dbweekly&utm_medium=email) Bhavik Shahopinion [Defining Moments in Database History](https://www.xaprb.com/blog/defining-moments-in-database-history/?utm_source=dbweekly&utm_medium=email) Baron Schwartzopinion [Rein: Database Constraints Made Easy for Ruby's ActiveRecord](https://github.com/nullobject/rein?utm_source=dbweekly&utm_medium=email) Joshua Bassettcode [JSONlite: A Serverless, Zero-Config Shell-Based JSON Document Store](https://github.com/nodesocket/jsonlite?utm_source=dbweekly&utm_medium=email) — Written in bash! Justin Kellercode    

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