Issue 174 — September 29, 2017
How Facebook Migrated a Database From InnoDB to MyRocks
— Moving one of Facebook’s main databases to
, their new MySQL storage engine, cut storage usage in half.
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?”
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.
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.
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.
Would You Consider Running SQL Server on Linux?
— Lots of opinions in this busy discussion. Does Linux not being the
for SQL Server put you off?
'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
Iguazio, the Anti-Hadoop, Goes GA
— Iguazio’s crusade against the Hadoop ecosystem’s complexity and sluggish performance has reached a key milestone.
MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, and More
MapR Bulks Up Database for Modern Apps
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.
Efficient Pagination of a Table with 100M Records using SQL
Distributed Algorithms in NoSQL Databases
— A run through of techniques related to distributed operations in NoSQL databases.
Speeding Up MySQL Using Materialized Views
Exporting MongoDB Data and Convert It Into SQL
Official SQLizer Blog
Everything You Need to Know About SQL Server 2017
Why We Choose Rust Over Golang or C/C++ to Develop TiKV?
SQL Databases Integrating NoSQL-like Features
PostgreSQL's Hash Indexes Are Now Cool
$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
Mongolytics: Real-time Business Intelligence from MongoDB
— Commercial but with a free tier for exploration.
Elasticsearch Fixtures: Simple Fixture Loading for Elasticsearch from Node.js
Podyn: DynamoDB to Postgres Replication and Migration Tool
— Have data in Dynamo but looking to query it with SQL or possibly
entirely? Here is a tool that aims to help by steraming changes from Dynamo directly to Postgres.