Issue 174 — September 29, 2017
How Facebook Migrated a Database From InnoDB to MyRocks — Moving one of Facebook’s main databases to MyRocks, their new MySQL storage engine, cut storage usage in half.
Facebook Code story
Why SQL Is Beating NoSQL, and What This Means for The Future of Data — "After years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community?"
Ajay Kulkarni opinion
JackDB: A modern database client — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today.
JackDB, Inc. sponsored
How to Write Efficient TOP N Queries in SQL — A detailed post looking at a common type of SQL query where you want the ‘top N’ records ordered by some value.
Lukas Eder tutorial
Solving the Technical Challenges of Time Series Databases at Scale — Time series databases are optimized for handling sets of data indexed by time, but they have their own challenges at scale.
Fred Moyer video
Would You Consider Running SQL Server on Linux? — Lots of opinions in this busy discussion. Does Linux not being the reference platform for SQL Server put you off?
Hacker News opinion
'The Day I Reached The 1600 Columns Limit in Postgres' — Postgres doesn’t reclaim space when dropping a column which can be a problem in situations where you create and remove many temporary columns.. An interesting story.
Rodrigo Rosenfeld Rosas story
Iguazio, the Anti-Hadoop, Goes GA — Iguazio’s crusade against the Hadoop ecosystem’s complexity and sluggish performance has reached a key milestone.
Datanami news
Alex Handy news
Jeffrey Burt news
Best Practices for Architecting Highly Monitorable Applications — Is your application easy to monitor in production? Many applications are, but sadly, some are designed with observability as an afterthought.
VividCortex sponsored
Viach Kakovskyi tutorial
Distributed Algorithms in NoSQL Databases — A run through of techniques related to distributed operations in NoSQL databases.
Ilya Katsov tutorial
Anna Fedosseeva tutorial
Official SQLizer Blog tutorial
Microsoft Mechanics video
PingCAP story
Datanami story
Robert Haas
20ドル Free on a new Linode account — Linux cloud hosting starting at 1GB of RAM for 5ドル/mo. Use promo code DB20 for 20ドル credit
Linode Cloud Hosting sponsored
Mongolytics: Real-time Business Intelligence from MongoDB — Commercial but with a free tier for exploration.
Mongolytics tools
Podyn: DynamoDB to Postgres Replication and Migration Tool — Have data in Dynamo but looking to query it with SQL or possibly migrate off entirely? Here is a tool that aims to help by steraming changes from Dynamo directly to Postgres.
Marco Slot tools