---
title: "#178: TileDB, a Multi-Dimensional Array Storage System"
publication: "DB Weekly"
issue: 178
published_at: "2017-10-27"
canonical_url: "https://dbweekly.com/issues/178"
---

Database Weekly 178   

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

[Database Weekly](http://dbweekly.com) Issue 178 — October 27, 2017     

[TileDB: A Multi-Dimensional Array Data Management System](http://www.tiledb.io/) — A database that started life at MIT and Intel that’s designed for storing massive dense and sparse multi-dimensional array data. TileDB, Inc.​ tools [ELI5: How Does A Database Handle 1B Users?](https://www.reddit.com/r/explainlikeimfive/comments/78ppdo/eli5_how_does_a_database_handle_1_billion_users/) — It was interesting to see a popular question on database scaling on Reddit’s ‘Explain Like I’m 5’ sub-Reddit this week. Redditstory [Diagnose query latency with Datadog](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeeklyP) — To get to the bottom of database performance issues, you need high-resolution data from all your systems. See metrics from all your database instances, client applications, load balancers, and more with Datadog. Datadogsponsored [![\](https://copm.s3.amazonaws.com/3cb786b1.png)](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeeklyP) [Postgres 10 vs. TimescaleDB for Time-Series Data](https://blog.timescale.com/time-series-data-postgresql-10-vs-timescaledb-816ee808bac5) — PostgreSQL 10 promises an easier partitioning mechanism to help scale for big data. But how does that compare to TimescaleDB for time-series workloads? Erik Nordströmopinion [Amazon Aurora Now with PostgreSQL Compatibility](https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/) — AWS Aurora which helps you grow beyond the 6TB limit of RDS is now generally available for Postgres on top of RDS. Jeff Barrnews [How to Dump Google Analytics for SQL in 3 Hours](https://lugassy.net/how-i-created-better-google-analytics-in-3-hours-5758b3ffd146) — A look at using cloud services to track requests to a tracking pixel and then using BigQuery to analyze the results. Michael Lugassytutorial [Open-Source ML Server 'PredictionIO' Gets Apache Promotion](https://www.datanami.com/2017/10/24/open-source-ml-server-gets-apache-promotion/) — Apache PredictionIO, an open source machine learning server and toolset, is now a ‘top level’ Apache project. Datanaminews [Postgres Domain Integrity In Depth](https://begriffs.com/posts/2017-10-21-sql-domain-integrity.html) — An extensive write up about ways to keep your data ‘squeaky clean’ by way of integrity constraints. There’s a _lot_ to learn from here. Joe Nelsontutorial [World-Class Data Engineering with Amazon Redshift](https://world-class-amazon-redshift.eventbrite.com/?aff=DBWeekly) — Join us on Nov 17 in San Francisco for 2.5 hours private training. Get $100 off with the code “DBWEEKLY”. intermix.​iosponsored [SQLite 3.21.0 Released](https://sqlite.org/releaselog/3_21_0.html) — Mostly tweaks, fixes, and optimizations. SQLitenews [7 Keys to Better MySQL Performance](https://www.infoworld.com/article/3234637/sql/7-keys-to-better-mysql-performance.html) Peter Zaitsevtutorial [Real-Time Databases Explained: Why Meteor, RethinkDB, Parse and Firebase Don't Scale](https://www.youtube.com/watch?v=HiQgQ88AdYo) — There’s [an article covering the same ground.](https://medium.baqend.com/real-time-databases-explained-why-meteor-rethinkdb-parse-and-firebase-dont-scale-822ff87d2f87) Wolfram Wingerathvideo [The Best Bits of Postgres 10 for Developers](http://www.cybertec.at/best-of-postgresql-10-for-the-developer/) — A brief overview of some favourite developer-focused features in Postgres 10. Kaarel Moppelopinion [Data Squeeze: Hadoop Utility to Compact Small Files](https://expediaincecommerceplatform.github.io/dataSqueeze/) expediaincecommerceplatform.​github.​iotools [GoCD - Open Source Continuous Delivery Server](https://www.gocd.org/?utm_campaign=gocd_oss&utm_medium=email&utm_source=cooperess_db&utm_content=go_website&utm_term=) — Open source continuous delivery tool specializing in advanced workflow modeling and dependency management. GoCDtools sponsored [Reflow: A Language and Runtime for Distributed, Incremental Data Processing in the Cloud](https://github.com/grailbio/reflow) Grailcode [Hyrise: An In-Memory Hybrid Storage Engine](https://github.com/hyrise/hyrise) — [Further explanation.](https://hpi.de/plattner/projects/hyrise.html) Hyrisecode [Spydra: Ephemeral Hadoop Clusters using Google Compute Platform](https://github.com/spotify/spydra) Spotifycode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/178) [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