DB Weekly Issue 126: October 14, 2016

SummitDB: In-Memory NoSQL ACID Compliant DB with Raft Consensus — An interesting new database written in Go that uses a Redis-like API, but is ACID compliant, supports custom indexes, JSON documents, and JavaScript scripting.

Git as a NoSQL Database — Git is a content-addressable file system. This means that it’s a simple key-value store.

MySQL 8.0: The End of MyISAM — A look at the gradual end of the storage engine every MySQL user has come to hate over the years: MyISAM.

Get the Universal Scalibility Law Modeling Workbook — This workbook is a rapid way to model and understand your systems' practical scalability limits. Download now.

How to Choose The Right Database System: RDBMS vs. NoSQL vs. NewSQL — A look at the things to be considering when trying to find the right database system for your use case. It’s ultimately a process based on making tradeoffs.

Does Your Database Really Use Your Index? — Indexes are important for ensuring high performance in relational databases, but after many years and changes in your apps, can you be sure the right indexes are still in place?

The Best of PostgreSQL 9.6 for the Database Administrator — Postgres 9.6 came with a number of interesting new features. This rundown highlights the ones most interesting if you’re a DBA.

One Application, 4,000+ Opportunities - Try Hired — On Hired companies apply to interview you. Get 1:1 support for your job search plus upfront compensation details.

Amazon ElastiCache for Redis Update — Sharded cluster support now lets you have up to 3.5TB of Redis storage.

IBM Challenges Amazon S3 with Cloud Object Store

Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for 20ドル credit.

What An In-Memory Database Is and How It Persists Data Efficiently

Database Schema Design Tutorials

Real-time Stream Processing Using Apache Spark Streaming and Apache Kafka on AWS

7 Useful SQL in Postgres Techniques

How Twitch Uses PostgreSQL — Twitch has over 100 servers running Postgres and in this short post, they share a few parts of how they make it all work.

KVolve: Updating NoSQL Database Schemas Without Downtime — We built a system, called KVolve, for updating data from Redis key-value stores on-the-fly, without disconnecting the applications that read and write the data.

A Practical Relational Query Compiler in 500 Lines of Code

My RethinkDB story — Michel Tu shares his personal story of working on and with RethinkDB.

Upload Files From Anywhere. — The #1 Developer Service for File Uploads.

DbFit: Automated Open Source Database Testing Tool

DBGlass: A Cross-platform PostgreSQL Client — Built with Electron, React, Redux, and FixedDataTable.

OmniDB: Web Tool for Database Management and Conversion — 1.6 has just been released with MariaDB support. Also supports Oracle, Postgres, SQLite, SQL Server and others.

go-rm: Helpers for Writing Redis Modules in Go — Redis recently added support for external modules.

SqlPad: A Web-based SQL Editor To Run in Your Own Private Cloud — Supports MySQL, Postgres, SQL Server, Vertica, Crate, and Presto.