Anton Zhiyanov

Archive

Sandboxes, howto and grep by example

Hi! Long time no see. Hope you are doing well.

I'm Anton. I work on open source and write interactive technical books.

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Since the last issue, I've open-sourced 30+ sandboxes — from programming languages to databases to networking and CLI tools. You can use them to experiment locally, or embed interactive examples in your writing.

I've also released Howto — a humble command-line assistant. It does not interfere with your workflow. It's not an alternate shell or "intelligent terminal" or anything. You ask, and Howto answers — that's the deal.

#12
May 2, 2025
Read more

Gist of Go: Concurrency

Hi! Long time no see. Hope you are doing well.

I'm Anton. I work on open source and write interactive technical books.

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Since the last issue, I've published the first part of Gist of Go: Concurrency. It is an interactive book that teaches Go concurrency from the ground up through practical exercises. Already published chapters cover goroutines, channels, pipelines, time, context, and wait groups. More are on the way!

Speaking of Go, the next release (1.24) is scheduled for February, so I've prepared an interactive tour. It's much more accessible than the official release notes, and covers generic aliases, weak pointers, directory-scoped filesystem access, synthetic time, and many other features.

#11
January 15, 2025
Read more

Redis, timers and UUIDv7

Hi! Long time no see. Hope your summer is going well.

I'm Anton, Go developer and SQLite enthusiast. I work on open source and blog about programming.

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Since the last issue, I continued working on Redka — Redis re-implemented with SQLite. With strings, lists, sets, hashes and sorted sets implemented, Redka is now functionally ready for 1.0. Feel free to try it in non-critical production scenarios and provide feedback in the issues.

Speaking of SQLite, I've published more short notes about handy SQLite features you might not know about: generated columns, secure delete and delete limit.

#10
July 11, 2024
Read more

Redis, SQLite, and a bit of grep

Redis with SQLite, strict tables, and grep by example.

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see! (even longer than usual, sorry about that) Hope you are well.

#9
May 7, 2024
Read more

Try X in Y minutes

Try X in Y minutes, Git by example, and zero dependency club.

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see! Hope you are well.

#8
March 17, 2024
Read more

Code playground visualizations

Playground visualizations, online code editor/runner, and SQLite extension hub.

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see! Hope you are well.

#7
February 12, 2024
Read more

SQL polyglot and interactive code cells

Try a query anywhere from PostgreSQL to DuckDB. Play with upcoming versions of Go and SQLite in your browser. Run code playgrounds without a server.

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see! Hope the winter holidays went well for you.

#6
January 10, 2024
Read more

Interactive code examples for fun and profit

Using code playgrounds for documentation, teaching and blogging.

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see! Hope you are well.

#5
December 5, 2023
Read more

Good code criteria

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

What a month, huh?

Since the last issue, I've written an interactive guide to Upsert in SQL, that covers all the major database engines. It's fun to see how each vendor has implemented upserts in their own unique way. Fortunately, some implementations are more popular than others. And, of course, there is a standard version.

#4
October 27, 2023
Read more

Mastering curl and API tutorials

Hi! I'm Anton, Go developer and SQLite enthusiast. I work on open-source and blog about programming.

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

I hope you are having a good week :)

Since the last issue, I've written a couple of interactive articles (meaning you can try all the code examples from the browser while reading):

#3
September 14, 2023
Read more

Code playgrounds

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

Long time no see!

Since the last issue, I've finished describing my experiences with Writing a package manager. You probably don't need to write your own package manager right now. But if you ever do (or if you're just curious) — check out this guide with all the design choices and implementation details!

#2
August 24, 2023
Read more

SQLite extensions and trying Odin

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

You're receiving this email because you subscribed to my updates at antonz.org/subscribe. If you'd like to unsubscribe, use the link at the bottom of this email.

For the last month I have been working mainly on sqlpkg-cli — the (unofficial) SQLite package manager. I've blogged about some of the improvements:

  • Transferring SQLite extensions with Lockfile.
  • Escaping macOS quarantine for SQLite extensions.
#1
August 3, 2023
Read more
antonz.org
This email brought to you by Buttondown, the easiest way to start and grow your newsletter.