---
title: "#174: Why SQL Is Beating NoSQL"
publication: "DB Weekly"
issue: 174
published_at: "2017-09-29"
canonical_url: "https://dbweekly.com/issues/174"
---

Database Weekly 174   

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

[Database Weekly](http://dbweekly.com) Issue 174 — September 29, 2017     

[How Facebook Migrated a Database From InnoDB to MyRocks](https://code.facebook.com/posts/1478526992216557/migrating-a-database-from-innodb-to-myrocks/?utm_source=dbweekly&utm_medium=email) — Moving one of Facebook’s main databases to [MyRocks](http://myrocks.io/), their new MySQL storage engine, cut storage usage in half. Facebook Codestory [Why SQL Is Beating NoSQL, and What This Means for The Future of Data](https://blog.timescale.com/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a?utm_source=dbweekly&utm_medium=email) — _“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 Kulkarniopinion [JackDB: A modern database client](https://www.jackdb.com/) — 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 [![\](https://copm.s3.amazonaws.com/cc98744f.png)](https://www.jackdb.com/) [How to Write Efficient TOP N Queries in SQL](https://blog.jooq.org/2017/09/22/how-to-write-efficient-top-n-queries-in-sql/?utm_source=dbweekly&utm_medium=email) — A detailed post looking at a common type of SQL query where you want the ‘top N’ records ordered by some value. Lukas Edertutorial [Solving the Technical Challenges of Time Series Databases at Scale](https://www.youtube.com/watch?v=QBatpIFii7M&utm_source=dbweekly&utm_medium=email) — Time series databases are optimized for handling sets of data indexed by time, but they have their own challenges at scale. Fred Moyervideo [Would You Consider Running SQL Server on Linux?](https://news.ycombinator.com/item?id=15346905&utm_source=dbweekly&utm_medium=email) — Lots of opinions in this busy discussion. Does Linux not being the _reference platform_ for SQL Server put you off? Hacker Newsopinion ['The Day I Reached The 1600 Columns Limit in Postgres'](https://rosenfeld.herokuapp.com/en/articles/programming/2017-09-26-the-day-i-reached-the-1600-columns-limit-in-postgresql?utm_source=dbweekly&utm_medium=email) — 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 Rosasstory [Iguazio, the Anti-Hadoop, Goes GA](https://www.datanami.com/2017/09/27/iguazio-anti-hadoop-goes-ga/?utm_source=dbweekly&utm_medium=email) — Iguazio’s crusade against the Hadoop ecosystem’s complexity and sluggish performance has reached a key milestone. Datanaminews [MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, and More](https://thenewstack.io/mysql-8-0-release-candidate-arrives/?utm_source=dbweekly&utm_medium=email) Alex Handynews [MapR Bulks Up Database for Modern Apps](https://www.nextplatform.com/2017/09/26/mapr-bulks-database-modern-apps/?utm_source=dbweekly&utm_medium=email) Jeffrey Burtnews [Best Practices for Architecting Highly Monitorable Applications](https://www.vividcortex.com/resources/architecting-highly-monitorable-apps?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=Architecting%20Highly) — Is your application easy to monitor in production? Many applications are, but sadly, some are designed with observability as an afterthought. VividCortexsponsored [Efficient Pagination of a Table with 100M Records using SQL](http://allyouneedisbackend.com/blog/2017/09/24/the-sql-i-love-part-1-scanning-large-table/?utm_source=dbweekly&utm_medium=email) Viach Kakovskyitutorial [Distributed Algorithms in NoSQL Databases](https://highlyscalable.wordpress.com/2012/09/18/distributed-algorithms-in-nosql-databases/?utm_source=dbweekly&utm_medium=email) — A run through of techniques related to distributed operations in NoSQL databases. Ilya Katsovtutorial [Speeding Up MySQL Using Materialized Views](https://medium.com/@anna.f/speeding-up-mysql-by-using-materialized-views-282ecbd3a53f?utm_source=dbweekly&utm_medium=email) Anna Fedosseevatutorial [Exporting MongoDB Data and Convert It Into SQL](http://blog.sqlizer.io/posts/mongodb-sqlizer-api/?utm_source=dbweekly&utm_medium=email) Official SQLizer Blogtutorial [Everything You Need to Know About SQL Server 2017](https://www.youtube.com/watch?v=uxA6VyrgBnk&utm_source=dbweekly&utm_medium=email) Microsoft Mechanicsvideo [Why We Choose Rust Over Golang or C/C++ to Develop TiKV?](https://pingcap.github.io/blog/2017/09/26/whyrust/?utm_source=dbweekly&utm_medium=email) PingCAPstory [SQL Databases Integrating NoSQL-like Features](https://www.datanami.com/2017/09/25/sql-databases-integrating-nosql-like-features/?utm_source=dbweekly&utm_medium=email) Datanamistory [PostgreSQL's Hash Indexes Are Now Cool](http://rhaas.blogspot.com/2017/09/postgresqls-hash-indexes-are-now-cool.html?utm_source=dbweekly&utm_medium=email) Robert Haas [$20 Free on a new Linode account](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Linux cloud hosting starting at 1GB of RAM for $5/mo. Use promo code DB20 for $20 credit Linode Cloud Hostingsponsored [Mongolytics: Real-time Business Intelligence from MongoDB](https://mongolytics.io/?utm_source=dbweekly&utm_medium=email) — Commercial but with a free tier for exploration. Mongolyticstools [Elasticsearch Fixtures: Simple Fixture Loading for Elasticsearch from Node.js](https://github.com/toniov/es-fixtures?utm_source=dbweekly&utm_medium=email) Antonio Vtools [Podyn: DynamoDB to Postgres Replication and Migration Tool](https://www.citusdata.com/blog/2017/09/22/dynamodb-to-postgres-replication/?utm_source=dbweekly&utm_medium=email) — Have data in Dynamo but looking to query it with SQL or possibly [migrate off](https://containership.engineering/dynamodb-to-postgres-why-and-how-aa891681af4d) entirely? Here is a tool that aims to help by steraming changes from Dynamo directly to Postgres. Marco Slottools    

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