parse_number() as a SQLite extension: C vs Rust
Source: Simon Willison ·
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 'NULL' for anything it can’t parse Explore the difference between building this as a SQLite extension
Frequently Asked Questions
What is parse_number() as a SQLite extension: C vs Rust?
parse_number() as a SQLite extension: C vs Rust is a article discovery curated from Simon Willison. 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
How can I access or experience this?
You can experience this content directly on its original host (Simon Willison) by clicking the "Open Original" button.
Where does this content come from?
Curated from Simon Willison by the OnSuggest team to surface the most interesting and serendipitous content on the web.
More like this
All Technology discoveries →DIY Quiz Show Controller System #AdafruitLearnSystem
Build a Jeopardy-like Game Show Buzzer with a Circuit Playground Bluefruit! The first player to press their buzzer will illuminate the Host controller with the color of the buzzer handle! You can even enable Bluetooth button presses to a computer or mobile device! The code is written in CircuitPython, so it’s easy to change the […]
Nvidia CEO Jensen Huang admits to having an affair with suspected Chinese spy
Nvidia's board of directors is investigating a report about Jensen Huang's alleged affair with a client, claims it is still confident in Jensen and leadership team.
Catch the backyard raccoon in the act with $105 night vision binoculars
TL;DR: Get Double Barrel 720p Digital Night Vision Binoculars with infrared LEDs and 4x zoom for $104.97 (reg. $297.99). Regular binoculars stop being useful once the sun goes down, because they can only magnify light that's already there. If you want to see what's moving around after dark, try the Double Barrel 720p Digital Night Vision Binoculars. — Read the rest The post Catch the backyard raccoon in the act with $105 night vision binoculars appeared first on Boing Boing .
Inside Viggle Remake: LoRA-Based Video Editing With MiniMax-H3
Explore Viggle Remake's AI video editing capabilities, LoRA architecture, character swapping, reference frames, GPU requirements, and limitations.
Hybrid Kubernetes: The Challenges of Managing Clusters Across Environments
Hybrid cloud flexibility isn't a checkbox. What operational consistency means for container workloads, where hybrid breaks down, and how to evaluate it.
How I Built a Mobile Game Attribution Model Using SQL and Organic Uplift
Learn how a data engineer rebuilt mobile game attribution using SQL, unified install data, revenue cohorts, and organic uplift modeling.