DB Weekly
Archives| Latest| RSS
« Prev
Next »
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  
« Prev
Next »