Anton Zhiyanov
projects 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 occasionally blog about Go, SQL, and software in general.

latest post
Try X in Y minutes
sql

Window functions

Common table expressions

Join flavors

 

Covering index

LIMIT vs. FETCH

Upsert

golang

Idempotent close

Atomics composition

Builtins in Go 1.21

sqlite

SQLite is not a toy database

Interactive playground

Extensions

 

Package manager

String functions

Pivot table

programming

Speed of algorithms

Storing state in the URL

Good code criterion


all posts →

Projects

For developers and data practitioners.

sqlime  js

SQLite playground in the browser.

sqlean  c

The ultimate set of SQLite extensions.

sqlpkg  go

SQLite extension hub and package manager.

codapi  go js

Interactive code examples for documentation, education and fun.

pokitoki  python

A Telegram chat bot built using the ChatGPT language model.

SQL Window Functions  book

A clear and visual introduction to data analysis in SQL.

About

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

GitHub Twitter Subscribe