Mapping SQLite Result Columns Back to Their Source table.column
Simon Willison's Weblog7 hours agoTutorialSimon Willison explored how to programmatically map SQLite query result columns back to their source table and column names — a capability that would let Datasette enrich query results with contextual metadata. He tasked Claude Code (Opus 4.8) with finding solutions, which surfaced three approaches: using the apsw library, calling SQLite's sqlite3_column_table_name() C function via Python ctypes, and parsing EXPLAIN bytecode output. The research is published as a GitHub README and covers the tradeoffs of each technique.
Office-open-xml-viewer: Office XML document viewer rendering to HTML Canvas
Hacker News (AI keywords)7 days agoNew Tooloffice-open-xml-viewer is an open-source browser viewer for Office Open XML documents, rendering DOCX, XLSX, and PPTX files to HTML Canvas. Its parsers are written in Rust and compiled to WebAssembly, while rendering uses the Canvas 2D API. The README also says the full codebase was implemented by Claude through iterative prompting, making it notable as an AI-assisted software development case.