---
title: "This week's database news, issue 149"
publication: "DB Weekly"
issue: 149
published_at: "2017-04-07"
canonical_url: "https://dbweekly.com/issues/149"
---

Database Weekly 149   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/149) 

[Database Weekly](http://dbweekly.com) Issue 149 — April 7, 2017     

Featured [Building A Scalable Time-Series Database on Postgres](https://blog.timescale.com/when-boring-is-awesome-building-a-scalable-time-series-database-on-postgresql-2900ea453ee2?utm_source=dbweekly&utm_medium=email) — [TimescaleDB](http://www.timescale.com/) is a new open-source time-series database optimized for fast ingest and complex queries. Ajay Kulkarnistory [SQLite 3.18 Released](https://www.sqlite.org/releaselog/3_18_0.html?utm_source=dbweekly&utm_medium=email) — `PRAGMA optimize` has been added, a mechanism for attempting to optimize the database and improve long-term query performance. SQLitenews [Apache Quickstep: A SQL-Based Performance-Focused DB Engine](http://quickstep.incubator.apache.org/?utm_source=dbweekly&utm_medium=email) — 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.](https://github.com/apache/incubator-quickstep) Apache Foundationtools [Webinar: Better Azure SQL Performance](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205) — Learn how to reduce development times by getting a better understanding of how your Azure SQL workloads are really performing. [Register now](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205). SelectStarsponsored [![\](https://copm.s3.amazonaws.com/039b7b86.png)](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205) [A Data Model for an Electric Power Distribution System](http://www.vertabelo.com/blog/technical-articles/a-data-model-for-an-electric-power-distribution-system?utm_source=dbweekly&utm_medium=email) — 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. Vertabelotutorial [Business Intelligence Performance Benchmarks with Google BigQuery](http://blog.atscale.com/BI-Benchmarks-with-Google-BigQuery?utm_source=dbweekly&utm_medium=email) — A deeper look at Google’s BigQuery, and how it stacks up in the BI-on-Big Data ecosystem. Joshua Klahropinion [Redis Flash: Double Performance on NVMe SSDs](https://redislabs.com/blog/redis-flash-double-performance-nvme/?utm_source=dbweekly&utm_medium=email) — Redis Flash on [AWS I3 instances](https://aws.amazon.com/blogs/aws/now-available-i3-instances-for-demanding-io-intensive-applications/) (which have NVMe SSDs) gets up to 2.5x performance compared to on I2s. Keren Ouakninestory In brief [Meet Ray, The Real-Time Machine-Learning Replacement for Spark](https://www.datanami.com/2017/03/28/meet-ray-real-time-machine-learning-replacement-spark/?utm_source=dbweekly&utm_medium=email) Alex Woodienews [Data Compression Improvements in Amazon Redshift Bring Compression Ratios Up to 4x](https://aws.amazon.com/blogs/aws/data-compression-improvements-in-amazon-redshift/?utm_source=dbweekly&utm_medium=email) Amazonnews [Getting Started with Apache Cassandra (with Ruby)](https://vitobotta.com/2017/04/02/getting-started-with-apache-cassandra/?utm_source=dbweekly&utm_medium=email) Vito Bottatutorial [Language-Specific Views in MongoDB 3.4](https://www.mongodb.com/blog/post/language-specific-views-in-mongodb-34?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored&utm_medium=email&utm_source=dbweekly) — Building multiple filtered, language-specific views of a common collection using collations & partial indexes. MONGODBtutorial sponsored [Docker: Getting Started with Python, Redis, and NGINX](https://hackernoon.com/docker-tutorial-getting-started-with-python-redis-and-nginx-81a9d740d091?utm_source=dbweekly&utm_medium=email) Roman Gaponovtutorial [Record Linking with Apache Spark's MLlib and GraphX](https://medium.com/@tomlous/record-linking-with-apache-sparks-mllib-graphx-d118c5f31f83?utm_source=dbweekly&utm_medium=email) — A scalable approach to fuzzy data matching. Tom Loustutorial [Distributed COUNT(DISTINCT) with HyperLogLog on Postgres](https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/?utm_source=dbweekly&utm_medium=email) Citus Datatutorial [Deploy a Couchbase + Node Webapp as Docker Containers](https://blog.couchbase.com/deploy-node-js-couchbase-web-application-docker-containers/?utm_source=dbweekly&utm_medium=email) Nic Raboytutorial [Backing Up SQL Server Databases Hosted on Azure VMs](http://www.databasejournal.com/features/mssql/backing-up-sql-server-databases-hosted-on-azure-vms.html?utm_source=dbweekly&utm_medium=email) Database Journaltutorial [Why is January 1, 1753 The Minimum Date Value in SQL Server?](http://stackoverflow.com/questions/3310569/what-is-the-significance-of-1-1-1753-in-sql-server?utm_source=dbweekly&utm_medium=email) — It’s Philip Stanhope, 4th Earl of Chesterfield’s fault. Stack Overflowstory [How Can I Impress at a DBA Job Interview With Little Experience?](https://www.reddit.com/r/Database/comments/63vsuj/got_a_dba_interview_with_no_experience_i_want_to/?utm_source=dbweekly&utm_medium=email) Redditopinion [How to find and fix the slowest code in your .NET application](http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/?utm_source=dbweekly&utm_medium=email&utm_content=slowest_code&utm_campaign=antsperformanceprofiler&utm_term=email-25725) — Find bottlenecks in your code or database & boost performance with ANTS Performance Profiler. [Try it free now](http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/?utm_source=dbweekly&utm_medium=displayemail&utm_content=slowest_code&utm_campaign=antsperformanceprofiler&utm_term=email-25725). Red Gatetools sponsored [Ifrit: An SQL to MongoDB Query Compiler for Data Aggregation](https://github.com/KtorZ/purescript-ifrit?utm_source=dbweekly&utm_medium=email) — Written in PureScript, a language that compiles to JS. Matthias Benkorttools [Prophet: Forecasting At Scale from Python and R](https://research.fb.com/prophet-forecasting-at-scale/?utm_source=dbweekly&utm_medium=email) Facebook Researchtools    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/149) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK