Toolsslug: sqliteOfficial Website

SQLite

An embedded relational database engine known for zero-configuration, single-file storage and wide local use.

Curated Intelligence

2 items · Page 1/1
Simon Willison 博客T2·Tools
38 pts
LLM 0.37.3 Ships Fix for SQLite 3.54.1 Compatibility Break

Simon Willison's LLM CLI tool released version 0.37.3, mainly fixing a breakage in its logging code caused by SQLite 3.54.1 shipped in the latest Homebrew package. The root cause is SQLite's corrected behavior where a subquery returns SQL text rather than a JSON value; the fix wraps the subquery in json().

Simon Willison 博客T2·Tools
42 pts
Building a SQLite parse_number Extension in C vs Rust

Simon Willison used Claude to compare implementing a SQLite parse_number() custom function in C versus Rust: the C extension was only 14 KB while the Rust builds were around 300 KB, yet Rust ran faster because its float parsing is roughly twice as fast as C's strtod. He then explored writing a faster hand-rolled C parser and packaged the investigation as a reproducible research report.