DB Weekly Issue 95: March 11, 2016

Microsoft Announces SQL Server for Linux — The software giant takes another step towards Linux by announcing the availability of its flagship database server, SQL Server, on Linux in 2017.

A Database Model for Simple Board Games — 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.

KairosDB: A Fast Time-Series Database on Cassandra — A fast distributed scalable time series database written on top of Apache Cassandra.

Government Open Source Mandates Drive Postgres Adoption Worldwide — 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.

SQL JOIN or EXISTS? Chances Are, You’re Doing it Wrong — "A lot of developers get the distinction between JOIN and SEMI-JOIN wrong. Let me explain.."

700 SQL Queries per Second in Apache Spark with FiloDB — 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.

PipelineDB 0.9 Released with Postgres 9.5 Compatibility — Pipeline is an open-source relational database that runs SQL queries continuously on streams.

ActorDB: The Ideal Datastore for Microservices — It’s a highly distributed SQL database with linear scalability.

With SQL Server 2016, Microsoft Focuses On Speed and Security — 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.

Stop Applying to Jobs - Let Companies Apply to You — 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.

Unlimited Scalability & Unprecedented Speed with In-Memory Computing — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture.

Apache Cassandra 3.4 Released

MongoDB Plans 'Giant' Event in June — It’ll even include They Might Be Giants, and Adam Savage of Mythbusters.

Microsoft Aims for Oracle with Aggressive SQL Server Migration Offer — MS is offering Oracle migrants free licenses, with a catch.

Finding Hashtags in Elasticsearch 1.7

Rolling Classifications by X Previous Aggregations in SQL

Anybody Here Used ArangoDB and Have Anything to Say About It? — The discussion attracted someone from ArangoDB who answered some questions.

The Future of Hadoop is Misty

Database Guru Gordon Linoff Explains The Design Process And Data Mining

Redis Performance Dashboard and Autoscaling from RedisGreen — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise.

MongoDB Partial Export: Dump Part of A Mongo Database using Your App's Data Model

goatfish: A Small, Schemaless Python ORM Backed by SQLite