Simon Willison·· 7 d ago
parse_number() as a SQLite extension: C vs Rust
parse_number() as a SQLite extension: C vs Rust
AI summary
Research: parse_number() as a SQLite extension: C vs Rust I was out walking the dog when I got curious about how easy/difficult it would be to write a SQLite C extension that adds a parse_number() function for turning strings like -$1,234.56 or '12.5%' into numeric values that could be summed and sorted.
Selection record
Threshold 76Media and individualsFirst 22Second 31
Not admittedSum of both 53 < twice the threshold 152
- Source tier
- Media and individuals; this tier's threshold is 76
- Pre-filter
- passed：用Claude生成SQLite扩展并对比C/Rust性能
A model scores each item twice, independently, against one written standard, out of 100. An item is admitted only when the two scores add up to twice the threshold. The threshold is set per source tier.
Source: Simon Willison · simonwillison.net