Anton Zhiyanov
projects books blog about
SQL Window Functions

SQL Window Functions Book
Learn how to create great analytical reports without using Excel or Pandas. A clear and visual guide to window functions in SQL.

Learn more

Featured blog posts

I mostly blog about programming and data.

latest post
Grep by example: Interactive guide
software

Git by example

Try X in Y minutes

Speed of algorithms 🐈

 

Interactive code examples

API tutorials beyond OpenAPI

Writing a package manager

sql

Window functions

Common table expressions

Join flavors

golang

Go 1.22 release notes

Idempotent close

Atomics composition

sqlite

SQLite is not a toy database

Interactive playground

Extensions


all posts →

Projects

Things I'm working on:

codapi  go js

Interactive code examples for documentation, education and fun.

Try X in Y minutes  js

Live code tutorials in your browser. Community-driven!

sqlean  c

The ultimate set of SQLite extensions.

sqlpkg  go js

SQLite extension hub and package manager.

pokitoki  python

A Telegram chat bot built using the ChatGPT language model.

Books

Guides I wrote:

SQL Window Functions Explained
SQL Window Functions Explained
Curl by Example
Curl by Example Minibook
Git by Example
Git by Example Minibook
Grep by Example
Grep by Example Minibook

About

Hi! I’m Anton, Golang developer and SQLite enthusiast. I work on open source and blog about programming.

GitHub Twitter Subscribe