Anton Zhiyanov
projects books blog about ◐

2023

Interactive code cells

SQL Polyglot

Trying chDB, an embeddable ClickHouse engine

Interactive code examples for fun and profit

SQLite 3.44 interactive tour

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

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

  • Subscribe: Newsletter Twitter Bluesky Mastodon LinkedIn GitHub RSS
  • Email: m@antonz.org
  • ∅  AI HN