Issue 159 — June 16, 2017
What's New in SQL:2016 — The new ISO standard introduces row pattern recognition, JSON, listagg and many other features. Unsurprisingly, support is currently quite low but should increase over time.
Markus Winand tutorial
SQLite 35% Faster Than The Filesystem? — A look at how SQLite can be both faster and more space efficient when dealing with small blobs versus the standard filesystem. Related Hacker News discussion.
SQLite story
How to Optimize Cassandra Database Performance — 3 ways to ensure that your Cassandra workloads are operating at peak efficiency
SelectStar sponsored
SystemML, the 'SQL for Machine Learning,' Is Now a Top-Level Apache Project — Developed to provide the ability to scale data analysis from a small laptop to large clusters without the need to rewrite the entire codebase.
Susan Hall news
Amazon Web Services news
The New Stack news
Jefferson Elias tutorial
Lukas Eder tutorial
How to Migrate from SQL to MongoDB — Learn why today's most innovative companies are migrating to MongoDB.
MONGODB sponsored
The Different Types of NoSQL Databases — Key-value stores, document stores, column stores, and graph databases.
Roopendra Vishwakarma tutorial
Mosaic: Processing A Trillion-Edge Graph On A Single Machine — A look at an interesting architecture: "Unless your graph is bigger than Facebook’s, you can process it on a single machine."
Adrian Colyer story
Using UUID or GUID as Primary Keys? Be Careful — You can use UUIDs as the primary key to avoid certain scaling problems, but should you? Tom proposes an alternative.
Tom Harrison Jr opinion
Eric Bernsen tutorial
Gavin Draper
Itzik Ben-Gan tutorial
Gavin Draper tutorial
Denis Gobo tutorial
All the developer services you want, wherever you want them — Manifold enables you to purchase everything from RedisGreen to CloudAMQP with one account, on one bill.
Manifold tools sponsored
oi: Blazingly Fast Ordered Data Intersection Tool — Grep request logs in the blink of an eye.
Marcin Tojek tools
Pinterest Engineering tools