Issue 149 — April 7, 2017
Featured
Building A Scalable Time-Series Database on Postgres — TimescaleDB is a new open-source time-series database optimized for fast ingest and complex queries.
Ajay Kulkarni story
SQLite 3.18 Released —
PRAGMA optimize has been added, a mechanism for attempting to optimize the database and improve long-term query performance. SQLite news
Apache Quickstep: A SQL-Based Performance-Focused DB Engine — Originating in 2011, but now being incubated at Apache, Quickstep competitively runs SSB and TPC-H benchmarks on a single node and is designed to support the latest in hardware technology for faster performance. GitHub repo.
Apache Foundation tools
Webinar: Better Azure SQL Performance — Learn how to reduce development times by getting a better understanding of how your Azure SQL workloads are really performing. Register now.
SelectStar sponsored
A Data Model for an Electric Power Distribution System — Vertabelo's database modelling scenarios continue to get more niche but it's always interesting to see how a professional database designer approaches the challenges involved.
Vertabelo tutorial
Business Intelligence Performance Benchmarks with Google BigQuery — A deeper look at Google’s BigQuery, and how it stacks up in the BI-on-Big Data ecosystem.
Joshua Klahr opinion
Redis Flash: Double Performance on NVMe SSDs — Redis Flash on AWS I3 instances (which have NVMe SSDs) gets up to 2.5x performance compared to on I2s.
Keren Ouaknine story
In brief
Alex Woodie news
Vito Botta tutorial
Language-Specific Views in MongoDB 3.4 — Building multiple filtered, language-specific views of a common collection using collations & partial indexes.
MONGODB tutorial sponsored
Roman Gaponov tutorial
Record Linking with Apache Spark's MLlib and GraphX — A scalable approach to fuzzy data matching.
Tom Lous tutorial
Citus Data tutorial
Nic Raboy tutorial
Database Journal tutorial
Why is January 1, 1753 The Minimum Date Value in SQL Server? — It’s Philip Stanhope, 4th Earl of Chesterfield’s fault.
Stack Overflow story
How to find and fix the slowest code in your .NET application — Find bottlenecks in your code or database & boost performance with ANTS Performance Profiler. Try it free now.
Red Gate tools sponsored
Ifrit: An SQL to MongoDB Query Compiler for Data Aggregation — Written in PureScript, a language that compiles to JS.
Matthias Benkort tools
Facebook Research tools