#277 — October 25, 2019

Read on the Web

Database Weekly

Taking DuckDB for a Spin — Featured back in issue 261, DuckDB is billed (geddit?) as being like ‘SQLite for analytics’, but does it deliver?

Uwe Korn

How DataDome Stores 200,000 Documents Per Second in Elasticsearch — Datadome, a cybersecurity company, logs 50 million events per second for its customers to analyze and search over for a 30 day period.. which results in them running a pretty significant Elasticsearch cluster.

DataDome

Cyberespionage Group Creates a Backdoor Targeting Microsoft SQL Server — skip-2.0 is a backdoor in SQL Server 11 and 12 that allows hackers to go undetected by means of a “magic password”.

ESET Research

The Art of PostgreSQL: A Book to Learn How to Best Use SQL from Your App — The book that teaches SQL to developers: learn to replace thousands of lines code with simple SQL queries. Worth reading even if you're not using Postgres yet.

The Art of PostgreSQL sponsor

PostGIS 3.0.0: Geospatial Objects for PostgreSQL — A long time in the coming, PostGIS 3.0 takes the popular spatial Postgres extension into the Postgres 12 world, moves raster support into a separate extension, and significantly improves performance via parallelization (a bit more about this here).

PostGIS Developers

How Shopify Manages Petabyte-Scale MySQL Backup and Restore — The popular ecommerce platform runs a large fleet of MySQL servers, with numerous replica-sets spread across three Google Cloud Platform (GCP) regions.

Shopify Engineering

🎧 Podcasts of the Week

There have been a few interesting database related podcast episodes this week that are worth checking out if you have time:

▶  The Power of Time Series Databases with Paul Dix — The CTO at InfluxDB, makers of the eponymous open source time-series database, chats with Corey Quinn about “everything there is to discuss about time-series databases”.

Screaming in the Cloud

▶  Redis with Alvin Richards — Alvin is Chief Product Officer at Redis Labs, a company actively supporting and growing the Redis in-memory data structure server project.

Software Engineering Daily

▶  The LinkedIn Data Platform with Carl Steinbach — As a social network with petabytes of data, LinkedIn has had to build a pretty serious platform to manage that data. This is a look behind the scenes at how it works.

Software Engineering Daily

💻 Jobs

DevOps / System Engineer - Kubernetes, Cloud Foundry, BOSH — You are interested in building and operating highly automated PaaS solutions? Join us.

anynines

Have You Tried Vettery? — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.

Vettery

📒 Everything else

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency — The various techniques that apps needing low latency and high availability can leverage while using a geo-distributed SQL database like YugabyteDB.

Sid Choudhury (YugaByte)

A Beginner’s Guide to Formatting Dates in SQL — Date and time types can often throw up challenges in SQL, so it’s good to have tutorials that reflect on the various ways to work with them.

Lori Brok

How YugabyteDB Scales to More than 1 Million Inserts Per Sec

Karthik Ranganathan (YugaByte)

Managing Your Database Licensing Relationship with Oracle® — Download this infographic and take a look at the issues of managing a database licensing relationship with Oracle.

EnterpriseDB sponsor

RxDB: A Realtime Database for JavaScript Applications — You can query the current state but also subscribe to state changes, making it useful for UI-based apps where you want live/real-time updates. It’s not new but it’s had a solid stream of releases recently.

pubkey

Aquameta: An Experimental Web Development Platform Built Entirely in Postgres — I’m a big fan of using the right tools for the right job, but this is an interesting project nonetheless. Apps in Aquameta are “represented entirely as relational data”.

Aquameta

EuclidesDB: A Multi-Model Machine Learning Feature Database — Tight coupled with PyTorch and provides a backend for including and querying data on the model feature space.

Christian S. Perone