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

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)

Escaping macOS quarantine for SQLite extensions

Transferring SQLite extensions with Lockfile

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

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

AI SQLite assistant

ChatGPT bot in Python

Interactive SQL examples in JavaScript

Reading and writing files in SQLite

SQL window functions: Offset

Building a pivot table in SQLite

SQL window functions: Ranking

Cherry-picked features from Go 1.20

Regular expressions in SQLite

Why use SQL window functions

SQL Window Functions Explained

Atomic operations composition in Go

Idempotent close in Go