#229 — November 9, 2018

Read on the Web

Database Weekly

MemSQL Now Free to Use (Up to 128GB RAM) — MemSQL is a high performance, distributed, in-memory, SQL database system that has, till now, been commercial only. With this week’s release, MemSQL is now free for everyone to use for databases using up to 128GB of RAM and includes all enterprise capabilities.

Mike Boyarski (MemSQL)

An Introduction to Join Ordering — Joins are one of the most powerful features relational databases offer––but optimal executions are NP-hard to find. How do you support them in an OLTP database?

Justin Jaffray

Writing Logs Directly to InfluxDB — Learn how to write logs into InfluxDB, the fastest growing time series database.

InfluxData sponsor

How Causal Guarantees Are Anything But Casual — Traditional single node databases provide sequential ordering guarantees for read and write operations known as ‘causal consistency’ but for distributed systems to do so, a lot more coordination must take place. This digs into how it all works with MongoDB.

Aly Cabral

Will GraphQL Become a Standard for the New Data Economy? — GraphQL isn’t a database itself but a new data querying format for APIs to use instead of alternatives like REST or SQL over the wire.


Basecamp Experiences Downtime Over Integer Table Column — The popular work organization SaaS tool has experienced its most significant downtime in a decade due to running out of IDs on an integer column. Be sure to audit your own systems to prevent similar issues.

David Heinemeier Hansson

Row-Level Security Is Now Supported for Microsoft Azure SQL Data Warehouse — An additional capability for managing security for sensitive data.

Kavitha Jonnakuti

Migrating Oracle Autonomous Transactions to PostgreSQL — While migrating from Oracle to PostgreSQL, you might come across Oracle Autonomous Transactions. This explains what they are how to replicate the functionality in PG.

Yaser Raja

Using SQL Within Google Sheets — Did you know Google’s Web-based spreadsheet tool includes a ‘query’ function for using SQL against your spreadsheet? This is a guide to using it.

Ben Collins

Eventual vs Strong Consistency in Distributed Databases — A basic explanation of the topic using a real world analogy.


ATM Fraud Detection with Apache Kafka and KSQL — Anyone who can write SQL can now write stream processing applications for fraud detection with Apache Kafka and KSQL. Here we see how it can be done.

Robin Moffatt (Confluent)

Data Masking in MySQL — The MySQL team show off one way how MySQL is addressing modern security and privacy issues.

Ivan Švaljek

New Whitepaper: Choosing a Database Proxy for MySQL & MariaDB — Load balancing is essential to achieving high availability and this new whitepaper shows you how to choose the right one.

Severalnines sponsor

Why NOT to Build a Time-Series Database — One company’s story building and scaling a time-series database.

David Gildeh

Intel Optane SSD Microbenchmarks using LMDB and RocksDB — Both the LBMD and RocksDB persistent key-value stores are used to put Intel’s latest Optane SSDs (which can even be configured to work as system RAM) through their paces.

Symas Corp.

fx: A Command-Line JSON Processing Tool

Anton Medvedev

💻 Jobs

Get Hired Based on Your Skills Not Your CV — Our AI makes it easier and quicker to match with top Data Engineering jobs, with no recruiters and an average salary of £60k.