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

Database Weekly 138   . 

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

[Database Weekly](http://dbweekly.com) Issue 138 — January 20, 2017     

Featured [How Discord Stores Billions of Messages with Cassandra](https://blog.discordapp.com/how-discord-stores-billions-of-messages-7fa6ec7ee4c7?utm_source=dbweekly&utm_medium=email#.j169uuvl7) — Discord is a popular chat system for gamers. They started out with MongoDB but here they explain why and how they moved to Cassandra, and how they dealt with garbage collection issues. Stanislav Vishnevskiystory [DBeaver: A Free Universal SQL Client](http://dbeaver.jkiss.org/?utm_source=dbweekly&utm_medium=email) — Cross platform and support all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. jkiss.​orgtools [Data Coding 101: How to install Python, SQL, R and Bash](http://data36.com/data-coding-101-install-python-sql-r-bash/?utm_source=dbweekly&utm_medium=email) — A step by step guide - for non-devs and wannabe data scientists - to install R, Python, SQL and Bash in 30 minutes to begin data coding and analysis. Tomi Mestertutorial [SQL Source Control: track each change to your SQL Server database](http://go.cooperpress.com/r/db138/www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25323) — Get a full history in your source control system. See who made changes, what they did & why. [See how](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25323) Red Gatesponsored [![\](https://copm.s3.amazonaws.com/862e7d87.png)](http://go.cooperpress.com/r/db138/www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25323) [Oracle Releases A Monster Security Update for Over 100 Exploitable Flaws](http://www.zdnet.com/article/oracles-monster-security-update-270-fixes-and-over-100-remotely-exploitable-flaws/?utm_source=dbweekly&utm_medium=email) — Oracle is urging its customers to apply patches that include 270 fixes to prevent at least 100 remotely exploitable flaws. ZDNetnews [The Compendium of Database Ransomware](https://blog.binaryedge.io/2017/01/18/the-compendium-of-database-ransomware/?utm_source=dbweekly&utm_medium=email) — A post being kept updated with database names found to be associated with ransomware attacks. BinaryEdgenews [Managing Employees and Resources: A Process Management Data Model](http://www.vertabelo.com/blog/technical-articles/managing-employees-and-resources-a-process-management-data-model?utm_source=dbweekly&utm_medium=email) — What kind of data model can handle all the planning and activities used in process management? The latest in Vertabelo’s series of posts on database modelling. Vertabelotutorial [Intel Unveils Deep Learning Framework for Spark](https://www.datanami.com/2017/01/18/intel-unveils-deep-learning-framework-spark/?utm_source=dbweekly&utm_medium=email) — [BigDL](https://github.com/intel-analytics/BigDL) is a new, open source deep learning framework that runs as a Spark job atop Hadoop. Datanamitools [PostgreSQL Exercises](https://pgexercises.com/?utm_source=dbweekly&utm_medium=email) — If you’re looking for a way to practice your SQL skills, PG Exercises offers some good example data and exercises to hone your skills. Alisdair Owenstools In brief [Elasticsearch Ransomware Attacks Now Number in the 1000s](http://www.zdnet.com/article/elasticsearch-ransomware-attacks-now-number-in-the-thousands/?utm_source=dbweekly&utm_medium=email) ZDNetnews [NRAM Set to Spark A 'Holy War' Among Memory Technologies](http://www.computerworld.com/article/3156944/data-storage/nram-set-to-spark-a-holy-war-among-memory-technologies.html?utm_source=dbweekly&utm_medium=email) — A new type of RAM based on carbon nanotubes. Lucas Meariannews [Azure SQL Database Doubles Read and Write Performance](https://azure.microsoft.com/en-us/blog/azure-sql-database-is-increasing-the-read-and-write-performance/?utm_source=dbweekly&utm_medium=email) Jan Engelsbergnews [Estimating CPU Per Query With Weighted Linear Regression](https://www.vividcortex.com/resources/estimating-cpu-per-query-with-weighted-linear-regression?utm_campaign=DB%20Weekly&utm_source=ppc) — This ebook explains how a specialization of linear regression answers seemingly unsolvable database questions. VividCortexsponsored [Importing JSON into Hadoop via Kafka](https://blog.wikimedia.org/2017/01/13/json-hadoop-kafka/?utm_source=dbweekly&utm_medium=email) Nuria Ruiztutorial [46 Questions On SQL to Test A Data Science Professional](https://www.analyticsvidhya.com/blog/2017/01/46-questions-on-sql-to-test-a-data-science-professional-skilltest-solution/?utm_source=dbweekly&utm_medium=email) Analytics Vidhyatutorial [How SQL Server's Query Optimizer Works](http://xameeramir.github.io/How-SQL-Server-Query-Optimizer-Works/?utm_source=dbweekly&utm_medium=email) Zameer Ansaritutorial [How to Emulate Partial Indexes in Oracle](https://blog.jooq.org/2017/01/18/how-to-emulate-partial-indexes-in-oracle/?utm_source=dbweekly&utm_medium=email) jOOQtutorial [Scrape Any Website/Service/API with SQL](https://hackernoon.com/scrape-any-website-service-api-with-a-single-sql-select-statement-8d60be1e9a49?utm_source=dbweekly&utm_medium=email) — Using Node.js, PhantomJS, and [AlaSQL](http://alasql.org/). Mike Parsonstutorial [Simple Row Level Security for SQL Server 2016](http://www.databasejournal.com/tips/simple-row-level-security-for-sql-server-2016.html?utm_source=dbweekly&utm_medium=email) Greg Larsentutorial [How 6 Lines of Code + SQL Server Can Bring Deep Learning to Any App](https://blogs.technet.microsoft.com/dataplatforminsider/2017/01/05/how-six-lines-of-code-sql-server-can-bring-deep-learning-to-any-app/?utm_source=dbweekly&utm_medium=email) SQL Server Blogtutorial [Live Coding a Hadoop MapReduce Dedupe Algorithm in 30 Minutes](http://www.jesse-anderson.com/2017/01/hadoop-mapreduce-dedupe-algorithm/?utm_source=dbweekly&utm_medium=email) Jesse Andersonvideo [Don't Design Databases Without Foundational Knowledge and Conceptual Models](http://www.dbdebunk.com/2017/01/dont-design-databases-without.html?utm_source=dbweekly&utm_medium=email) Fabian Pascalopinion [Updating Production Environments to Feed a Big Data Application](http://www.databasejournal.com/features/db2/updating-production-environments-to-feed-a-big-data-application.html?utm_source=dbweekly&utm_medium=email) Lockwood Lyonopinion [The Impact of Swapping on MySQL Performance](https://www.percona.com/blog/2017/01/13/impact-of-swapping-on-mysql-performance/?utm_source=dbweekly&utm_medium=email) Peter Zaitsevopinion [Postgres-BDR: Multi Master Replication Solution for PostgreSQL](https://2ndquadrant.com/en/resources/bdr/) — BDR is a multi-master replication system for geographically distributed clusters using logical replication. 2ndQuadrant PostgreSQL Productssponsored [JsonDB: Schemaless Database Abstraction Library for MySQL and PHP](https://github.com/johnwilson/jsondb?utm_source=dbweekly&utm_medium=email) John K.​ E.​ Wilsoncode [Alenka: A GPU-Based Database Engine](https://github.com/antonmks/Alenka?utm_source=dbweekly&utm_medium=email) — Written (mostly in CUDA) to use vector based processing and high bandwidth of modern GPUs. Anton MKScode [gopli: MySQL Backup Between Remote or Local Hosts, Written in Go](https://github.com/timakin/gopli?utm_source=dbweekly&utm_medium=email) Seiji Takahashicode    

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