WeWorkBuddy

parse_number() as a SQLite extension: C vs Rust

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. I fired up regular Claude chat (Opus 5.5) and prompted : I'm thinking about a SQLite custom function 'parse_number(value)' that strips ',', '$', '£' and '%', handles a leading '-', and returns '

阅读原始来源
原始网页截图: parse_number() as a SQLite extension: C vs Rust
原始网页截图 · simonwillison.net

来源记录

研究分析

来源记录

来源描述: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. I fired up regular Claude chat (Opus 5.5) and prompted : I'm thinking about a SQLite custom function 'parse_number(value)' that strips ',', '$', '£' and '%', handles a leading '-', and returns '

现有背景

可供比较的近期同类记录:“Coordinated disturbances haunt grids worldwide. Here’s how researchers solved the mystery.” (TechCrunch, 2026年11月8日);“The end of Microsoft Research's AI Frontiers group” (Hacker News, 2026年11月7日)。主题相近仅用于导航,未核验其是否属于同一需求或独立证据。

研究状态

这条记录尚不能可靠归入主类,未生成商业或性能结论。

缺失证据

需要核验主要事件、受影响对象与原始证据。

下一步

阅读原文,明确它支持什么决策,再选择对应分析框架。