#174: Why SQL Is Beating NoSQL

This week's database news - Read this on the Web

Database Weekly 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   MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, and More Alex Handy   news   MapR Bulks Up Database for Modern Apps 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   Efficient Pagination of a Table with 100M Records using SQL Viach Kakovskyi   tutorial   Distributed Algorithms in NoSQL Databases — A run through of techniques related to distributed operations in NoSQL databases. Ilya Katsov   tutorial   Speeding Up MySQL Using Materialized Views Anna Fedosseeva   tutorial   Exporting MongoDB Data and Convert It Into SQL Official SQLizer Blog   tutorial   Everything You Need to Know About SQL Server 2017 Microsoft Mechanics   video   Why We Choose Rust Over Golang or C/C++ to Develop TiKV? PingCAP   story   SQL Databases Integrating NoSQL-like Features Datanami   story   PostgreSQL's Hash Indexes Are Now Cool 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   Elasticsearch Fixtures: Simple Fixture Loading for Elasticsearch from Node.js Antonio V   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   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK