Anton Zhiyanov
projects
blog
about
All posts
I mostly blog about programming and data.
2023
What to expect from upvotes on Hacker News
Mastering curl: interactive text guide
API tutorials beyond OpenAPI
Writing a package manager
Trying Odin (with a playground)
Joining Mastodon
Escaping macOS quarantine for SQLite extensions
Transferring SQLite extensions with Lockfile
Publishing to Discord
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
More string functions in SQLite
SQL recipe: Compare with neighbors
Base64 and other encodings in SQLite
LIMIT vs. FETCH in SQL
SQL recipe: Segmenting data
SQL Cheat Sheet
SQL recipe: Ranking records
Rolling aggregates with SQL window functions
Aggregating data with SQL window functions
AI SQLite assistant
ChatGPT bot in Python
Interactive SQL examples in JavaScript
Reading and writing files in SQLite
Comparing by offset with SQL window functions
Building a pivot table in SQLite
Ranking data with SQL window functions
Cherry-picked features from Go 1.20
Regular expressions in SQLite
Why use SQL window functions
SQL Window Functions Explained [book]
Atomic operations composition in Go
Idempotent close in Go
2022
Speed of algorithms (with cats)
User-defined functions in SQLite
JSON Lines
Expressive ellipsis in Python
Flying pig, or protocols in Python
Random numbers and sequences in Python
Common table expressions in SQL
Temporary tables in SQLite
JSON and virtual columns in SQLite
Compact objects in Python
Python standard library changes in recent years
Storing state in the URL
Generated columns in SQLite
Page iterator in Python
Multi-line queries in SQLite shell
Caching slow functions in Python
SQLite CLI command history
The ultimate SQLite extension set
2021
What's new in SQLite 3.37
How Python list works
SQLite playground in the browser
Good code criterion
Data visualization guide
How to make an awesome Python package
SQLite is not a toy database
How to create a 1M record table with a single query
Automate your Python project with Makefile
SQLite is not so easy to compile
What's new in SQLite 3.35