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   Other books

Featured blog posts

I mostly blog about programming and data.

latest post
★ High-precision date/time in SQLite
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.23 release notes

Atomics composition

Resetting timers

sqlite

SQLite is not a toy database

Interactive playground

Extensions


all posts →

Projects

Things I'm working on. Production-ready!

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!

redka  go

Redis re-implemented with SQLite.

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

Practical guides with clear explanations and interactive examples.

Gist of Go: Concurrency
Gist of Go: Concurrency (in progress)
SQL Window Functions Explained
SQL Window Functions Explained
Curl by Example
Curl by Example
Git by Example
Git by Example
Grep by Example
Grep by Example

About

Hi, I'm Anton. I work on open source and write about programming.

GitHub Twitter Subscribe