antonz.org 8. 8. 2024High-precision date/time in SQLite – antonz.org 30. 7. 2024Gist of Go: Wait groups – antonz.org 30. 7. 2024Gist of Go: Goroutines – antonz.org 30. 7. 2024Gist of Go: Concurrency – antonz.org 22. 7. 2024Go features by version – antonz.org 20. 7. 2024Go 1.23: Interactive release notes – antonz.org 5. 7. 2024Resetting timers in Go – antonz.org 15. 6. 2024UUIDv7 in 24 languages – antonz.org 11. 6. 2024Modern SQLite: Delete limit – antonz.org 9. 6. 2024Funding my projects – antonz.org 29. 5. 2024Modern SQLite: Secure delete – antonz.org 23. 5. 2024LLMs are insecure – antonz.org 8. 5. 2024Modern SQLite: Generated columns – antonz.org 4. 5. 2024Modern SQLite: STRICT tables – antonz.org 23. 3. 2024Grep by example: Interactive guide – antonz.org 14. 3. 2024Git by example: Interactive guide – antonz.org 10. 3. 2024Banned for self-promo – antonz.org 6. 3. 2024I'm a programmer and I'm stupid – antonz.org 20. 2. 2024Try X in Y minutes – antonz.org 9. 2. 2024Code playground visualizations – antonz.org 9. 1. 2024SQLite 3.45: Interactive release notes – antonz.org 6. 1. 2024In-browser code playgrounds – antonz.org 21. 12. 2023Go 1.22: Interactive release notes – antonz.org 16. 12. 2023Interactive code cells – antonz.org 14. 12. 2023SQL Polyglot – antonz.org 13. 12. 2023A MariaDB Primer – antonz.org 11. 12. 2023Trying chDB, an embeddable ClickHouse engine – antonz.org 5. 12. 2023Interactive code examples for fun and profit – antonz.org 30. 10. 2023SQLite 3.44: Interactive release notes – antonz.org 23. 10. 2023Interactive FerretDB Tutorial – antonz.org 14. 10. 2023Don't work with Educative – antonz.org 25. 9. 2023Upsert in SQL – antonz.org 13. 9. 2023What to expect from upvotes on Hacker News – antonz.org 4. 9. 2023Mastering curl: interactive text guide – antonz.org 30. 8. 2023Interactive API tutorials – antonz.org 8. 8. 2023Writing a package manager – antonz.org 31. 7. 2023Trying Odin – antonz.org 29. 7. 2023Joining Mastodon – antonz.org 24. 7. 2023Escaping macOS quarantine for SQLite extensions – antonz.org 13. 7. 2023How to Transfer SQLite Extensions to Another Machine – antonz.org 4. 7. 2023Publishing to Discord – antonz.org 3. 7. 2023SQLite Package Manager/Registry – antonz.org 1. 7. 2023How to Install an SQLite Extension – antonz.org 27. 6. 2023SQLite Playground with Extensions – antonz.org 23. 6. 2023Built-in functions in Go 1.21 – antonz.org 20. 6. 2023SQL Join Flavors – antonz.org 17. 6. 2023I Don't Need Your Query Language – antonz.org 15. 6. 2023Python's sqlite3 with extensions – antonz.org 12. 6. 2023Covering Index in SQL – antonz.org 9. 6. 2023Blogging Myths You Should Care About – antonz.org 7. 6. 2023More String Functions in SQLite – antonz.org 3. 6. 2023Compare with Neighbors in SQL – antonz.org 1. 6. 2023Base64 and other encodings in SQLite – antonz.org 30. 5. 2023LIMIT vs. FETCH in SQL – antonz.org 23. 5. 2023Segmenting Data in SQL – antonz.org 14. 5. 2023SQL Cheat Sheet – antonz.org 11. 5. 2023Ranking Records in SQL – antonz.org 1. 5. 2023Rolling Aggregates with SQL Window Functions – antonz.org 30. 4. 2023Aggregating Data with SQL Window Functions – antonz.org 16. 3. 2023AI SQLite Assistant – antonz.org 11. 3. 2023ChatGPT Bot in Python – antonz.org 5. 3. 2023Interactive SQL Examples in JavaScript – antonz.org 26. 2. 2023Reading and Writing Files in SQLite – antonz.org 16. 2. 2023Comparing by Offset with SQL Window Functions – antonz.org 9. 2. 2023Building a Pivot Table in SQLite – antonz.org 8. 2. 2023SQL Window Functions: Ranking – antonz.org 7. 2. 2023Cherry-Picked Features from Go 1.20 – antonz.org 4. 2. 2023Regular Expressions in SQLite – antonz.org 31. 1. 2023Why Use SQL Window Functions – antonz.org 22. 1. 2023SQL Window Functions Explained Book – antonz.org 17. 1. 2023Atomic operations composition in Go – antonz.org 11. 1. 2023Idempotent Close in Go – antonz.org 21. 12. 2022Speed of algorithms (with cats) – antonz.org 14. 9. 2022SQLite Weekly – antonz.org 8. 9. 2022User-defined functions in SQLite – antonz.org 4. 8. 2022JSON Lines – antonz.org 3. 6. 2022Expressive Ellipsis in Python – antonz.org 31. 5. 2022Flying Pig, or Protocols in Python – antonz.org 23. 5. 2022Random numbers and sequences in Python – antonz.org 20. 5. 2022Common Table Expressions in SQL – antonz.org 18. 5. 2022Temporary tables in SQLite – antonz.org 15. 5. 2022JSON and virtual columns in SQLite – antonz.org 13. 5. 2022Compact objects in Python – antonz.org 11. 5. 2022Python Standard Library changes in recent years – antonz.org 8. 5. 2022Storing state in the URL – antonz.org 7. 5. 2022Generated columns in SQLite – antonz.org 2. 5. 2022Page iterator in Python – antonz.org 24. 4. 2022Multi-line queries in SQLite shell – antonz.org 23. 4. 2022Caching slow functions in Python – antonz.org 17. 4. 2022SQLite CLI command history – antonz.org 4. 1. 2022The ultimate SQLite extension set – antonz.org 28. 11. 2021What's new in SQLite 3.37 – antonz.org 12. 11. 2021How Python list really works – antonz.org 4. 10. 2021SQLite playground in the browser – antonz.org 4. 10. 2021SQLite playground in the browser – antonz.org 2. 6. 2021Good Code Criterion – antonz.org 2. 6. 2021Good Code Criterion – antonz.org 10. 4. 2021Data Visualization Guide – antonz.org 10. 4. 2021Data Visualization Guide – antonz.org 6. 4. 2021How to make an awesome Python package in 2021 – antonz.org 6. 4. 2021How to make an awesome Python package in 2021 – antonz.org 25. 3. 2021SQLite is not a toy database – antonz.org 25. 3. 2021SQLite is not a toy database – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 12. 3. 2021What’s new in SQLite 3.35 – antonz.org 12. 3. 2021What’s new in SQLite 3.35 – antonz.org 12. 3. 2021What's new in SQLite 3.35 – antonz.org
8. 8. 2024High-precision date/time in SQLite – antonz.org 30. 7. 2024Gist of Go: Wait groups – antonz.org 30. 7. 2024Gist of Go: Goroutines – antonz.org 30. 7. 2024Gist of Go: Concurrency – antonz.org 22. 7. 2024Go features by version – antonz.org 20. 7. 2024Go 1.23: Interactive release notes – antonz.org 5. 7. 2024Resetting timers in Go – antonz.org 15. 6. 2024UUIDv7 in 24 languages – antonz.org 11. 6. 2024Modern SQLite: Delete limit – antonz.org 9. 6. 2024Funding my projects – antonz.org 29. 5. 2024Modern SQLite: Secure delete – antonz.org 23. 5. 2024LLMs are insecure – antonz.org 8. 5. 2024Modern SQLite: Generated columns – antonz.org 4. 5. 2024Modern SQLite: STRICT tables – antonz.org 23. 3. 2024Grep by example: Interactive guide – antonz.org 14. 3. 2024Git by example: Interactive guide – antonz.org 10. 3. 2024Banned for self-promo – antonz.org 6. 3. 2024I'm a programmer and I'm stupid – antonz.org 20. 2. 2024Try X in Y minutes – antonz.org 9. 2. 2024Code playground visualizations – antonz.org 9. 1. 2024SQLite 3.45: Interactive release notes – antonz.org 6. 1. 2024In-browser code playgrounds – antonz.org 21. 12. 2023Go 1.22: Interactive release notes – antonz.org 16. 12. 2023Interactive code cells – antonz.org 14. 12. 2023SQL Polyglot – antonz.org 13. 12. 2023A MariaDB Primer – antonz.org 11. 12. 2023Trying chDB, an embeddable ClickHouse engine – antonz.org 5. 12. 2023Interactive code examples for fun and profit – antonz.org 30. 10. 2023SQLite 3.44: Interactive release notes – antonz.org 23. 10. 2023Interactive FerretDB Tutorial – antonz.org 14. 10. 2023Don't work with Educative – antonz.org 25. 9. 2023Upsert in SQL – antonz.org 13. 9. 2023What to expect from upvotes on Hacker News – antonz.org 4. 9. 2023Mastering curl: interactive text guide – antonz.org 30. 8. 2023Interactive API tutorials – antonz.org 8. 8. 2023Writing a package manager – antonz.org 31. 7. 2023Trying Odin – antonz.org 29. 7. 2023Joining Mastodon – antonz.org 24. 7. 2023Escaping macOS quarantine for SQLite extensions – antonz.org 13. 7. 2023How to Transfer SQLite Extensions to Another Machine – antonz.org 4. 7. 2023Publishing to Discord – antonz.org 3. 7. 2023SQLite Package Manager/Registry – antonz.org 1. 7. 2023How to Install an SQLite Extension – antonz.org 27. 6. 2023SQLite Playground with Extensions – antonz.org 23. 6. 2023Built-in functions in Go 1.21 – antonz.org 20. 6. 2023SQL Join Flavors – antonz.org 17. 6. 2023I Don't Need Your Query Language – antonz.org 15. 6. 2023Python's sqlite3 with extensions – antonz.org 12. 6. 2023Covering Index in SQL – antonz.org 9. 6. 2023Blogging Myths You Should Care About – antonz.org 7. 6. 2023More String Functions in SQLite – antonz.org 3. 6. 2023Compare with Neighbors in SQL – antonz.org 1. 6. 2023Base64 and other encodings in SQLite – antonz.org 30. 5. 2023LIMIT vs. FETCH in SQL – antonz.org 23. 5. 2023Segmenting Data in SQL – antonz.org 14. 5. 2023SQL Cheat Sheet – antonz.org 11. 5. 2023Ranking Records in SQL – antonz.org 1. 5. 2023Rolling Aggregates with SQL Window Functions – antonz.org 30. 4. 2023Aggregating Data with SQL Window Functions – antonz.org 16. 3. 2023AI SQLite Assistant – antonz.org 11. 3. 2023ChatGPT Bot in Python – antonz.org 5. 3. 2023Interactive SQL Examples in JavaScript – antonz.org 26. 2. 2023Reading and Writing Files in SQLite – antonz.org 16. 2. 2023Comparing by Offset with SQL Window Functions – antonz.org 9. 2. 2023Building a Pivot Table in SQLite – antonz.org 8. 2. 2023SQL Window Functions: Ranking – antonz.org 7. 2. 2023Cherry-Picked Features from Go 1.20 – antonz.org 4. 2. 2023Regular Expressions in SQLite – antonz.org 31. 1. 2023Why Use SQL Window Functions – antonz.org 22. 1. 2023SQL Window Functions Explained Book – antonz.org 17. 1. 2023Atomic operations composition in Go – antonz.org 11. 1. 2023Idempotent Close in Go – antonz.org 21. 12. 2022Speed of algorithms (with cats) – antonz.org 14. 9. 2022SQLite Weekly – antonz.org 8. 9. 2022User-defined functions in SQLite – antonz.org 4. 8. 2022JSON Lines – antonz.org 3. 6. 2022Expressive Ellipsis in Python – antonz.org 31. 5. 2022Flying Pig, or Protocols in Python – antonz.org 23. 5. 2022Random numbers and sequences in Python – antonz.org 20. 5. 2022Common Table Expressions in SQL – antonz.org 18. 5. 2022Temporary tables in SQLite – antonz.org 15. 5. 2022JSON and virtual columns in SQLite – antonz.org 13. 5. 2022Compact objects in Python – antonz.org 11. 5. 2022Python Standard Library changes in recent years – antonz.org 8. 5. 2022Storing state in the URL – antonz.org 7. 5. 2022Generated columns in SQLite – antonz.org 2. 5. 2022Page iterator in Python – antonz.org 24. 4. 2022Multi-line queries in SQLite shell – antonz.org 23. 4. 2022Caching slow functions in Python – antonz.org 17. 4. 2022SQLite CLI command history – antonz.org 4. 1. 2022The ultimate SQLite extension set – antonz.org 28. 11. 2021What's new in SQLite 3.37 – antonz.org 12. 11. 2021How Python list really works – antonz.org 4. 10. 2021SQLite playground in the browser – antonz.org 4. 10. 2021SQLite playground in the browser – antonz.org 2. 6. 2021Good Code Criterion – antonz.org 2. 6. 2021Good Code Criterion – antonz.org 10. 4. 2021Data Visualization Guide – antonz.org 10. 4. 2021Data Visualization Guide – antonz.org 6. 4. 2021How to make an awesome Python package in 2021 – antonz.org 6. 4. 2021How to make an awesome Python package in 2021 – antonz.org 25. 3. 2021SQLite is not a toy database – antonz.org 25. 3. 2021SQLite is not a toy database – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 21. 3. 2021How to create a 1M record table with a single query – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 16. 3. 2021Automate your Python project with Makefile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 15. 3. 2021SQLite is not so easy to compile – antonz.org 12. 3. 2021What’s new in SQLite 3.35 – antonz.org 12. 3. 2021What’s new in SQLite 3.35 – antonz.org 12. 3. 2021What's new in SQLite 3.35 – antonz.org