Search Articles — Sudonull

Search Results

In this project

SQLite 3.53: WAL fix and new functions

https://sudonull.com/sqlite-3-53-wal-fix-and-new-functions

SQLite 3.53 release fixes DB corruption bug in WAL, adds REINDEX EXPRESSIONS, json_array_insert, and CLI improvements. Optimizations for middle/senior dev. Download and test.

O(1) vs O(log n) Gap: Cache in Data Structures

https://sudonull.com/o-1-vs-o-log-n-gap-cache-in-data-structures

Why hash table O(1) loses to binary search O(log n) by 40%? Analysis of cache misses, array/list benchmarks and memory hierarchy for RISC-V. Learn real performance.

ClickHouse Data Types: Complete Reference for Analytics

https://sudonull.com/clickhouse-data-types-complete-reference-for-analytics

Int, Decimal, LowCardinality, DateTime64, Array, Enum, Nullable — where to save space without losing speed. Ready schema for a betting platform with examples.

Type-safe PHP arrays: +4x speed

https://sudonull.com/type-safe-php-arrays-4x-speed

Accelerating sbwerewolf/language-specific library by 4 times. Benchmarks against wplake/typed, code examples of chainable API. For PHP developers: readability vs performance. Study the optimizations.

From other projects

Trending Now