Blog

Technical articles and historical engineering writing on software and systems engineering, real-time data processing, artificial intelligence, speech and signal processing, digital forensics, cybersecurity and algorithms.

The Blog contains my technical articles on software and systems engineering, artificial intelligence, digital forensics, cybersecurity, and the history of technology.

Streaming JSON and XML Serialization from DbDataReader

A provider-independent C# design that writes DbDataReader results directly to JSON or XML using one-time schema compilation, typed getters, Utf8JsonWriter, and XmlWriter without materializing a second row graph.

Safe Row Updates in Oracle Without Reliable Unique Keys

Why a single-row update is unsafe in legacy Oracle tables whose uniqueness the database never enforced: separating business key from physical row identity, deterministic candidate selection, ROWID targeting, transaction boundaries, and ORM identity assumptions.

Safe Numeric Conversion in Oracle SQL

Safe numeric conversion in Oracle requires an explicit input format, NLS policy, invalid-value behavior, and NULL semantics before aggregation begins.

An Enumerable CSV Processing Algorithm

Mapping the CSV header to model metadata once and streaming rows avoids repeating reflection work per record and allows large files to be converted without loading them entirely into memory.

Why Delphi Became an Old Technology

A personal engineering perspective from someone who has worked with Delphi, examining how it moved from highly productive desktop RAD to a narrower position in modern open-source, web, mobile, Linux and server-side software ecosystems.

Dynamic QR Code Generation Algorithm

A QR Code Model 2 encoder must construct the complete standard-compliant pipeline, from data mode and Reed-Solomon error correction to matrix placement and mask selection.

Turkish Deasciification in C#

Turkish deasciification restores ASCII-written characters by evaluating surrounding patterns rather than replacing letters in isolation; ambiguity is resolved through lexical and contextual rules.