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

Database Weekly 106   . 

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

[Database Weekly](http://dbweekly.com) Issue 106 — May 26, 2016     

Featured [Apache Spark as a Compiler: Joining a Billion Rows on your Laptop](https://databricks.com/blog/2016/05/23/apache-spark-as-a-compiler-joining-a-billion-rows-per-second-on-a-laptop.html?utm_source=dbweekly&utm_medium=email) — A look at how Apache Spark acts as a compiler to optimize queries using whole-stage code generation techniques commonly used in language compilers. Sameer Agarwalstory [EnterpriseDB Wraps PostgreSQL Into An Enterprise-Grade Suite to Challenge Oracle](http://www.v3.co.uk/v3-uk/news/2458970/enterprisedb-wraps-postgresql-into-an-enterprise-grade-suite-to-challenge-oracle?utm_source=dbweekly&utm_medium=email) — EnterpriseDB has brought more tools into its Postgres distro to challenge big commercial DBs. Daniel Robinsonnews [A Look at the Design of SQLite4](https://sqlite.org/src4/doc/trunk/www/design.wiki?utm_source=dbweekly&utm_medium=email) — Described as “just like SQLite3, but with an improved interface and file format”, SQLite4 is going to be “an alternative, not a replacement, for SQLite3.” SQLitenews [TrailDB: An Efficient Library for Storing and Processing Event Data](http://tech.adroll.com/blog/data/2016/05/24/traildb-open-sourced.html?utm_source=dbweekly&utm_medium=email) — AdRoll has open sourced a fast, C-based library for compressing and handling time-series event data. Ville Tuuloscode [Have you got SQL fingers?](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24849#sql-fingers) — Watch these free SQL Prompt tips videos for SQL writing hints from top SQL Server MVPs. SQL Prompt is the SQL code productivity add-in for SQL Server Management Studio and Visual Studio. Find out how easily you can write SQL. Red Gatesponsored [![\](https://copm.s3.amazonaws.com/5acf2639.gif)](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24849#sql-fingers) [Unicorn: BigTable, Document and Graph Database with Full Text Search](https://github.com/haifengl/unicorn?utm_source=dbweekly&utm_medium=email) — A simple abstraction of BigTable-like databases such as Cassandra, HBase, and Accumulo that provides an easy-to-use document data model and MongoDB-like API. Haifeng Litools [Benchmarking Elasticsearch vs InfluxDB for Time-Series Data](https://vimeo.com/167961665?utm_source=dbweekly&utm_medium=email) — Some of the InfluxData team set out to compare the performance and features of InfluxDB and Elasticsearch for common time-series workloads. _(Note: InfluxData develops InfluxDB.)_ Shubhra Karvideo [Understanding Outliers with Skew and Kurtosis in SQL](https://periscopedata.com/blog//understanding-outliers-with-skew-and-kurtosis.html?utm_source=dbweekly&utm_medium=email) — _Skewness_ is a measure of the asymmetry of the probability distribution of a real-valued random variable about its mean, and kurtosis is a measure of the “tailedness” of the same distribution. Confused? Here’s a practical example. Periscopetutorial [Efficient Pagination in SQL and ElasticSearch](http://blog.salsify.com/engineering/efficient-pagination-in-sql-and-elasticsearch?utm_source=dbweekly&utm_medium=email) — Traditional pagination queries can have a high hidden cost. Here, an interesting technique to make pagination more efficient is explored. Salsifytutorial [Monitoring MongoDB Performance Metrics](https://www.datadoghq.com/blog/monitoring-mongodb-performance-metrics-wiredtiger/?utm_source=dbweekly&utm_medium=email) — By properly monitoring MongoDB you can quickly spot slowdowns, or pressing resource limitations, and know how to fix performance issues. This series covers WiredTiger but there’s a [MMAP edition](https://www.datadoghq.com/blog/monitoring-mongodb-performance-metrics-mmap/) too. Jean-Mathieu Saponarotutorial [Scaling to 100M: MySQL is a Better NoSQL](http://blog.wix.engineering/2015/12/10/scaling-to-100m-mysql-is-a-better-nosql/?utm_source=dbweekly&utm_medium=email) — When considering a NoSQL use case, such as key/value storage, MySQL made more sense to Wix in terms of performance, ease of use, and stability. Yoav Abrahamiopinion Jobs [Job Offers. No resume necessary.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=noresume&utm_campaign=q2-16-dbweekly&utm_location=us) — Create your Hired profile to get top companies to start applying to hire you. Get offers from $75,000 - $250,000 on the platform in 1 week. Hired.​com In brief [How Spark and Hadoop Are Advancing Cancer Research](http://www.datanami.com/2016/05/23/spark-hadoop-advancing-cancer-research/?utm_source=dbweekly&utm_medium=email) Alex Woodienews [Here's The Slide Deck MySQL Used to Raise $16 Million in 2003](http://tech.eu/features/9655/mysql-series-b-round-pitch-deck/?utm_source=dbweekly&utm_medium=email) Robin Wautersnews [Amazon Redshift Gets Up to 2X Throughput and 10X Vacuuming Performance Improvements](https://aws.amazon.com/blogs/aws/amazon-redshift-up-to-2x-throughput-and-10x-vacuuming-performance-improvements/?utm_source=dbweekly&utm_medium=email) Amazon Web Servicesnews [Cray Unveils Open Source 'Big Data' Box](http://www.theregister.co.uk/2016/05/24/cray_branches_into_analytics/?utm_source=dbweekly&utm_medium=email) — Serious metal with 35TB of PCIe SSD storage, 22TB of RAM, and preloaded with OpenStack and Mesos. The Registernews [How we improved query response times 6X with Apache Storm and Cassandra](https://keen.io/blog/140219557931/guaranteeing-consistent-api-performance-with?s=database-weekly) — Keen IO platform engineer shares lessons learned while scaling out their analytics infrastructure with Apache Storm and Cassandra. Keen IOstory sponsored [Data Types in PostgreSQL](http://postgres-data-types.pvh.ca/?utm_source=dbweekly&utm_medium=email#1) — A 128 page slidedeck ‘guided tour’ through PostgreSQL data types. Peter van Hardenberg [Postgres & Redis Sitting In a Tree](https://speakerdeck.com/neovintage/postgres-and-redis-sitting-in-a-tree?utm_source=dbweekly&utm_medium=email) — “Typically a company may start with a relational database like Postgres and then add Redis for more high velocity use-cases. What if you could tie the two systems together to enable so much more?” Rimas Silkaitis [Converting MySQL Syntax and Functions into Redshift](https://periscopedata.com/blog//converting-mysql-syntax-and-functions-into-redshift.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Event Logging with ElasticSearch from the Browser](http://blog.cloudoki.com/event-logging-elasticsearch/?utm_source=dbweekly&utm_medium=email) Edgar Ribeirotutorial tools [MySQL By Examples for Beginners](https://www.ntu.edu.sg/home/ehchua/programming/sql/MySQL_Beginner.html?utm_source=dbweekly&utm_medium=email) Chua Hock-Chuantutorial [Creating Pivot Tables in PostgreSQL Using the Crosstab Function](http://www.vertabelo.com/blog/technical-articles/creating-pivot-tables-in-postgresql-using-the-crosstab-function?utm_source=dbweekly&utm_medium=email) — The ‘tablefunc’ extension provides a really interesting set of functions. One of them is the crosstab function, used for pivot table creation. That’s what this article covers. Maria Alcaraztutorial [How to Move From Amazon RDS to A Dedicated PostgreSQL Server](http://layer0.authentise.com/how-to-move-from-amazon-rds-to-dedicated-postgresql-server.html?utm_source=dbweekly&utm_medium=email) Authentise, Inctutorial [Is A RID Lookup Faster Than A Key Lookup On SQL Server?](http://sqlperformance.com/2016/05/sql-indexes/rid-lookup-faster-key-lookup?utm_source=dbweekly&utm_medium=email) Aaron Bertrandopinion [7 Reasons to Choose A File System (SolFS) Over a DB for Managing App Data](https://www.eldos.com/solfs/articles/7853.php?page=all&utm_source=dbweekly&utm_medium=email#) Eldosopinion [DreamFactory 2.1.2 released, includes app packages](http://blog.dreamfactory.com/dreamfactory-2-1-2-release?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=212) — Join data between a SQL database and MongoDB with a few configuration clicks. DreamFactorytools sponsored [SQL and NoSQL Databases Ranked by StackOverflow Activity](http://www.stackoverkill.com/ranking/sql-nosql?utm_source=dbweekly&utm_medium=email) — MySQL and SQL Server are well out in the lead. StackOverkilltools [countminsketch: An Apporximate Frequency Counter Module for Redis](https://github.com/RedisLabsModules/countminsketch?utm_source=dbweekly&utm_medium=email) Redis Labs Modulescode    

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