Tool: Syntaqlite Playground (https://tools.simonwillison.net/syntaqlite)

Lalit Maganti's syntaqlite (https://github.com/LalitMaganti/syntaqlite) is currently being discussed on Hacker News (https://news.ycombinator.com/item?id=47648828) thanks to Eight years of wanting, three months of building with AI (https://lalitm.com/post/building-syntaqlite-ai/), a deep dive into exactly how it was built.

This inspired me to revisit a research project (https://github.com/simonw/research/tree/main/syntaqlite-python-extension#readme) I ran when Lalit first released it a couple of weeks ago, where I tried it out and then compiled it to a WebAssembly wheel so it could run in Pyodide in a browser (the library itself uses C and Rust).

This new playground (https://tools.simonwillison.net/syntaqlite) loads up the Python library and provides a UI for trying out its different features: formating, parsing into an AST, validating, and tokenizing SQLite SQL queries.

    Tags: sql (https://simonwillison.net/tags/sql), ai-assisted-programming (https://simonwillison.net/tags/ai-assisted-programming), sqlite (https://simonwillison.net/tags/sqlite), tools (https://simonwillison.net/tags/tools), agentic-engineering (https://simonwillison.net/tags/agentic-engineering)