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

Database Weekly 95   . 

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

[Database Weekly](http://dbweekly.com) Issue 95 — March 11, 2016     

Featured [Microsoft Announces SQL Server for Linux](https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/?utm_source=dbweekly&utm_medium=email) — The software giant takes another step towards Linux by announcing the availability of its flagship database server, SQL Server, on Linux in 2017. Microsoft [A Database Model for Simple Board Games](http://www.vertabelo.com/blog/technical-articles/a-database-model-for-simple-board-games?utm_source=dbweekly&utm_medium=email) — Vertabelo is back with another one of their great database design articles. This time, they look at how to very generically represent board game moves and players. Emil Drkušić [KairosDB: A Fast Time-Series Database on Cassandra](https://kairosdb.github.io/?utm_source=dbweekly&utm_medium=email) — A fast distributed scalable time series database written on top of Apache Cassandra. KairosDBcode [Government Open Source Mandates Drive Postgres Adoption Worldwide](http://www.enterprisedb.com/postgres-plus-edb-blog/keith-alsheimer/government-open-source-mandates-drive-postgres-adoption-world?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016govtopensource) — Commercial DBMSs with their high license and maintenance costs and vendor lock-in make it difficult for government IT managers to effectively meet new operating challenges. Open source DBMSs provide performance and security at enormously reduced costs – learn more. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/2afa4f56.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/keith-alsheimer/government-open-source-mandates-drive-postgres-adoption-world?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016govtopensource) [SQL JOIN or EXISTS? Chances Are, You’re Doing it Wrong](http://blog.jooq.org/2016/03/09/sql-join-or-exists-chances-are-youre-doing-it-wrong/?utm_source=dbweekly&utm_medium=email) — “A lot of developers get the distinction between JOIN and SEMI-JOIN wrong. Let me explain..” jooq [700 SQL Queries per Second in Apache Spark with FiloDB](http://velvia.github.io/Spark-Concurrent-Fast-Queries/?utm_source=dbweekly&utm_medium=email) — Apache Spark is increasingly thought of as the new ‘jack-of-all-trades’ distributed platform for big data crunching. This post looks at using it for low-latency, high concurrency reporting type applications. Evan Chan [PipelineDB 0.9 Released with Postgres 9.5 Compatibility](https://www.pipelinedb.com/blog/pipelinedb-0-9-continuous-transforms-streaming-topologies-and-postgresql-9-5-compatibility?utm_source=dbweekly&utm_medium=email) — Pipeline is an open-source relational database that runs SQL queries continuously on streams. PipelineDBtools [ActorDB: The Ideal Datastore for Microservices](http://blog.biokoda.com/post/140439136890/actordb-the-ideal-datastore-for-microservices?utm_source=dbweekly&utm_medium=email) — It’s a highly distributed SQL database with linear scalability. Biokodaopinion [With SQL Server 2016, Microsoft Focuses On Speed and Security](http://techcrunch.com/2016/03/10/with-sql-server-2016-microsoft-focuses-on-speed-security-and-luring-customers-away-from-oracle/?utm_source=dbweekly&utm_medium=email) — SQL Server 2016 promises to be significantly faster than 2014, both at a baseline level and potentially 100x faster when you use the new in-memory columnstores. TechCrunchnews 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 [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 [Apache Cassandra 3.4 Released](http://www.mail-archive.com/dev@cassandra.apache.org/msg08732.html?utm_source=dbweekly&utm_medium=email) Jake Lucianinews [MongoDB Plans 'Giant' Event in June](http://www.datanami.com/2016/03/08/mongodb-plans-giant-event-in-june/?utm_source=dbweekly&utm_medium=email) — It’ll even include They Might Be Giants, and Adam Savage of Mythbusters. Datanaminews [Microsoft Aims for Oracle with Aggressive SQL Server Migration Offer](http://www.zdnet.com/article/microsoft-aims-for-oracle-database-workloads-with-aggressive-sql-server-migration-offer/?utm_source=dbweekly&utm_medium=email) — MS is offering Oracle migrants free licenses, with a catch. ZDNetnews [Finding Hashtags in Elasticsearch 1.7](http://blog.pixlee.com/finding-hashtags-in-elasticsearch?utm_source=dbweekly&utm_medium=email) Pixleetutorial [Rolling Classifications by X Previous Aggregations in SQL](https://periscopedata.com/blog//rolling-classifications-by-x-previous-aggregations.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Anybody Here Used ArangoDB and Have Anything to Say About It?](https://www.reddit.com/r/Database/comments/49av49/anybody_here_used_arangodb_and_have_anything_to/?utm_source=dbweekly&utm_medium=email) — The discussion attracted someone from ArangoDB who answered some questions. Redditopinion [The Future of Hadoop is Misty](https://haifengl.wordpress.com/2016/03/03/the-future-of-hadoop-is-misty/?utm_source=dbweekly&utm_medium=email) Haifeng's Random Walkopinion [Database Guru Gordon Linoff Explains The Design Process And Data Mining](http://www.cloudways.com/blog/gordon-linoff-on-the-design-process-and-data-mining/?utm_source=dbweekly&utm_medium=email) Ahmed Khanopinion [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=link&utm_term=findout+autoscaling+performance) — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise. RedisGreentools sponsored [MongoDB Partial Export: Dump Part of A Mongo Database using Your App's Data Model](https://github.com/applidget/mongo-partial-dump?utm_source=dbweekly&utm_medium=email) Applidgettools [goatfish: A Small, Schemaless Python ORM Backed by SQLite](https://github.com/stochastic-technologies/goatfish?utm_source=dbweekly&utm_medium=email) Stochastic Technologiescode    

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