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

Database Weekly 92   . 

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

[Database Weekly](http://dbweekly.com) Issue 92 — February 19, 2016     

Featured [Five Online Database Modelling Services](https://www.simple-talk.com/sql/database-administration/-five-online-database-modelling-services/?utm_source=dbweekly&utm_medium=email) — Browser technology has progressed so rapidly that online database modelling tools have become viable. Are they good enough to use now? Robert Sheldon finds out. Robert Sheldontools [Using Cassandra for Analytics: A Performance and Storage Analysis](https://www.oreilly.com/ideas/apache-cassandra-for-analytics-a-performance-and-storage-analysis?utm_source=dbweekly&utm_medium=email) — Comparing the effects of storage format, modeling/filtering, caching, and other effects on analytical query speed and storage cost in Apache Cassandra. Evan Chan [Spark Rises to Become Most Active Open Source Project in Big Data](http://www.techrepublic.com/article/apache-spark-rises-to-become-most-active-open-source-project-in-big-data/?utm_source=dbweekly&utm_medium=email) — Adoption interest in Spark has topped MapReduce, says a new survey. What’s supporting interest is the need for speed, boosting agility, and revenues. Tech Republicnews [Database Compatibility for Oracle Explained](http://www.enterprisedb.com/postgres-plus-edb-blog/gary-carter/database-compatibility-oracle-explained?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016OracleCompatBlog) — Learn how organizations can reduce their database spend by 80% or more by deploying EDB Postgres in place of traditional database solutions like Oracle, according to calculations in a recent Gartner report. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/07b2feca.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/gary-carter/database-compatibility-oracle-explained?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016OracleCompatBlog) [18+ Best Online Resources for Learning SQL and Database Concepts](http://www.vertabelo.com/blog/notes-from-the-lab/18-best-online-resources-for-learning-sql-and-database?utm_source=dbweekly&utm_medium=email) Patrycja Dybka [How to Perform Random Queries on MongoDB](https://www.mongodb.com/blog/post/how-to-perform-random-queries-on-mongodb?utm_source=dbweekly&utm_medium=email) — A common problem across all types of database, MongoDB 3.2 now has a $sample operator that implements a native random sample operation over a collection data set. Norberto Leite [10 Tips for Integrating NoSQL Databases in Your Business](http://www.cio.com/article/3033218/open-source-tools/10-tips-for-integrating-nosql-databases-in-your-business.html?utm_source=dbweekly&utm_medium=email) — NoSQL databases provide the agility, scalability, performance and availability to support many applications today, but implementing them is not always easy. Here are 10 tips for integrating NoSQL systems in your organization. CIO [mysqldump-secure: A MySQL Backup Tool with Security in Mind](http://mysqldump-secure.org/?utm_source=dbweekly&utm_medium=email) — Encryption is done before the backup file is written to disk to avoid possible race conditions. cytopiatools [Design Your Database for Flexibility](http://dangoldin.com/2016/02/15/design-your-database-for-flexibility?utm_source=dbweekly&utm_medium=email) — “One of the biggest lessons I’ve learned is to spend extra effort thinking about the database when setting out to build something new.” Dan Goldinopinion [Using GraphQL with NoSQL database ArangoDB](https://www.arangodb.com/2016/02/using-graphql-nosql-database-arangodb/?utm_source=dbweekly&utm_medium=email) — GraphQL is a Facebook-created query language for requesting datasets over the Web (it essentially provides an alternative to REST APIs). As a multi-model database, it’s possible to get it working with ArangoDB. ArangoDB Jobs [Cassandra Infrastructure Engineer](https://www.heroku.com/careers/67?utm_source=dbweekly&utm_medium=email) — Ever had to deal with massive SSTable bloat? Come join us and help run Cassandra at scale. Heroku [Stop Applying to Jobs - Let Companies Apply to You](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_term=cat-tech-database&utm_content=stopapplyingtojobs&utm_campaign=q1-16&utm_location=us) — On Hired, sign up in 10 minutes and get offers from top companies like Facebook, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Try it today. Hired.​com In brief [SQLite Release 3.11.0 Released](https://www.sqlite.org/releaselog/3_11_0.html?utm_source=dbweekly&utm_medium=email) — Numerous optimizations and improved durability. SQLitenews [Databricks Community Edition: Apache Spark for All](https://databricks.com/blog/2016/02/17/introducing-databricks-community-edition-apache-spark-for-all.html?utm_source=dbweekly&utm_medium=email) — A free version of Databricks’ cloud-based Spark platform. Aimed at anyone who wants to learn Spark. Databricksnews [Amazon RDS Now Supports Sharing Encrypted Database Snapshots with Other AWS Accounts](https://aws.amazon.com/about-aws/whats-new/2016/02/rds-now-supports-sharing-encrypted-database-snapshots-with-other-aws-accounts/?utm_source=dbweekly&utm_medium=email) Amazonnews [What Design Thinking Means for Data and Analytics](http://www.datanami.com/2016/02/16/what-design-thinking-means-for-data-analytics/?utm_source=dbweekly&utm_medium=email) Datanaminews [Apache Announces 'Arrow' as a Top-Level Project](https://blogs.apache.org/foundation/entry/the_apache_software_foundation_announces87?utm_source=dbweekly&utm_medium=email) — Apache Arrow establishes a de-facto standard for columnar in-memory processing and interchange. Apache Software Foundationnews [Free O'Reilly Ebook: Building Real-Time Data Pipelines](http://www1.memsql.com/oreilly.html?utm_source=email&utm_medium=dbnews&utm_content=ebook&utm_campaign=oreilly) — Learn how to use Apache Spark and Kafka to build real-time data pipelines and database architectures for supporting real-time data workloads. MemSQLsponsored [Bigram Frequencies in Pure SQL](https://periscopedata.com/blog//bigram-frequencies-in-pure-sql.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [How to Migrate a Google App Engine Datastore to SQL using Go](http://www.sromku.com/blog/datastore-sql-migration?utm_source=dbweekly&utm_medium=email) Roman Kushnarenkotutorial [Hacking Microsoft SQL Server Without a Password](https://blog.anitian.com/hacking-microsoft-sql-server-without-a-password/?utm_source=dbweekly&utm_medium=email) — “What I found was that with a little packet hacking, I could take control of a Microsoft SQL Server box without having any stolen credentials using a Man in the Middle style attack.” Anitiantutorial [Securing MongoDB Part 3: Database Auditing and Encryption](https://www.mongodb.com/blog/post/securing-mongodb-part-3-database-auditing-and-encryption?utm_source=dbweekly&utm_medium=email) Mat Keeptutorial [Neo4j + Cassandra: Transferring Data from a Column Store to a Property Graph](http://neo4j.com/blog/neo4j-cassandra-transfer-data/?utm_source=dbweekly&utm_medium=email) William Lyontutorial [SQL Server Unit Testing with tSQLt Framework](http://codingsight.com/sql-server-unit-testing-with-tsqlt-framework/?utm_source=dbweekly&utm_medium=email) {coding}Sighttutorial [jOGlenn Paulley Gives Insight into SQL’s History](http://blog.jooq.org/2016/02/16/jooq-tuesdays-glenn-paulley-gives-insight-into-sqls-history/?utm_source=dbweekly&utm_medium=email) jOOQ Tuesdaysopinion [DB Browser for SQLite](http://sqlitebrowser.org/?utm_source=dbweekly&utm_medium=email) sqlitebrowser.​orgtools [awesome-elasticsearch: A Curated List of Elasticsearch Resources](https://github.com/dzharii/awesome-elasticsearch?utm_source=dbweekly&utm_medium=email) Dmytro Zhariitools [Accelerate Mobile App Dev](http://www.launchbit.com/taz/11185-6321-111) — Telerik webinar featuring Forrester, Wednesday, March 9. Join free webinar. Teleriksponsored    

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