The Curious Engineer

All blogs / Databases

Binary Igor

binaryigor.com

Binary Igor is a blog about programming, software development, software engineering, computer science, networks and the inner workings of binary machines.

DatabasesSoftware / engineering practicePerformance / optimizationWeb development

’23’24’25’26
Posts
43 from 9 Sep 2023 to 13 Jul 2026
Posting
monthly (18 in the last year)
Kind
personal blog
Feed
https://binaryigor.com/feed.xml

2026 13

  1. The Order of Data: defaults, performance, determinism & paging
  2. Dbs posts
  3. More posts
  4. The Joy and Power of Understanding
  5. Thoughts
  6. Modern Frontend Complexity: essential or accidental?
  7. DeepDive
  8. Ui posts
  9. JSON Documents Performance, Storage and Search: MongoDB vs PostgreSQL
  10. Performance
  11. Data Consistency: transactions, delays and long-running processes
  12. Modularity
  13. MySQL vs PostgreSQL Performance: throughput & latency, reads & writes

2025 13

  1. Authentication: who are you? Proofs are passwords, codes and keys
  2. Auth posts
  3. Modular Monolith and Microservices: parallel work, independent deployments and organization scalability
  4. Modular Monolith and Microservices: Data ownership, boundaries, consistency and synchronization
  5. Optimistic vs Pessimistic Locking: concurrency control, conflicts, lost updates, retries and blocking
  6. Bitcoin Core Code: C++, some Python and a Custom Build System
  7. Centralized vs Decentralized Identity tradeoffs: Twitter/X, YouTube, Mastodon, ActivityPub and NOSTR
  8. Networks
  9. EventSQL: events over SQL
  10. Bitcoin P2P Network: peer discovery, reachability and resilience
  11. Multi vs Single Page Apps: user experience, performance, complexity and more
  12. React and HTMX: different abstractions, different tradeoffs
  13. Htmx posts

2024 10

  1. SQLite DB: simple, in-process, reliable, fast
  2. MySQL and PostgreSQL: different approaches to solve the same problem
  3. HTMX with Shoelace Web Components: using framework-agnostic components in an example app
  4. Programmer in Wonderland
  5. Who controls the Internet and How it works?
  6. Simple yet Scalable Web Analytics: JSON in SQL with batch inserts
  7. Modular Monolith: dependencies and communication between Modules
  8. HTMX: a setup ready for Production
  9. Load Testing: how many HTTP requests/second can a Single Machine handle?
  10. Kubernetes: maybe a few Bash/Python scripts is enough

2023 6

  1. HTMX and Web Components: a Perfect Match
  2. Modular Monolith and Microservices: Modularity is what truly matters
  3. Unit, Integration, E2E, Contract, X tests: what should we focus on?
  4. Index: a crucial data structure for search performance
  5. HTMX: simpler web-based app/system
  6. Indexing, Partitioning, Sharding - it is all about reducing the search space

Undated 1

  1. bootstrap here