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