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

Database Weekly 98   . 

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

[Database Weekly](http://dbweekly.com) Issue 98 — April 1, 2016     

Featured [Elastic Gives ElasticSearch a Graph Query Engine](http://www.datanami.com/2016/03/30/elastic-gives-search-engine-graph-option/?utm_source=dbweekly&utm_medium=email) — Elastic has announced that it’s added a graph query engine to Elasticsearch, so users now have the option of using their search indexes as the basis for conducting graph analyses. Datanaminews [Caravel: Airbnb’s Data Exploration Platform](https://medium.com/airbnb-engineering/caravel-airbnb-s-data-exploration-platform-15a72aa610e5?utm_source=dbweekly&utm_medium=email) — A data exploration platform designed to be visual, intuitive and interactive. The video and screenshots are very appealing. Caravel allows visualization-based exploration of data while performing fast “slicing and dicing” against any dataset. Maxime Beauchemintools [How Neo4j Saved my Relationship](https://www.youtube.com/watch?v=NfyieD5det8&utm_source=dbweekly&utm_medium=email) — A look at the power of graph databases in taming complex data problems. Coraline Ada Ehmkevideo [Get more from Redis: Autoscaling and Performance Dashboard from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=primary&utm_term=findout+autoscaling+performance) — Ever wonder what your Redis server was actually doing? Find out with RedisGreen's dashboard and monitoring tools. RedisGreensponsored [![\](https://copm.s3.amazonaws.com/4065fb65.png)](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=primary&utm_term=findout+autoscaling+performance) [Citus Unforks From PostgreSQL, Goes Open Source](https://www.citusdata.com/blog/17-ozgun-erdogan/403-citus-unforks-postgresql-goes-open-source?utm_source=dbweekly&utm_medium=email) — Citus Data has released Citus 5.0 which comes along with two major announcements. The first is it’s entirely an extension, making it the first distributed databased to not fork Postgres but use native extension APIs. The second, it’s now [open source](http://github.com/citusdata/citus). Citus Data [SQL: How to Create An Execution Plan](https://blogs.oracle.com/sql/entry/how_to_create_an_execution?utm_source=dbweekly&utm_medium=email) — When you’re trying to get SQL to run faster, there’s one thing that’s vital: an execution plan. In this post Chris Saxon investigates how to create yours. Oracletutorial [What is Blockchain?](https://medium.com/badge-chain/what-is-blockchain-5e4498f05c20?utm_source=dbweekly&utm_medium=email) — A primer for people just starting to wrap their heads around blockchain, a type of distributed database that maintains an expanding ledger of data and records. W.​ Ian O'Byrnetutorial [Analyzing A Billion Taxi Rides in PostgreSQL](http://tech.marksblogg.com/billion-nyc-taxi-rides-postgresql.html?utm_source=dbweekly&utm_medium=email) — We covered when Mark analyzed a billion rides in [Redshift](http://tech.marksblogg.com/billion-nyc-taxi-rides-redshift.html), now here’s the same but using Postgres and [cstore](https://github.com/citusdata/cstore_fdw/), the columnar storage FDW from [Citus Data](http://www.citusdata.com) Mark Litwintschik Jobs [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 [SQL Server Developer Edition Is Now Included for Free with Visual Studio Dev Essentials](https://www.visualstudio.com/products/visual-studio-dev-essentials-vs?utm_source=dbweekly&utm_medium=email) Microsoftnews [Gartner Magic Quadrant for Data Warehouse Solutions](http://www1.memsql.com/gartner-mq-data-warehouse.html?utm_source=email&utm_medium=dbnews&utm_content=report&utm_campaign=gdw) — This report will help data, analytics and IT leaders find the right vendor for their needs. MemSQLnews sponsored [CockroachDB Skitters into Beta](https://www.cockroachlabs.com/blog/cockroachdb-skitters-beta/?utm_source=dbweekly&utm_medium=email) — First unveiled last June, CockroachDB has now entered beta. Spencer Kimballnews [Machine Learning Templates with SQL Server 2016 R Services](https://blogs.technet.microsoft.com/machinelearning/2016/03/23/machine-learning-templates-with-sql-server-2016-r-services/?utm_source=dbweekly&utm_medium=email) — In-database analytics in SQL Server 2016 allows users to combine the power of SQL Server and Microsoft R Server (or Open Source R), without data leaving the database. Microsoftnews [SQLite 3.12.0 Released](http://www.sqlite.org/releaselog/3_12_0.html?utm_source=dbweekly&utm_medium=email) SQLitenews [Learn to Live with Apache Hive in 12 Easy Steps](http://www.infoworld.com/article/3047582/open-source-tools/learn-to-live-with-apache-hive-in-12-easy-steps.html?utm_source=dbweekly&utm_medium=email) — Hive lets you use SQL on Hadoop, but tuning SQL on a distributed system is different. Here's 12 tips to help. Andrew C.​ Olivertutorial [Five Ways to Paginate in Postgres, From The Basic to The Exotic](https://www.citusdata.com/blog/1872-joe-nelson/409-five-ways-paginate-postgres-basic-exotic?utm_source=dbweekly&utm_medium=email) — This article examines several methods of server-side pagination and discusses their tradeoffs when implemented in PostgreSQL. Joe Nelsontutorial [How to Validate User Input in A NoSQL Web Application](http://rethinkdb.com/blog/validation-techniques/?utm_source=dbweekly&utm_medium=email) — Practical approaches on how to validate user input for a schema-less database. Ryan Paultutorial [PipelineDB Persistence with Flocker and Docker Swarm](https://clusterhq.com/2016/03/24/pipelinedb-persistance/?utm_source=dbweekly&utm_medium=email) — Covers running a basic PipelineDB server container on a host machine using Docker. Stephen Nguyentutorial [A Simple Guide To Building Reports Using SQL Server Reporting Services](http://jackworthen.com/2016/04/01/a-simple-guide-to-building-reports-using-sql-server-reporting-services/?utm_source=dbweekly&utm_medium=email) — A detailed outline of the steps from creating the stored procedure that will run the report to building a front-end report using the Business Intelligence module in Visual Studio. Jack Worthentutorial [Why You Should (Sometimes) Use MongoDB](http://nicholasjohnson.com/blog/why-you-should-sometimes-use-mongo/?utm_source=dbweekly&utm_medium=email) Nicholas Johnsonopinion [To SQL or NoSQL? That’s The Database Question](http://arstechnica.com/information-technology/2016/03/to-sql-or-nosql-thats-the-database-question/?utm_source=dbweekly&utm_medium=email) — Lisa Vaas opines that as the technological lines blur, there’s not always a clear-cut answer between the two. Ars Technicaopinion [Picking The Right Caching Tier for Your Database](https://dzone.com/articles/in-progress-picking-the-right-caching-tier-for-you?utm_source=dbweekly&utm_medium=email) — Caching tiers are used to lower latencies under high database throughput, so it pays to pick the right approach. Cihan Bopinion [How NoSQL Graph Databases Still Usurp Relational Dynasties](http://www.theregister.co.uk/2016/03/29/in_defense_of_graph_databases/?utm_source=dbweekly&utm_medium=email) Andrew Cobleyopinion [Unlimited Scalability & Unprecedented Speed with In-Memory Computing](http://www.gridgain.com/products/in-memory-data-fabric/?utm_source=dbweekly&utm_medium=email) — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture. GridGain In-Memory Data Fabrictools sponsored [Mrs. Null: These Unlucky People Have Names That Break Computers](http://www.bbc.com/future/story/20160325-the-names-that-break-computer-systems?utm_source=dbweekly&utm_medium=email) — To any programmer, it’s painfully easy to see why “Null” could cause problems for software interacting with a database. Chris Baraniukstory    

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