All posts

I mostly blog about programming and data.

2024

Resetting timers in Go

UUIDv7 in 33 languages

Modern SQLite: Delete limit

Funding my projects

Modern SQLite: Secure delete

LLMs are insecure

Modern SQLite: Generated columns

Modern SQLite: STRICT tables

Grep by example: Interactive guide

Git by example: Interactive guide

Banned for self-promo

I'm a programmer and I'm stupid

Try X in Y minutes

Code playground visualizations

SQLite 3.45: Interactive release notes

In-browser code playgrounds

Go 1.22: Interactive release notes

2023

Interactive code cells

SQL Polyglot

Trying chDB, an embeddable ClickHouse engine

Interactive code examples for fun and profit

SQLite 3.44: Interactive release notes

Interactive FerretDB Tutorial

Don't work with Educative

Upsert in SQL

What to expect from upvotes on Hacker News

Curl by example: Interactive guide

API tutorials beyond OpenAPI

Writing a package manager

Trying Odin (with a playground)

Joining Mastodon

Escaping macOS quarantine for SQLite extensions

Transferring SQLite extensions with Lockfile

Publishing to Discord

SQLite package manager and registry

How to install an SQLite extension

SQLite playground with extensions

Built-in functions in Go 1.21

SQL join flavors

I don't need your query language

Python's sqlite3 with extensions

Covering index in SQL

Blogging myths you should care about

More string functions in SQLite

SQL recipe: Compare with neighbors

Base64 and other encodings in SQLite

LIMIT vs. FETCH in SQL

SQL recipe: Segmenting data

SQL Cheat Sheet

SQL recipe: Ranking records

Rolling aggregates with SQL window functions

Aggregating data with SQL window functions

AI SQLite assistant

ChatGPT bot in Python

Interactive SQL examples in JavaScript

Reading and writing files in SQLite

Comparing by offset with SQL window functions

Building a pivot table in SQLite

Ranking data with SQL window functions

Cherry-picked features from Go 1.20

Regular expressions in SQLite

Why use SQL window functions

SQL Window Functions Explained [book]

Atomic operations composition in Go

Idempotent close in Go

2022

Speed of algorithms (with cats)

User-defined functions in SQLite

JSON Lines

Expressive ellipsis in Python

Flying pig, or protocols in Python

Random numbers and sequences in Python

Common table expressions in SQL

Temporary tables in SQLite

JSON and virtual columns in SQLite

Compact objects in Python

Python standard library changes in recent years

Storing state in the URL

Generated columns in SQLite

Page iterator in Python

Multi-line queries in SQLite shell

Caching slow functions in Python

SQLite CLI command history

The ultimate SQLite extension set

2021

What's new in SQLite 3.37

How Python list works

SQLite playground in the browser

Good code criteria

Data visualization guide

How to make an awesome Python package

SQLite is not a toy database

How to create a 1M record table with a single query

Automate your Python project with Makefile

SQLite is not so easy to compile

What's new in SQLite 3.35