--- title: "#167: TimescaleDB, DynamoDB, Presto and Zeppelin" publication: "DB Weekly" issue: 167 published_at: "2017-08-11" canonical_url: "https://dbweekly.com/issues/167" --- Database Weekly 167 This week's database news -[Read this on the Web](http://dbweekly.com/issues/167) [Database Weekly](http://dbweekly.com) Issue 167 — August 11, 2017 [TimescaleDB: An Open-Source Time-Series SQL Database](http://www.timescale.com/?utm_source=dbweekly&utm_medium=email) — Optimized for fast ingest, complex queries, and scalability, Timescale is based around PostgreSQL. Timescaletools [LinkedIn's Strategy for Migrating to Its Own Database](https://engineering.linkedin.com/blog/2017/08/migrating-from-oracle-to-espresso?utm_source=dbweekly&utm_medium=email) — LinkedIn’s strategy for migrating one of their internal services (Babylonia) from using Oracle to Espresso, LinkedIn’s own NoSQL database system. David Maxstory [M202: MongoDB for DBAs - A Free Online Course](https://university.mongodb.com/courses/M102/about?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q3&utm_content=primary&utm_medium=display&utm_source=dbweekly0811) — After completing this course, you should have a good understanding of how to administer a MongoDB installation in production. MONGODBsponsored [![\](https://copm.s3.amazonaws.com/07bf7ce1.png)](https://university.mongodb.com/courses/M102/about?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q3&utm_content=primary&utm_medium=display&utm_source=dbweekly0811) [Exploring Presto and Zeppelin for Fast Data Analytics and Visualization](https://medium.com/walmartlabs/exploring-presto-and-zeppelin-for-fast-data-analytics-and-visualization-9cb4dca91c3d?utm_source=dbweekly&utm_medium=email) — How WalMart use SQL query engine [Presto](https://prestodb.io/) and a look at its performance in some common use cases. Sandeep Maliktutorial [Working with AWS DynamoDB](https://blog.codeship.com/working-with-dynamodb/?utm_source=dbweekly&utm_medium=email) — _“The fully managed NoSQL database service DynamoDB is good if you don’t need to worry about scaling and handling large amounts of data.”_ Parth Moditutorial [Principles of Sharding for Relational Databases](https://www.citusdata.com/blog/2017/08/09/principles-of-sharding-for-relational-databases/?utm_source=dbweekly&utm_medium=email) — Opinions on sharding range from “it saved us” to “it was the worst mistake we made. This post looks at the key factors that play into sharding and how you should approach whether it’s right for you. citusdatastory [Did Google Send the Big Data Industry on a 10 Year Head Fake?](https://medium.com/@garyorenstein/did-google-send-the-big-data-industry-on-a-10-year-head-fake-9c94d553925a?utm_source=dbweekly&utm_medium=email) — Even in 2010 Google was recognizing the limits of non-relational systems, and began to course correct seven years ago. Gary Orensteinopinion [MongoDB Performance Issues: Fact or Fiction](http://www.kenwalger.com/blog/nosql/mongodb/mongodb-performance-issues/?utm_source=dbweekly&utm_medium=email) — A look at some of MongoDB’s common performance issues and where things sit now with the latest version, 3.4.6. Ken W.​ Algeropinion [A Live Demo With a VividCortex Engineer](https://www.vividcortex.com/live-product-demo?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=Weekly%20Live%20Demo) — Join a live demo with a VividCortex engineer to show how the VividCortex solution can eliminate your most critical visibility gaps. VividCortexsponsored [PostgreSQL 10 Beta 3 Released](https://www.postgresql.org/about/news/1771/?utm_source=dbweekly&utm_medium=email) postgresql.​orgnews [CouchDB 2.1.0 Released](http://docs.couchdb.org/en/2.1.0/whatsnew/2.1.html?utm_source=dbweekly&utm_medium=email) CouchDBnews [Geographic Analysis in SQL: Measuring Polygon Area from Latitude and Longitude](https://webflow-blog.periscopedata.com/blog/polygon-area-from-latitude-and-longitude-using-sql?utm_source=dbweekly&utm_medium=email) Sean Cooktutorial [Real-Time MySQL Performance Monitoring](http://www.databasejournal.com/features/mysql/real-time-mysql-performance-monitoring.html?utm_source=dbweekly&utm_medium=email) — Using MySQL monitoring tool [Monyog](https://www.webyog.com/product/monyog) to measure key metrics. Rob Gravelletutorial [How Docker Containers Helps SQL Server 2017 Shift Deployment to the Developer](https://thenewstack.io/sql-server-linux-will-fit-devops-flow/?utm_source=dbweekly&utm_medium=email) Mary Branscombestory [The New Math Driving NoSQL Analytics](https://www.datanami.com/2017/08/03/new-math-driving-nosql-analytics/?utm_source=dbweekly&utm_medium=email) Alex Woodiestory [Cassandra vs. MongoDB](https://scalegrid.io/blog/cassandra-vs-mongodb/?utm_source=dbweekly&utm_medium=email) — Considering the differences between Cassandra vs. MongoDB as the data store for your next project. scalegrid.​ioopinion sponsored [TimescaleDB vs. Postgres for Time-Series Work](https://blog.timescale.com/timescaledb-vs-6a696248104e?utm_source=dbweekly&utm_medium=email) — The first in a series of performance benchmarks comparing TimescaleDB to other databases for storing and analyzing time-series data. Rob Kieferopinion [Ask HN: Are ORMs Overkill for SQL Databases?](https://news.ycombinator.com/item?id=14931161&utm_source=dbweekly&utm_medium=email) Hacker Newsopinion [PgHero 2.0: A Performance Dashboard for Postgres](https://medium.com/@ankane/pghero-2-0-has-arrived-266c3874d012?utm_source=dbweekly&utm_medium=email) Andrew Kanetools [MyCLI: A MySQL/MariaDB Client with Syntax Highlighting and Autocompletion](https://dotlayer.com/mycli-mysqlmariadb-client-with-syntax-highlighting-and-autocompletion/?utm_source=dbweekly&utm_medium=email) Kylie Monroetools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/167) [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