Anton Zhiyanov

SQLite is not a toy database

Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.

Go Concurrency Distilled

Interactive mini-book on concurrent programming in Go.

How to make a Python package in 2021

I don't need your query language

Seriously, I don't. I'd prefer SQL.

Python Standard Library changes in recent years

Go Proposal: Secret Mode

Automatically erase memory to prevent secret leaks.

Write the damn code

You are a software engineer. Don't become a prompt refiner.

JSON and Virtual Columns in SQLite

Faster JSON handling in a relational database.

In-browser code playgrounds

Embed and run interactive code snippets entirely in your browser, no server required.

How to create a 1M record table with a single query

With recursive CTE and randomized data.

Beyond OpenAPI

Let's write the docs like it's 2023.

Interactive Code Cells

Like Jupyter notebooks, but for any language.

Writing a Package Manager

Without spending a year on it.

SQLite 3.44: Interactive release notes

Order by in aggregates, better string concatenation, and thorough date formatting.

Trying chDB, an embeddable ClickHouse engine

A lightweight in-process SQL OLAP engine, powered by ClickHouse.

Upsert in SQL

Inserting and updating data with a single query.

Storing State in the URL

So that the app does not reset to zero after page refresh.

Go 1.26 Interactive Tour

New with expressions, type-safe error checking, and faster everything.

Mastering curl: interactive text guide