---
title: "#183: The Push for Data Modernization Today"
publication: "DB Weekly"
issue: 183
published_at: "2017-12-08"
canonical_url: "https://dbweekly.com/issues/183"
---

Database Weekly 183   

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

[Database Weekly](http://dbweekly.com) Issue 183 — December 8, 2017     

[SQL Window Functions Tutorial for Business Analysis](https://blog.statsbot.co/sql-window-functions-tutorial-b5075b87d129) — A look at the art of solving common business analysis problems (e.g. revenue growth, running totals) with SQL. Alex Yeskovtutorial [AntidoteDB: A Transactional Database with Strong Semantics](http://syncfree.github.io/antidote/) — Provides features that aid programmers to write ‘correct’ applications while being able to scale up to large geo-replicated deployments with Causal Highly-Available Transactions. It’s [open source](https://github.com/SyncFree/antidote) and built in Erlang. The Syncfree Consortiumtools [Postgres 11 To Add Support for 'SQL Procedures'](https://www.postgresql.org/message-id/E1eKRgh-0000CR-1U@gemulon.postgresql.org) — Work on the next major version of Postgres is underway with the latest addition being support for SQL procedures, as supported in Oracle and SQL Server. Peter Eisentrautnews [Linux cloud hosting starting at 1GB of RAM for $5/mo](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you’re ready to deploy your server. Get $20 credit on a new account. Linode Cloud Hostingsponsored [![\](https://copm.s3.amazonaws.com/27d43618.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [SiriDB: An Open Source Time Series Database](http://siridb.net/) — An open source time series database with a robust cluster mechanism that can scale on the fly. It can be easily used as a [data source for Grafana](https://github.com/transceptor-technology/grafana-siridb-http-example). SiriDBtools [Hadoop 3.0 Likely to Arrive Before Christmas](https://www.datanami.com/2017/12/05/hadoop-3-0-likely-arrive-christmas/) — ..plus more on what that will involve. Datanaminews [The Couchbase Ecosystem at LinkedIn](https://engineering.linkedin.com/blog/2017/12/couchbase-ecosystem-at-linkedin) — LinkedIn uses Couchbase as a highly scalable, distributed cache serving over 10 million queries per second. LinkedIn Engineeringstory [Embracing the Future: The Push for Data Modernization Today](https://www.datanami.com/2017/12/06/embracing-future-push-data-modernization-today/) — As we begin to produce far more data than we can reliably store, real-time in-memory stream processing will become a key part of any future data system. Datanamistory [There's One Big Reason That Postgres Can't Kill Oracle](https://www.techrepublic.com/article/theres-one-big-reason-that-postgres-cant-kill-oracle-and-its-not-the-technology/) — Postgres is popular but can’t unseat Oracle which continues to thrive with its contracts and ‘stickiness’. Matt Asayopinion [Data Prep Goes Serverless](https://www.datanami.com/2017/12/07/data-prep-goes-serverless/) — Cloud-based serverless data prep tools are making strong inroads with data analysts seeking new ETL tools looking to wrangle their own data sets. Datanamistory [ScaleGrid Announces Shared MongoDB Hosting on Amazon AWS](https://scalegrid.io/blog/scalegrid-announces-mongodb-shared-hosting-on-amazon-aws/) ScaleGridnews [Gain Insights into Database Performance Across Any Stack, at Any Scale](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeeklyS) — Datadog integrates seamlessly with 200+ technologies, including Postgres, MySQL, and MongoDB. [Try it for free](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeeklyS). Datadogsponsored [Monitoring RDS MySQL Performance Metrics](https://blog.monyog.com/monitoring-rds-mysql-performance-metrics/) Shree Nairtutorial [Deploy a Replicated MongoDB on AWS with Terraform & Ansible](https://blog.eleven-labs.com/en/deploy-a-replicated-mongodb-on-aws-with-terraform-and-ansible/) Vincent Composieuxtutorial [4 Challenges With Containerizing Databases at New Relic](https://blog.newrelic.com/2017/12/05/containerizing-databases/) Joshua Galbraithstory [Translytical Databases Hit the Ground Running](https://www.datanami.com/2017/12/06/translytical-databases-hit-ground-running/) — SAP, Oracle, Redis Labs, IBM and DataStax lead the way in this market for now. Datanamistory [A Guide for Customer Retention Analysis with SQL](https://blog.statsbot.co/customer-retention-analysis-93af9daee46b) — A great run through of some moderately complex but useful SQL for analyzing retention data of customers. Luba Belokon [Serverless Aurora: What It Means and Why It's The Future of Data](https://serverless.com/blog/serverless-aurora-future-of-data/) — What Serverless Aurora is, what it means for serverless developers, and why it may be the future of data. Alex DeBrieopinion [Why Old-School PostgreSQL Is So Hip Again](https://www.infoworld.com/article/3240064/sql/why-old-school-postgresql-is-so-hip-again.html) InfoWorldopinion [GoCD - Open Source Continuous Delivery Server](https://www.gocd.org/?utm_campaign=gocd_oss&utm_medium=email&utm_source=cooperess_db&utm_content=cloud_native&utm_term=) — A continuous delivery tool supporting modern infrastructure with elastic on-demand agents and cloud deployments. GoCDsponsored    

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