2023

Interactive code cells

Trying chDB, an embeddable ClickHouse engine

Interactive code examples for fun and profit

Don't work with Educative

Upsert in SQL

Curl by example: Interactive guide

API tutorials beyond OpenAPI

Writing a package manager

Trying Odin (with a playground)

How to install an SQLite extension

Built-in functions in Go 1.21

SQL join flavors

I don't need your query language

Covering index in SQL

Blogging myths you should care about

Powerful string functions in SQLite

SQL recipe: Compare with neighbors

Hashing, encoding and decoding in SQLite

LIMIT vs. FETCH in SQL

SQL recipe: Segmenting data

SQL Cheat Sheet

SQL recipe: Ranking records

SQL window functions: Rolling aggregates

SQL window functions: Aggregation

ChatGPT bot in Python

Reading and writing files in SQLite

SQL window functions: Offset

Building a pivot table in SQLite

SQL window functions: Ranking

Go 1.20 highlights

Regular expressions in SQLite

Why use SQL window functions

SQL Window Functions Explained

Atomic operations composition in Go

Idempotent close in Go