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

Database Weekly 115   . 

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

[Database Weekly](http://dbweekly.com) Issue 115 — July 29, 2016     

Featured [Why Uber Engineering Switched from Postgres to MySQL](https://eng.uber.com/mysql-migration/?utm_source=dbweekly&utm_medium=email) — Uber Engineering explains the technical reasoning behind its switch in database technologies _from_ Postgres _to_ MySQL - an uncommon direction to migrate in. Evan Klitzke ['Amazon RDS SQL Server Just Changed Everything.'](https://www.brentozar.com/archive/2016/07/holy-cow-amazon-rds-sql-server-just-changed-everything/?utm_source=dbweekly&utm_medium=email) — You can now take native SQL Server database backups from your RDS instances and store them in an Amazon S3 bucket. Brent Ozarnews [Democratizing Databases](http://news.mit.edu/2016/spreadsheet-databases-0708?utm_source=dbweekly&utm_medium=email) — With a new tool, any competent spreadsheet user can construct custom database interfaces. MIT Newsnews [The importance of loose coupling in REST API design](http://blog.dreamfactory.com/the-importance-of-loose-coupling-in-rest-api-design?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=coupling) — You should never develop a REST API for any specific application. The best approach is to build a REST API platform that can be used and reused in a flexible manner for general-purpose application development. DreamFactorysponsored [![\](https://copm.s3.amazonaws.com/c75ddbdc.png)](http://blog.dreamfactory.com/the-importance-of-loose-coupling-in-rest-api-design?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=coupling) [Real-World Redis Tips](https://blog.heroku.com/real-world-redis-tips?utm_source=dbweekly&utm_medium=email) — Use a connection pooler, give your clients names, set an appropriate key eviction policy, and more. Herokututorial [It’s The Data, Stupid: Why Database Admins Are More Important Than Ever](http://arstechnica.com/information-technology/2016/07/its-the-data-stupid-why-database-admins-are-more-important-than-ever/?utm_source=dbweekly&utm_medium=email) — Specialized databases, cloud, and DevOps expand, not eliminate, role of the DBA. Sean Gallagheropinion [Apache Spark 2.0 Released](https://databricks.com/blog/2016/07/26/introducing-apache-spark-2-0.html?utm_source=dbweekly&utm_medium=email) — Spark 2.0 focuses on significantly improved SQL support and the unification of the DataFrame and Dataset APIs. The next-gen Tungsten engine also compiles queries to make Spark 2.0 up to 10x faster than 1.x. [Release notes here.](http://spark.apache.org/releases/spark-release-2-0-0.html) Reynold Xinnews Jobs [Get 5+ Engineering Job Offers in 1 Week](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square Hired.​com In brief [Amazon Elasticsearch Service Now Supports Elasticsearch 2.3](https://aws.amazon.com/about-aws/whats-new/2016/07/amazon-elasticsearch-service-now-supports-elasticsearch-2-3/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [A Complete List of New Features in MySQL 5.7](http://www.thecompletelistoffeatures.com/?utm_source=dbweekly&utm_medium=email) Morgan Tockernews [Free t-shirt when you deploy RethinkDB in July](https://www.compose.io/articles/try-rethinkdb/?utm_source=cooper&utm_medium=db-weekly&utm_campaign=rethinkdb-shirt-july) — This month only we're giving away a free limited edition tshirt when you deploy RethinkDB on Compose. All deployments are free for 30-days. Composenews sponsored [Creating Ranked Position Time Series with SQL](https://periscopedata.com/blog//ranked-position-time-series.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [How to Deploy a Highly-Available MongoDB Replica Set on AWS](https://eladnava.com/deploy-a-highly-available-mongodb-replica-set-on-aws/?utm_source=dbweekly&utm_medium=email) — A comprehensive guide to setting up your own cluster. Elad Navatutorial [5 Ways to Improve Performance of Spark Applications](http://www.lewisgavin.co.uk/Spark-Performance/?utm_source=dbweekly&utm_medium=email) Lewis Gavintutorial [How Adding a UNIQUE Constraint on a One-to-One Relationship Helps Performance](https://blog.jooq.org/2016/07/14/how-adding-a-unique-constraint-on-a-onetoone-relationship-helps-performance/?utm_source=dbweekly&utm_medium=email) JOOQtutorial [How to Build An iOS Application with SQLite and GRDB.swift](https://medium.com/@gwendal.roue/how-to-build-an-ios-application-with-sqlite-and-grdb-swift-d023a06c29b3?utm_source=dbweekly&utm_medium=email) — How Swift protocols and immutability impact database accesses. Gwendal Rouétutorial [Rolling Retention Done Right in SQL](https://blog.treasuredata.com/blog/2016/07/22/rolling-retention-done-right-in-sql/?utm_source=dbweekly&utm_medium=email) — ‘Rolling retention’ is a key business metric SaaS companies, in particular, measure. Kiyoto Tamuratutorial [PostgreSQL, Backups and Everything You Need to Know](https://www.compose.com/articles/postgresql-backups-and-everything-you-need-to-know/?utm_source=dbweekly&utm_medium=email) Compose Articlestutorial [The Road to CouchDB 2.0](https://blog.couchdb.org/2016/07/25/the-road-to-couchdb-2-0/?utm_source=dbweekly&utm_medium=email) CouchDBstory [3 Tips for Selecting The Right Database for Your App](https://medium.com/@cloud66/3-tips-for-selecting-the-right-database-for-your-app-54047f8008cc?utm_source=dbweekly&utm_medium=email) Cloud 66opinion [Why We Chose Aerospike Over Other Databases](https://crowdfire.engineering/why-we-chose-aerospike-over-other-databases-1dfa2d66a292?utm_source=dbweekly&utm_medium=email) Amey Patilopinion [6 Reasons You Shouldn't Use Cron to Schedule Your MapReduce and Spark Jobs](http://beekeeperdata.com/posts/hadoop/2016/07/19/Cron-Alternatives-For-Hadoop.html?utm_source=dbweekly&utm_medium=email) Matthew Rathboneopinion [Splitting ACID: Towards RISC-Style Database Systems](https://jarulraj.blogspot.com/2016/07/splitting-acid-towards-risc-style.html?utm_source=dbweekly&utm_medium=email) — An interesting idea of splitting up ACID properties into smaller parts. Joy Arulrajopinion [A Postgres Perspective on MongoDB](http://bonesmoses.org/2016/07/15/pg-phriday-a-postgres-persepctive-on-mongodb/?utm_source=dbweekly&utm_medium=email) Shaun M.​ Thomasopinion [Graph Databases: Dataflow vs. Traditional Models](http://hackingdistributed.com/2016/07/27/graph-databases-dataflow-vs-traditional/?utm_source=dbweekly&utm_medium=email) — Thoughts on using differential dataflow to implement database functionality such as lookups and transactions. Dubey, Escriva, Gün Sireropinion [Way Better Log Management.](http://www.launchbit.com/taz/11159-6533-111) — Move beyond ssh & grep: Search 100s of GBs/sec right from your browser. Scalyrtools sponsored [Deform.io: A Very Simple Database-as-a-Service](https://deform.io/?utm_source=dbweekly&utm_medium=email) deform.​iotools [Fieldtop: Finds Near-Overflow Columns in MySQL Databases](https://github.com/wsdookadr/fieldtop?utm_source=dbweekly&utm_medium=email) — There’s [more info here.](https://blog.garage-coding.com/2016/07/21/check-fields-might-overflow.html) Stefan Corneliu Petreatools    

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