webbed-duck 0.2.0

A parameterized SQL web server for DuckDB routes compiled from Markdown

webbed_duck

webbed_duck turns Markdown + SQL route files into HTTP endpoints powered by DuckDB.

This MVP (v0.2) extends the core compiler and server with production-friendly viewers:

• A Markdown compiler that translates *.sql.md files into Python route manifests and preserves per-route metadata for cards, feeds, charts, and asset hints.
• A FastAPI-based server that executes DuckDB queries per-request and returns JSON payloads derived from Arrow tables, HTML tables (html_t), card grids (html_c), feed views, and Arrow stream slices for virtualized viewers.
• Popularity analytics and folder indexes surfaced at /routes to power simple navigation and release readiness checks.
• A command-line interface for compiling routes and running the development server.

See routes_src/hello.sql.md for an example route.

Usage

Compile routes:

python -m webbed_duck.cli compile --source routes_src --build routes_build

Run the development server (requires the compiled routes):

python -m webbed_duck.cli serve --build routes_build --config config.toml

Visit http://127.0.0.1:8000/hello?name=DuckDB to exercise the sample route. Append &format=html_c or &format=feed to see the new Beta viewers, or &format=arrow&limit=25 for Arrow RPC slices.