Rants

Buckets of Parquet Files are Awful

From the "not my job" department

Engineering

Realtime Analytics with DuckDB

Scratch Data lets you do realtime analytics with DuckDB

Launches

Sync Data with your Customers' Warehouse

Scratch Data lets you push and pull data to your customers' warehouse.

Launches

Integrating with BigQuery and Redshift

Scratch Data now integrates with BigQuery and Redshift

Engineering

Debugging a Golang Bug with Non-Blocking Reads

We found a bug when doing non-blocking IO in Go. Here's our workaround.

Customers

Juniper + Scratch Data

Scratch Data helps Juniper enrich their CRM

Customers

Bilanc + Scratch Data

Scratch Data powers Bilanc's financial engine

Engineering

Building a Scalable Accounting Ledger

How to use an analytics database to build a ledger that can handle millions of rows.

Engineering

PEG Parsers and PostgREST

How we're bringing PostgREST's ease of use to other databases

Launches

Realtime APIs from your Analytics Database

Scratch Data lets you safely turn analytics database into a realtime API

Engineering

How to use DuckDB as a REST API

We used mkfifo to turn DuckDB into a RESTful API

Customers

Embeddables + Scratch Data

Scratch Data Enhances Embeddables' Query Speed and Data Management

Engineering

Flattening and Denormalizing JSON

How to denormalize JSON to make it SQL-friendly

Recipes

Analyze Stripe Data with SQL

How to use Stripe webhooks to ingest activity to a database

Recipes

Analyze Shopify Data with SQL

How to use Shopify webhooks to ingest activity to a database

Recipes

Browser Screen Recording with rrweb

Engineering

Zero-Downtime Hetzner Deploys with Ansible

How we do rolling, zero-downtime deploys to Hetzner Cloud

Recipes

Capture Form Responses to Google Sheets

How to save form submissions to Clickhouse

Recipes

Forwarding Fly.io Logs to Clickhouse

How to send logs from Fly.io into Clickhouse and query them with SQL

Engineering Clickhouse

Incremental Clickhouse Backups

How to use Clickhouse's built-in backup functionality to backup and restore data to S3