Notation for SQL conditions in JSON strings https://sudonull.com/notation-for-sql-conditions-in-json-strings
Compact string notation for generating SQL expressions from JSON. Support for sets, intervals, MIN/MAX. Regular validation and examples for developers. Study and implement in preprocessor.
Data Types for Passport and Identifiers in SQL: Storage Errors https://sudonull.com/data-types-for-passport-and-identifiers-in-sql-storage-errors
Learn why passport and other identifiers should be stored as strings, not numbers in SQL. Avoid loss of leading zeros and data errors. Read the guide for developers.
Go Pitfalls: slices channels nil https://sudonull.com/go-pitfalls-slices-channels-nil
We analyze unexpected behavior of slices, channels, strings, and nil in Go. Code examples, implementation details for middle/senior developers. Learn Go without surprises.
SearchValues and FrozenCollections in .NET 8 for optimization https://sudonull.com/searchvalues-and-frozencollections-in-net-8-for-optimization
Learn how SearchValues and FrozenCollections speed up search in .NET 8 hot paths. Benchmarks: 13x on strings, 2x on dictionaries. Instructions for developers with code examples.
Hybrid code search in GitLab across 100+ projects https://sudonull.com/hybrid-code-search-in-gitlab-across-100-projects
Speed up string search in GitLab: API for code, deep scan for YAML/JSON/env. python-gitlab script reduces time from hours to minutes. Code and instructions for middle/senior dev.