#183: The Push for Data Modernization Today

This week's database news - Read this on the Web

Database Weekly Issue 183 — December 8, 2017

SQL Window Functions Tutorial for Business Analysis — A look at the art of solving common business analysis problems (e.g. revenue growth, running totals) with SQL. Alex Yeskov   tutorial   AntidoteDB: A Transactional Database with Strong Semantics — 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 and built in Erlang. The Syncfree Consortium   tools   Postgres 11 To Add Support for 'SQL Procedures' — 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 Eisentraut   news   Linux cloud hosting starting at 1GB of RAM for $5/mo — 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 Hosting   sponsored   SiriDB: An Open Source Time Series Database — 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. SiriDB   tools   Hadoop 3.0 Likely to Arrive Before Christmas — ..plus more on what that will involve. Datanami   news   The Couchbase Ecosystem at LinkedIn — LinkedIn uses Couchbase as a highly scalable, distributed cache serving over 10 million queries per second. LinkedIn Engineering   story   Embracing the Future: The Push for 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. Datanami   story   There's One Big Reason That Postgres Can't Kill Oracle — Postgres is popular but can’t unseat Oracle which continues to thrive with its contracts and ‘stickiness’. Matt Asay   opinion   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. Datanami   story   ScaleGrid Announces Shared MongoDB Hosting on Amazon AWS ScaleGrid   news   Gain Insights into Database Performance Across Any Stack, at Any Scale — Datadog integrates seamlessly with 200+ technologies, including Postgres, MySQL, and MongoDB. Try it for free. Datadog   sponsored   Monitoring RDS MySQL Performance Metrics Shree Nair   tutorial   Deploy a Replicated MongoDB on AWS with Terraform & Ansible Vincent Composieux   tutorial   4 Challenges With Containerizing Databases at New Relic Joshua Galbraith   story   Translytical Databases Hit the Ground Running — SAP, Oracle, Redis Labs, IBM and DataStax lead the way in this market for now. Datanami   story   A Guide for Customer Retention Analysis with SQL — 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 — What Serverless Aurora is, what it means for serverless developers, and why it may be the future of data. Alex DeBrie   opinion   Why Old-School PostgreSQL Is So Hip Again InfoWorld   opinion   GoCD - Open Source Continuous Delivery Server — A continuous delivery tool supporting modern infrastructure with elastic on-demand agents and cloud deployments. GoCD   sponsored   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK