Anton Zhiyanov

I'm a Python/Golang developer and SQLite enthusiast. I work on open-source, teach courses, and blog about programming.

Joined on Mar 16, 2021 https://antonz.org/

Anton Zhiyanov

Jun 13 '23

Covering Index in SQL

#sql #database

2 min read

Want to connect with Anton Zhiyanov?

Create an account to connect with Anton Zhiyanov. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Anton Zhiyanov

Jun 8 '23

More String Functions in SQLite

#database #sql #sqlite

3 min read

Anton Zhiyanov

Jun 5 '23

SQL Recipe: Compare with Neighbors

#sql #analytics

3 min read

Anton Zhiyanov

Jun 4 '23

Base64 and other encodings in SQLite

#database #sql #sqlite

2 min read

Anton Zhiyanov

Jun 2 '23

LIMIT vs. FETCH in SQL

#sql

2 min read

Anton Zhiyanov

May 24 '23

SQL Recipe: Segmenting Data

#sql #analytics

2 min read

Anton Zhiyanov

May 12 '23

SQL Recipe: Ranking Records

#sql #analytics

2 min read

Anton Zhiyanov

Mar 16 '23

AI SQLite Assistant

#sqlite #sql #ai #chatgpt

1 min read

Anton Zhiyanov

Mar 6 '23

Interactive SQL Examples in JavaScript

#sql #sqlite #javascript

3 min read

Anton Zhiyanov

Feb 27 '23

Reading and Writing Files in SQLite

#sql #sqlite

4 min read

Anton Zhiyanov

Feb 7 '23

Cherry-Picked Features from Go 1.20

#go #programming

4 min read

Anton Zhiyanov

Feb 4 '23

Regular Expressions in SQLite

#sql #sqlite #regex

2 min read

Anton Zhiyanov

Jan 23 '23

SQL Window Functions Explained

2 min read

Anton Zhiyanov

Jan 17 '23

Atomic operations composition in Go

#go #programming

2 min read

Anton Zhiyanov

Jan 11 '23

Idempotent Close in Go

#go #programming

2 min read

Anton Zhiyanov

Dec 22 '22

Speed of algorithms (with cats)

#algorithms #beginners

3 min read

Anton Zhiyanov

Mar 16 '21

Automate your Python project with Makefile

#python #devops #automation #makefile

3 min read

DEV Community

Anton Zhiyanov

Badges

Three Year Club

Writing Debut

Two Year Club

4 Week Writing Streak

One Year Club

Covering Index in SQL

Want to connect with Anton Zhiyanov?

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 Recipe: Ranking Records

AI SQLite Assistant

Interactive SQL Examples in JavaScript

Reading and Writing Files in SQLite

Cherry-Picked Features from Go 1.20

Regular Expressions in SQLite

SQL Window Functions Explained

Atomic operations composition in Go

Idempotent Close in Go

Speed of algorithms (with cats)

Automate your Python project with Makefile