---
title: "This week's database news, issue 70"
publication: "DB Weekly"
issue: 70
published_at: "2015-09-10"
canonical_url: "https://dbweekly.com/issues/70"
---

Database Weekly 70   . 

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

[Database Weekly](http://dbweekly.com) Issue 70 — September 10, 2015     

Featured [Building A Prototype JavaScript Engine for MongoDB](http://thecalvinchan.com/blog/2015/09/05/faster-than-v8/?utm_source=dbweekly&utm_medium=email) — An in-depth look at work done by two MongoDB interns to significantly improve the performance of Mongo’s $where operator. Calvin Chan [Crab: Use Your SQL Skills to Analyze Files and Run Commands](http://etia.co.uk/?utm_source=dbweekly&utm_medium=email) — Essentially a sort of SQL-powered shell (imagine `select fullpath, bytes from files order by bytes desc limit 5;`). Currently Mac and Unix only. Free to evaluate but a (low priced) commercial product. Etiatools [From Search to Distributed Computing to Large-Scale Information Extraction [podcast\]](http://radar.oreilly.com/2015/09/from-search-to-distributed-computing-to-large-scale-information-extraction.html?utm_source=dbweekly&utm_medium=email) — Ben Lorica interviewed Mike Cafarella, co-creator of Hadoop, about the origins of Nutch, Hadoop, HBase, and his move to an academic career. O'Reilly Media [Real-time Database Monitoring at Any Scale with Datadog](http://dtdg.co/1PkYlNZ) — Use Datadog's turn-key integrations to seamlessly aggregate metrics and events across your databases and entire devops stack. Gain powerful insight into all your apps, tools and services. Start your Free Datadog Trial today. Datadogsponsored [![\](https://copm.s3.amazonaws.com/8d0c11d3.png)](http://dtdg.co/1PkYlNZ) [Contentless SQLite FTS4 Tables for Large Immutable Documents](http://cocoamine.net/blog/2015/09/07/contentless-fts4-for-large-immutable-documents/?utm_source=dbweekly&utm_medium=email) — If you use SQLite [FTS4](https://www.sqlite.org/fts3.html) for indexing large immutable documents, you might want to consider contentless tables. With minor adjustments, the database could be 2-3x smaller. Charles Parnot [TiDB: A Distributed SQL Database Written in Go](https://github.com/pingcap/tidb?utm_source=dbweekly&utm_medium=email) — Inspired by the design of Google F1, TiDB is a distributed SQL database with the best features of both traditional RDBMS and NoSQL. Still early days and not recommended for production. PingCAPcode [SQL vs NoSQL KO: Postgres vs Mongo](https://www.airpair.com/postgresql/posts/sql-vs-nosql-ko-postgres-vs-mongo?utm_source=dbweekly&utm_medium=email) — A thorough comparison of Postgres to Mongo (one of the predominant NoSQL databases). Instead of just performance benchmark fodder, this post does a great job helping educate about many of the differences along the way. Abraham Polishchuk [Life in A Redis Cluster: Meet and Gossip with Your Neighbors](http://cristian.regolo.cc/2015/09/05/life-in-a-redis-cluster.html?utm_source=dbweekly&utm_medium=email) — Since version 3.0, Redis can operate in ‘cluster’ mode, providing automatic data sharding across multiple nodes. Cristian Greco [MoSQL: A MongoDB to PostgreSQL Streaming Translator](https://github.com/stripe/mosql?utm_source=dbweekly&utm_medium=email) — Imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a Mongo database, and then run offline reporting using SQL. Stripetools [The Story of Why Web SQL Died](http://nolanlawson.com/2014/04/26/web-sql-database-in-memoriam/?utm_source=dbweekly&utm_medium=email) — This is an old post but I missed it first time around and it’s an interesting story. Nolan Lawsonopinion In brief [OSCON EU 2015: Amsterdam, October 26-28](http://www.oscon.com/open-source-eu-2015/?utm_source=dbweekly&utm_medium=email) — O'Reilly's OSCON open source conference is coming to Europe this October, featuring speakers like Douglas Crockford of PayPal and Leslie Hawthorn of Elastic. There's a data track too. oscon.​comnews [Spark 1.5.0 Released](http://spark.apache.org/releases/spark-release-1-5-0.html?utm_source=dbweekly&utm_medium=email) Apachenews [Apache Spark Gets IBM Mainframe Connection](http://www.datanami.com/2015/09/01/apache-spark-gets-ibm-mainframe-connection/?utm_source=dbweekly&utm_medium=email) Datanaminews [SAP Combines In-Memory Engine With Hadoop](http://www.datanami.com/2015/09/02/sap-combines-in-memory-engine-with-hadoop/?utm_source=dbweekly&utm_medium=email) — A new in-memory query engine designed to boost interactive analytics capabilities on Hadoop has been added to SAP HANA. Datanaminews [Building A Redis Clone in Haskell](https://honza.ca/2015/09/building-a-redis-clone-in-haskell?utm_source=dbweekly&utm_medium=email) — “In this post, we will attempt to make a simplified clone of Redis in Haskell.” Honza Pokornytutorial [Database Design: Managing Roles and Statuses in A System](http://www.vertabelo.com/blog/technical-articles/managing-roles-and-statuses-in-a-system?utm_source=dbweekly&utm_medium=email) Emil Drkušićtutorial [Remaining Agile with Billions of Documents with Creative MongoDB Schemas](https://www.mongodb.com/blog/post/remaining-agile-with-billions-of-documents-appboy-s-creative-mongodb-schemas?utm_source=dbweekly&utm_medium=email) Jon Hymantutorial [Connecting phpMyAdmin to Amazon RDS](http://msiman.ga/2015/09/connecting-phpmyadmin-amazon-rds?utm_source=dbweekly&utm_medium=email) MSIMantutorial [Solving the Traveling Salesman Problem with Postgres Recursive CTEs](https://www.periscope.io/blog/postgres-recursive-cte.html?hn=&utm_source=dbweekly&utm_medium=email) Periscopetutorial [Do the Math: Can Your Business Benefit From a Cloud Database?](http://tech.co/math-can-business-benefit-cloud-database-2015-08?utm_source=dbweekly&utm_medium=email) Baron Schwartzopinion [From 0 to 50GB with MongoDB in 3 Days](http://blog.scalingo.com/post/128641227693/from-0-to-50gb-mongodb-in-3-days?utm_source=dbweekly&utm_medium=email) Scalingoopinion [10 Reasons to Love SQLAlchemy](http://pajhome.org.uk/blog/10_reasons_to_love_sqlalchemy.html?utm_source=dbweekly&utm_medium=email) — The Python SQL toolkit and Object Relational Mapper. Paul Johnstonopinion [Strata: Open Source Library for Efficient MongoDB Backups](http://blog.parse.com/learn/engineering/strata-open-source-library-for-efficient-mongodb-backups/?utm_source=dbweekly&utm_medium=email) Travis Redmantools [GunDB: A Persisted Distributed Cache to the Browser](http://gun.js.org/?utm_source=dbweekly&utm_medium=email) Mark Nadaltools [Lovefield: A JavaScript Relational Database for Web Apps](https://google.github.io/lovefield/?utm_source=dbweekly&utm_medium=email) — There’s a [quick start guide](https://github.com/google/lovefield/blob/master/demos/todo/README.md) if you want to see the usage scenario right away. Googletools    

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