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

Database Weekly 107   . 

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

[Database Weekly](http://dbweekly.com) Issue 107 — June 2, 2016     

Featured [SQL Server 2016 Now Generally Available](https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/?utm_source=dbweekly&utm_medium=email) — Includes updateable, in-memory columnstores, R integration, and improved cross-platform analytics (such as with [PolyBase](https://msdn.microsoft.com/en-us/library/mt143171.aspx)). Microsofttools [Comparing CHAR and VARCHAR Types in Different DB Engines](http://www.vertabelo.com/blog/technical-articles/comparing-char-and-varchar-data-types-in-different-database-engines?utm_source=dbweekly&utm_medium=email) — Database storage engines frequently spring up surprises - this roundup looks at the various ways MySQL, SQLite, Postgres, Oracle and SQL Server deal with CHAR and VARCHAR types. Vertabelotutorial [See inside your Redis database. New memory mapping from RedisGreen](http://www.redisgreen.net/memory-analysis/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2016b&utm_content=primary&utm_term=inside+memory+map) — RedisGreen builds a map of your Redis memory usage, tracking the size of keys over time, helping you track down problems and gain new insights. RedisGreensponsored [![\](https://copm.s3.amazonaws.com/f8dc7edd.png)](http://www.redisgreen.net/memory-analysis/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2016b&utm_content=primary&utm_term=inside+memory+map) [BigBash: Convert SQL SELECTs to Bash One-Liners](https://github.com/zalando/bigbash?utm_source=dbweekly&utm_medium=email) — Converts select statements to Bash one-liners that are executable directly on CSV, log files & similar files. Zalando SEtools [Looking Inside The MySQL 5.7 Document Store](https://www.percona.com/blog/2016/05/24/looking-inside-the-mysql-5-7-document-store/?utm_source=dbweekly&utm_medium=email) — A quick demonstration of how MySQL’s new document storage feature works. Alexander Rubintutorial [Extending The Redis Database](https://www.oreilly.com/ideas/extending-the-redis-database?utm_source=dbweekly&utm_medium=email) — A 10 minute discussion with Redis creator Salvatore Sanfilippo about Redis’ new module system. Rachel Roumeliotis [Monitoring Cassandra at Scale](http://engineeringblog.yelp.com/2016/06/monitoring-cassandra-at-scale.html?utm_source=dbweekly&utm_medium=email) — Yelp uses Cassandra heavily and while it’s built to deal with failure, robust monitoring is essential at their scale. Joseph Lynchtutorial Jobs [Work on a Better Stack](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=betterstack&utm_campaign=q2-16-dbweekly&utm_location=us) — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly. Hired.​com In brief [Big Data and the Cloud: Uncover New Insights Hiding in Your Data](http://www.datanami.com/2016/05/30/big-data-cloud-uncover-new-insights-hiding-data/?utm_source=dbweekly&utm_medium=email) Datanaminews [Export Redis Snapshots from ElastiCache to Amazon S3](https://aws.amazon.com/blogs/aws/amazon-elasticache-update-export-redis-snapshots-to-amazon-s3/?utm_source=dbweekly&utm_medium=email) Amazonnews [On-demand Webinar: Turbocharge Your SQL Queries In-Memory with Apache® Ignite™](http://go.gridgain.com/Webinar-TurbochargeSQL-DBWeekly.html) — Learn how to boost performance 1,000X and scale to over 1 billion transactions per second with your SQL-based applications. GridGain In-Memory Data Fabricsponsored [Building an Application with CockroachDB and SQLAlchemy](https://www.cockroachlabs.com/blog/building-application-cockroachdb-sqlalchemy-2/?utm_source=dbweekly&utm_medium=email) Ben Darnelltutorial [5 Useful Tips to Make Your Hadoop Deployment Robust](http://jethro.io/blog/5-useful-tips-for-making-your-hadoop-deployment-robust/?utm_source=dbweekly&utm_medium=email) Noam Hassontutorial [Setting Up Elasticsearch for a Blog](https://ponyfoo.com/articles/setting-up-elasticsearch-for-a-blog?utm_source=dbweekly&utm_medium=email) Nicolás Bevacquatutorial [Using Elasticsearch Aggregations for Analytics](https://qbox.io/blog/elasticsearch-aggregations-for-analytics?utm_source=dbweekly&utm_medium=email) Igor Bobriakovtutorial [Mutating Table Error In Oracle: Why It Happens And What You Can Do About It](http://www.databasejournal.com/features/oracle/mutating-table-errorin-oraclewhyithappensand-what-you-can-doabout-it.html?utm_source=dbweekly&utm_medium=email) David Fitzjarrelltutorial [Redesigning A Notification System using Postgres](http://blog.garage-coding.com/2016/05/25/redesigning-notification.html?utm_source=dbweekly&utm_medium=email) Upstatstutorial [Merging Batch and Stream Processing in a Post Lambda World](http://www.datanami.com/2016/06/01/merging-batch-streaming-post-lambda-world/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [One Call to Rule Them All](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=onecall) — Access SQL and NoSQL databases across multiple servers with a singular REST API. Free, open source platform. DreamFactorytools sponsored [ElectroCRUD: A Modern MySQL CRUD Application](http://garrylachman.github.io/ElectroCRUD/?utm_source=dbweekly&utm_medium=email) Garry Lachmancode [libsqlfs: Implements A POSIX-Style Filesystem on top of SQLite](https://github.com/guardianproject/libsqlfs?utm_source=dbweekly&utm_medium=email) Guardian Projectcode [Miniredis: A Pure Go Redis Server, Ideal for Unit Tests](https://github.com/alicebob/miniredis?utm_source=dbweekly&utm_medium=email) Harmencode [How Netflix Caches App Data Using SSDs](http://techblog.netflix.com/2016/05/application-data-caching-using-ssds.html?m=1&utm_source=dbweekly&utm_medium=email) The Netflix Tech Blogstory    

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