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.
Max M McKittrick
'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.
Linode Cloud Hosting
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.
Amazon Web Services
Percona Live Europe 2017 - Dublin (25-27 September)
— Join the Open Source database community for various talks on MySQL, MongoDB, MariaDB, PostgreSQL, RocksDB & more.
Percona Live Europe
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.