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.
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.
How to Optimize Cassandra Database Performance
— 3 ways to ensure that your Cassandra workloads are operating at peak efficiency
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.
Amazon Aurora Introduces Database Cloning Capabilities
Amazon Web Services
TimescaleDB Focuses on Query Power and Scale
The New Stack
How to Document SQL Server Database Objects
When to Use Bind Values and When to Use Inline Values in SQL
How to Migrate from SQL to MongoDB
— Learn why today's most innovative companies are migrating to MongoDB.
The Different Types of NoSQL Databases
— Key-value stores, document stores, column stores, and graph databases.
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.”
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
How to Properly Monitor Elasticsearch
SQL Server 2016 Row Level Security In Action
What You Need to Know about SQL Server's Distinct Windowed Aggregate Calculations
SQL Server 2017 Graph Data Features In Action
Running SQL Queries Against Baby Names from Social Security Card Applications
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.
oi: Blazingly Fast Ordered Data Intersection Tool
— Grep request logs in the blink of an eye.
Soundwave: A Configuration Management Database