Issue 147 — March 24, 2017
Featured
Developers' Most Loved, Dreaded, Wanted and Used 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 Overflow news
Tracking the Money: Scaling Financial Reporting at Airbnb — 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 Liang story
Scalable, Available Redis Hosting — RedisGreen helps companies run some of the largest and most scalable Redis deployments in EC2.
Redisgreen sponsored
Building a New Database Management System in Academia — Andy Pavlo of Carnegie Mellon University explains why his group had to build a new database system (Peloton) rather than use an existing one.
Andy Pavlo story
Improving Relevance and Elasticsearch Query Patterns — The tale behind improving result relevance on the WordPress plugin directory’s search feature.
Automattic tutorial
Hadoop at Strata: Not Exactly 'Failure,' But It's Complicated — An update on the recent ‘Has Hadoop failed to deliver the goods?’ narrative from discussions at Strata + Hadoop World.
Datanami opinion
Using Redis as a JSON Store — ReJSON is a new Redis module that introduces native capabilities for storing and manipulating JSON values.
Itamar Haber tools
Tgres: A Go and PostgreSQL-Powered Time Series Data Integrator — 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 Trubetskoy tools
In brief
The New Stack news
Datanami news
DreamFactory REST API platform for databases — Develop apps faster. DreamFactory automatically turns any database into a REST API platform in minutes.
DreamFactory tools sponsored
Jowanza Joseph tutorial
Rent What You Need: A Database Model for a Renting Service — The latest in Vertabelo’s series of data modelling tutorials.
Vertabelo tutorial
Raphael Londner tutorial
Andrew Maguire tutorial
M. Rafay Aleem story
Appaloosa story
Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for 20ドル credit
linode sponsored
Linode opinion
Best Practices for Firebase Realtime Database Development — Some lessons on how best to use the Firebase platform.
Chad Robinson opinion
Brent Ozar opinion
Bhavik Shah opinion
Baron Schwartz opinion
Joshua Bassett code
JSONlite: A Serverless, Zero-Config Shell-Based JSON Document Store — Written in bash!
Justin Keller code