All posts

I blog about programming, data, and products.

2023

SQL Recipe: Compare with Neighbors data

Base64 and other encodings in SQLite sqlite

LIMIT vs. FETCH in SQL data

SQL Recipe: Segmenting Data data

SQL Cheat Sheet data

SQL Recipe: Ranking Records data

Rolling Aggregates with SQL Window Functions data

Aggregating Data with SQL Window Functions data

AI SQLite Assistant sqlite

ChatGPT Bot in Python python

Interactive SQL Examples in JavaScript data

Reading and Writing Files in SQLite sqlite

Comparing by Offset with SQL Window Functions data

Building a Pivot Table in SQLite sqlite

Ranking Data with SQL Window Functions data

Cherry-Picked Features from Go 1.20 thank go!

Regular Expressions in SQLite sqlite

Why Use SQL Window Functions data

SQL Window Functions Explained [Book] data

Atomic operations composition in Go thank go!

Idempotent Close in Go thank go!

2022

Speed of algorithms (with cats) software

User-Defined Functions in SQLite sqlite

JSON Lines python

Expressive Ellipsis in Python python

Flying Pig, or Protocols in Python python

Random numbers and sequences in Python python

Common Table Expressions in SQL sqlite

Temporary tables in SQLite sqlite

JSON and virtual columns in SQLite sqlite

Compact objects in Python python

Python Standard Library changes in recent years python

Storing state in the URL software

Generated columns in SQLite sqlite

Page iterator in Python python

Multi-line queries in SQLite shell sqlite

Caching slow functions in Python python

SQLite CLI command history sqlite

The Ultimate SQLite Extension Set sqlite

2021

What's new in SQLite 3.37 sqlite

How Python List Works python

SQLite playground in the browser sqlite

Good Code Criterion software

Data Visualization Guide data

How to make an awesome Python package python

SQLite is not a toy database sqlite

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

Automate your Python project with Makefile python

SQLite is not so easy to compile sqlite

What's new in SQLite 3.35 sqlite