DB Weekly Issue 171: September 8, 2017

The Total Newbie’s Guide to Cassandra — If you’ve not had to use Cassandra yet, this is a good entry-level primer to what it’s for and how it’s used.

'Database Learning' Aims to Speed Queries — A University of Michigan team has built a tool to enable existing databases to ‘learn’ from user queries in order to optimize.

Jepsen Offers System-Wide Approach to Testing Databases at Scale — "Jepsen is a project to analyze distributed systems under stress and to understand if concurrency problems are going to manifest..."

Linux cloud hosting starting at 1GB of RAM for 5ドル/mo — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you’re ready to deploy your server. Use promo code DB20 for a 20ドル credit on a new account.

Let's Build a Simple Database in C — If you really want to get under the hood, here’s some pointers on creating a SQLite clone from scratch in C.

Publishing with Apache Kafka at The New York Times — How Apache Kafka and its Streams API are used for storing and processing all the articles published by the NYT.

Relational Databases Remain Popular As Data Sources Grow — In a world rich with third party APIs and services, analytics tools, and new database technologies, RDBMS remain in the lead.

Building An Interactive Game of Thrones Map — A fun guide to building a Node.js API to serve a geospatial ‘Game of Thrones’ map, leaning heavily on Postgres (with PostGIS) and Redis.

MongoDB Europe 2017 Conference (London, Nov 8)

Database Migrations to AWS Gaining Momentum — Over 35,000 unique databases have now been migrated to AWS using AWS DMS.

Percona Live Europe 2017 - Dublin (25-27 September) — Join the Open Source database community for various talks on MySQL, MongoDB, MariaDB, PostgreSQL, RocksDB & more.

A Song of Ice and Databases: A Game of Thrones Data Model — No plot spoilers – just a data model based on the Game of Thrones TV series.

How to Integrate Spring Data JPA, PostgreSQL, and Liquibase — ..to manage the persistence layer of a Spring Boot application.

Tarantool vs. Redis: In-Memory Databases Face Off — Are you curious to know how Tarantool (an open source NoSQL database) stacks up against Redis? This post covers some advantages.

Practical Scalability Analysis with the Universal Scalability Law — The Universal Scalability Law models how systems perform as they grow. This ebook shows how to best use it.

Ultimate List of 32 Oracle SQL IDEs Compared — A guide to help you compare Oracle IDEs and decide which one to use.