--- title: "This week's database news, issue 108" publication: "DB Weekly" issue: 108 published_at: "2016-06-09" canonical_url: "https://dbweekly.com/issues/108" --- Database Weekly 108 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/108) [Database Weekly](http://dbweekly.com) Issue 108 — June 9, 2016 Featured Be warned, there's a heavy dose of Apache Spark in this week's issue, thanks to this week's Spark Summit bringing lots of news out of the woodwork :-) [Why Spark Is On Fire: A Conversation with Creator Matei Zaharia](http://siliconangle.com/blog/2016/06/08/why-spark-is-on-fire-a-conversation-with-creator-matei-zaharia/?utm_source=dbweekly&utm_medium=email) — Apache Spark, the open source framework for distributing computing across clusters of machines, has caught on like wildfire among companies looking for insights from their growing masses of data. Robert Hofnews [MongoDB Queries Don’t Always Return All Matching Documents](https://engineering.meteor.com/mongodb-queries-dont-always-return-all-matching-documents-654b6594a827?utm_source=dbweekly&utm_medium=email) — It’s essential to understand some of MongoDB’s characteristics before scaling it up significantly in production to get the results you expect. David Glasserstory [Why Some of The Fastest Growing DBs Are Also The Most Experimental](http://www.techrepublic.com/article/why-some-of-the-fastest-growing-databases-are-also-the-most-experimental/?utm_source=dbweekly&utm_medium=email) — Everyone has heard about MongoDB and Cassandra, but what other databases are making big gains against Oracle and Microsoft? Matt Asayopinion [Try Compose Elasticsearch, Get a Shirt](https://www.compose.io/articles/try-elasticsearch/?utm_source=cooper&utm_medium=db-weekly&utm_campaign=elasticsearch-tshirt) — Have you been wanting to try Elasticsearch? This month only, get a limited edition t-shirt when you deploy Elasticsearch on Compose. All new accounts are completely free for 30-days. Composesponsored — [![\](https://copm.s3.amazonaws.com/532c86a3.png)](https://www.compose.io/articles/try-elasticsearch/?utm_source=cooper&utm_medium=db-weekly&utm_campaign=elasticsearch-tshirt) [Google BigQuery Gets Beta Standard SQL Support](http://venturebeat.com/2016/06/02/google-bigquery-gets-standard-sql-support-in-beta/?utm_source=dbweekly&utm_medium=email) — Till now, you’ve had to query BigQuery with the SQL-like BQL (BigQuery Query Language) but now full SQL support is coming to the popular data warehouse service. Jordan Novetnews [Correlated Subqueries Are Evil and Slow. Or Are They?](https://blog.jooq.org/2016/05/27/correlated-subqueries-are-evil-and-slow-or-are-they/?utm_source=dbweekly&utm_medium=email) — A common myth in SQL is the idea that correlated subqueries are slow, but here’s a look at why you should always test for your specific circumstances. Lukas Edertutorial [Planning A Simple Online Store Data Model](http://www.vertabelo.com/blog/technical-articles/a-simple-online-store-model-sell-ship-and-get-paid?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s long line of common database use case visualizations. This time, how you’d lay out a simple online store’s data model. Vertabelotutorial [5 Mistakes Beginners Make When Working with Databases](http://www.craigkerstiens.com/2016/06/07/five-mistakes-databases/?utm_source=dbweekly&utm_medium=email) — “There’s a number of bad practices that tend to get picked up when working with databases, here’s a rundown of just a few.” Craig Kerstiensopinion [5 Reasons You Should Use SQLite in 2016](http://charlesleifer.com/blog/five-reasons-you-should-use-sqlite-in-2016/?utm_source=dbweekly&utm_medium=email) — Reposting in case you missed this earlier in the year - SQLite is frequently underestimated, but there are many compelling reasons to use it in various contexts. Charles Leiferopinion [Using Spark for Anomaly (Fraud) Detection](https://micvog.com/2016/05/21/using-spark-for-anomaly-fraud-detection/?utm_source=dbweekly&utm_medium=email) — Anomaly detection is a method used to detect outliers in a dataset and take some action, e.g. fraudulent transactions. Michael Vogiatzistutorial 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 [Microsoft Announces Major Commitment to Apache Spark](https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/06/microsoft-announces-major-commitment-to-apache-spark/?utm_source=dbweekly&utm_medium=email) — Both Spark and R are making their way into most of Microsoft’s big data and analytics offerings. Microsoftnews [Apache Spark Adoption by the Numbers](http://www.datanami.com/2016/06/08/apache-spark-adoption-numbers/?utm_source=dbweekly&utm_medium=email) — It’s the top open source big data project of the moment. Datanaminews [Hadoop 3 Poised to Boost Storage Capacity, Resilience with Erasure Coding](http://www.datanami.com/2016/05/18/hadoop-3-poised-boost-storage-capacity-resilience-erasure-coding/?utm_source=dbweekly&utm_medium=email) Datanaminews [Corporate Giving: EDB’s Contributions to PostgreSQL](http://www.enterprisedb.com/postgres-plus-edb-blog/robert-haas/corporate-giving-edb-s-contributions-postgresql?src=20160609DBWk_EDBContrib96) — Robert Hass outlines some of EDB’s recent contributions to the PostgreSQL ecosystem. Like any other company that supports PostgreSQL, EDB makes technical contributions to the PostgreSQL community in a variety of ways: code; patch review, testing, and commit; external tools; and packaging. EnterpriseDBnews sponsored [Proposing a 'Stream' Data Type for Redis](https://github.com/redis/redis-rcp/blob/master/RCP11.md?utm_source=dbweekly&utm_medium=email) Salvatore Sanfilipponews [Apache Cassandra 3.6 Released](https://lists.apache.org/thread.html/62881564d20e279f41284b2d436a9d92245d5626321f96a2f832c058@%3Cdev.cassandra.apache.org%3E?utm_source=dbweekly&utm_medium=email) apache.​orgnews [Spark Makes Inroads into NoSQL Ecosystem](http://www.datanami.com/2016/06/06/spark-makes-inroads-nosql-ecosystem/?utm_source=dbweekly&utm_medium=email) — “The primary use case for deploying Spark and NoSQL databases together involves bridging the transactional and analytic divide.” Datanaminews [Calculating Distance Between Points on a Globe with SQL](https://periscopedata.com/blog/calculating-distance-between-data-centers-on-a-globe.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Calculating Common Salesforce Reports in SQL](https://periscopedata.com/blog//common-salesforce-reports-in-sql.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Packet Capturing MySQL with Rust](http://www.agildata.com/packet-capturing-mysql-with-rust/?utm_source=dbweekly&utm_medium=email) Paul LaCrossetutorial [19 Resources for Learning About Database Design Errors](http://www.vertabelo.com/blog/notes-from-the-lab/19-online-resources-for-learning-about-database-design-errors?utm_source=dbweekly&utm_medium=email) Jeffrey Edisontutorial [Postgres 9.6 New Features with Examples (PDF)](http://community.hpe.com/hpeb/attachments/hpeb/JapanEnterpriseTopics/198/1/PostgreSQL%209.6%20New%20Features%20en%2020160606-1.pdf?utm_source=dbweekly&utm_medium=email) — A thorough 50 page (PDF) guide to the new features. Hewlett Packard Enterprisetutorial [Beverly Hills 90210 and ZIP+4: Handling Addresses in Data Models](http://www.vertabelo.com/blog/technical-articles/beverly-hills-90210-and-zip-plus-4-handling-addresses-in-data-models?utm_source=dbweekly&utm_medium=email) Jeffrey Edisontutorial [Find Redis Memory Leaks with RedisGreen](http://www.redisgreen.net/memory-analysis/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2016b&utm_content=link&utm_term=memory+leaks) — RedisGreen's new memory map models your database, helping you track down problems and gain new insights. RedisGreentools sponsored [miniDBA Desktop: A Free Dashboard Tool for SQL Server](http://www.minidba.com/Home/Free-Sql-Server-Tool?utm_source=dbweekly&utm_medium=email) miniDBAtools [Introducing the Neo4j 3.0 Apache Spark Connector](http://neo4j.com/blog/neo4j-3-0-apache-spark-connector/?utm_source=dbweekly&utm_medium=email) Michael Hungertools [rpgffi: Create Postgres Extensions in Rust](https://github.com/posix4e/rpgffi?utm_source=dbweekly&utm_medium=email) — A Rust Postgres FFI for building Postgres extensions in the modern, safe systems programming language. Alex Newmancode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/108) [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