Issue 138 — January 20, 2017
Featured
How Discord Stores Billions of Messages with Cassandra — 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 Vishnevskiy story
DBeaver: A Free Universal SQL Client — Cross platform and support all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
jkiss.org tools
Data Coding 101: How to install Python, SQL, R and Bash — 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 Mester tutorial
SQL Source Control: track each change to your SQL Server database — Get a full history in your source control system. See who made changes, what they did & why. See how
Red Gate sponsored
Oracle Releases A Monster Security Update for Over 100 Exploitable Flaws — Oracle is urging its customers to apply patches that include 270 fixes to prevent at least 100 remotely exploitable flaws.
ZDNet news
The Compendium of Database Ransomware — A post being kept updated with database names found to be associated with ransomware attacks.
BinaryEdge news
Managing Employees and Resources: A Process Management Data Model — 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.
Vertabelo tutorial
Intel Unveils Deep Learning Framework for Spark — BigDL is a new, open source deep learning framework that runs as a Spark job atop Hadoop.
Datanami tools
PostgreSQL Exercises — 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 Owens tools
In brief
NRAM Set to Spark A 'Holy War' Among Memory Technologies — A new type of RAM based on carbon nanotubes.
Lucas Mearian news
Jan Engelsberg news
Estimating CPU Per Query With Weighted Linear Regression — This ebook explains how a specialization of linear regression answers seemingly unsolvable database questions.
VividCortex sponsored
Nuria Ruiz tutorial
Analytics Vidhya tutorial
Zameer Ansari tutorial
jOOQ tutorial
Scrape Any Website/Service/API with SQL — Using Node.js, PhantomJS, and AlaSQL.
Mike Parsons tutorial
Greg Larsen tutorial
SQL Server Blog tutorial
Jesse Anderson video
Fabian Pascal opinion
Lockwood Lyon opinion
Peter Zaitsev opinion
Postgres-BDR: Multi Master Replication Solution for PostgreSQL — BDR is a multi-master replication system for geographically distributed clusters using logical replication.
2ndQuadrant PostgreSQL Products sponsored
John K. E. Wilson code
Alenka: A GPU-Based Database Engine — Written (mostly in CUDA) to use vector based processing and high bandwidth of modern GPUs.
Anton MKS code
Seiji Takahashi code