#310 — June 26, 2020

Read on the Web

Database Weekly

Amazon Honeycode: A New AWS Tool to Build Database Apps without Code — Despite some reservations over the name, this feels a bit like Access meets Excel meets the cloud and will allow a wider range of users to build data-driven online apps without learning to code.

Jeff Barr

Query 1.6 Billion Rows on QuestDB in Milliseconds, Live — An online demo of QuestDB, a high performance time-series database that promises millisecond latency on keyed aggregations that span over billions of rows. The creator explained more here.

QuestDB

SIGMOD 2020 Publishes Research Paper on CockroachDB — This research paper, published by SIGMOD, presents the design of CockroachDB and its novel transaction model that supports consistent geo-distributed transactions with a scalable SQL interface.

Cockroach Labs sponsor

Splitgraph: A Code-Like Data Versioning and Management System — Inspired by Docker and Git and built, initially, for PostgreSQL, Splitgraph’s core idea is it lets you build Docker image-esque ‘data images’.

Miles Richardson and Artjoms Iškovs

⚡️ Quick bytes:

💻 Jobs

Database Engineer (Remote) — Got experience designing cloud database infrastructure? Join an independent software company and work with our Senior Database Engineer, helping us design new production systems in Google Cloud.

HARVEST

DevOps Engineer at X-Team (Remote) — Join X-Team and work on projects for companies like Riot Games, FOX, Coinbase, and more. Work from anywhere.

X-Team

📄 Articles

Jepsen Analysis of Redis-Raft, Raft Consensus for Redis — It’s been a busy time for Jepsen having analyzed Postgres and MongoDB recently (and finding bugs in both!) – this time they take on RedisRaft, a mechanism for bringing Raft consensus to a Redis cluster.

Kyle Kingsbury

A Surprising Way to Do Data Science with Node.js — This is really aimed at data scientists who don’t use Node right now in order to see how Node can be used to do some data analysis and use D3.js to produce an SVG chart.

Cristiano L. Fontana

We Help Customers Speed Up Postgres Queries By 1000x. Learn How — With pganalyze, companies like Atlassian are able to speed up their queries by orders of magnitude. See our best practices for optimizing PG performance in this free eBook.

pganalyze sponsor

▶  ClickHouse: The Fastest Data Warehouse You've Never Heard Of — We’ve heard of it, but this hour long talk does a good job of giving us a feel for what it can do and how it works.

Robert Hodges (Altinity Engineering)

Spark 3.0 Brings Big SQL Speed-Up, Better Python Hooks — Further reflections on last week’s release.

Datanami

🔨 Tools and Code

DB Browser for SQLite (DB4S) — A high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. v3.12.0 came out last week with improved table editing and conditional formatting when browsing data (a bit like a spreadsheet might).

Martin Kleusberg et al.

Irmin: A Distributed Database Built On The Same Principles as Git — An OCaml library for building mergeable, branchable distributed data stores.

MirageOS

Announcing the 1.0 Release of the Official MongoDB Swift Driver

MongoDB