The Curious Engineer

All blogs / Go

Anton Zhiyanov

antonz.org

Everything about Go, SQL, and software in general.

GoDatabasesCPythonDev tools / editors / IDEs

’00’05’10’15’20’25
Posts
114 from 1 Jan 2000 to 26 Sep 2026
Posting
weekly (24 in the last year)
Kind
personal blog
Feed
https://antonz.org/all/index.xml

2026 18

  1. Go concurrency distilled
  2. Solod 0.4: Better C interop
  3. Going freestanding
  4. Relying on Go
  5. Going Backward: Reinventing Go's iterator
  6. Solod 0.3: Concurrency, JSON, more safety
  7. Gist of Go: Concurrency
  8. On interactive Go tours
  9. Go-flavored concurrency in C
  10. Solod 0.2: Networking, new targets, friendlier interop
  11. Solod 0.1: Go ergonomics, practical stdlib, native C interop
  12. Porting Go's strings package to C
  13. Porting Go's io package to C
  14. Solod: Go can be a better C
  15. Allocators from C to Zig
  16. (Un)portable defer in C
  17. Interfaces and traits in C
  18. Fear is not advocacy

2025 22

  1. Go 1.26 interactive tour
  2. 'Better C' playgrounds
  3. Detecting goroutine leaks with synctest/pprof
  4. Timing 'Hello, world'
  5. 'Gist of Go: Concurrency' is out!
  6. Compact objects in Python
  7. Write the damn code
  8. Go is #2 among newer languages
  9. Accepted! Go proposals distilled
  10. Native threading and multiprocessing in Go
  11. Building blocks for idiomatic Go pipelines
  12. Expressive tests without testify/assert
  13. Redka: Redis re-implemented with SQL
  14. Concise test assertions with Be
  15. JSON evolution in Go: from v1 to v2
  16. Sad story of http.DefaultTransport
  17. Am I online?
  18. Sandboxes
  19. Go's map does not shrink
  20. Howto: Humble command-line assistant
  21. TILs are junk food
  22. Proofread and translate text in VS Code

2024 19

  1. Banned for self-promo
  2. Interactive code examples for fun and profit
  3. High-precision date/time in SQLite
  4. Go features by version
  5. Go 1.23 interactive tour
  6. Resetting timers in Go
  7. UUIDv7 in 33 languages
  8. Secure delete in SQLite
  9. LLMs are insecure
  10. Delete limit in SQLite
  11. STRICT tables in SQLite
  12. Generated columns in SQLite
  13. Grep by example: Interactive guide
  14. Git by example: Interactive guide
  15. I'm a programmer and I'm stupid
  16. Try X in Y minutes
  17. Code playground visualizations
  18. In-browser code playgrounds
  19. Go 1.22 interactive tour

2023 34

  1. Interactive code cells
  2. Trying chDB, an embeddable ClickHouse engine
  3. Don't work with Educative
  4. Upsert in SQL
  5. Curl by example: Interactive guide
  6. API tutorials beyond OpenAPI
  7. Writing a package manager
  8. Trying Odin (with a playground)
  9. How to install an SQLite extension
  10. Built-in functions in Go 1.21
  11. I don't need your query language
  12. Covering index in SQL
  13. Blogging myths you should care about
  14. Powerful string functions in SQLite
  15. SQL recipe: Compare with neighbors
  16. SQL join flavors
  17. Hashing, encoding and decoding in SQLite
  18. LIMIT vs. FETCH in SQL
  19. SQL recipe: Segmenting data
  20. SQL Cheat Sheet
  21. SQL recipe: Ranking records
  22. SQL window functions: Rolling aggregates
  23. SQL window functions: Aggregation
  24. ChatGPT bot in Python
  25. Reading and writing files in SQLite
  26. SQL window functions: Offset
  27. Building a pivot table in SQLite
  28. SQL window functions: Ranking
  29. Regular expressions in SQLite
  30. Why use SQL window functions
  31. Go 1.20 highlights
  32. SQL Window Functions Explained
  33. Atomic operations composition in Go
  34. Idempotent close in Go

2022 10

  1. Speed of algorithms (with cats)
  2. User-defined functions in SQLite
  3. JSON Lines
  4. Expressive ellipsis in Python
  5. Flying pig, or protocols in Python
  6. Common table expressions in SQL
  7. Temporary tables in SQLite
  8. JSON and virtual columns in SQLite
  9. Page iterator in Python
  10. The ultimate SQLite extension set

2021 7

  1. How Python list works
  2. SQLite playground in the browser
  3. Good code criteria
  4. Data visualization guide
  5. SQLite is not a toy database
  6. How to create a 1M record table with a single query
  7. Automate your Python project with Makefile

2020 1

  1. Storing state in the URL

2011 1

  1. High-precision date/time in C

2000 2

  1. Go 1.25 interactive tour
  2. Go 1.24 interactive tour