Simon Willison benchmarks C and Rust SQLite parse_number() extensions
Overview
Simon Willison builds four SQLite extensions that implement parse_number(), which strips commas, currency signs and percent signs to produce numbers, in C and Rust.
He reports that the optimized C version ran at 16 to 19 ns per row, about twice as fast as the Rust versions and faster than SQL replace(). He says the versions matched across 8 million fuzz checks.
Written by AI from the articles below · updated Nov 8, 6:18 PM ET
Check the sources:
Article timeline
The articles in this story. Times are ET.
- Simon WillisonBlogSimon Willison compares C and Rust SQLite parse_number() extensions
AISimon Willison builds four SQLite extensions implementing parse_number() in C and Rust, which strip commas, currency signs and percent signs to produce numbers. The optimized C version was fastest at 16–19 ns per row, about twice as fast as the Rust versions and far faster than SQL replace(). The versions matched across 8 million fuzz checks.
Heat Trend
Not enough continuous observations to show a trend yet.