Anton Zhiyanov
blog
contacts
ru
All posts
I blog about programming, data, and products.
2023
SQL Recipe: Compare with Neighbors
data
Base64 and other encodings in SQLite
sqlite
LIMIT vs. FETCH in SQL
data
SQL Recipe: Segmenting Data
data
SQL Cheat Sheet
data
SQL Recipe: Ranking Records
data
Rolling Aggregates with SQL Window Functions
data
Aggregating Data with SQL Window Functions
data
AI SQLite Assistant
sqlite
ChatGPT Bot in Python
python
Interactive SQL Examples in JavaScript
data
Reading and Writing Files in SQLite
sqlite
Comparing by Offset with SQL Window Functions
data
Building a Pivot Table in SQLite
sqlite
Ranking Data with SQL Window Functions
data
Cherry-Picked Features from Go 1.20
thank go!
Regular Expressions in SQLite
sqlite
Why Use SQL Window Functions
data
SQL Window Functions Explained [Book]
data
Atomic operations composition in Go
thank go!
Idempotent Close in Go
thank go!
2022
Speed of algorithms (with cats)
software
User-Defined Functions in SQLite
sqlite
JSON Lines
python
Expressive Ellipsis in Python
python
Flying Pig, or Protocols in Python
python
Random numbers and sequences in Python
python
Common Table Expressions in SQL
sqlite
Temporary tables in SQLite
sqlite
JSON and virtual columns in SQLite
sqlite
Compact objects in Python
python
Python Standard Library changes in recent years
python
Storing state in the URL
software
Generated columns in SQLite
sqlite
Page iterator in Python
python
Multi-line queries in SQLite shell
sqlite
Caching slow functions in Python
python
SQLite CLI command history
sqlite
The Ultimate SQLite Extension Set
sqlite
2021
What's new in SQLite 3.37
sqlite
How Python List Works
python
SQLite playground in the browser
sqlite
Good Code Criterion
software
Data Visualization Guide
data
How to make an awesome Python package
python
SQLite is not a toy database
sqlite
How to create a 1M record table with a single query
sqlite
Automate your Python project with Makefile
python
SQLite is not so easy to compile
sqlite
What's new in SQLite 3.35
sqlite