DEVOURED
A live data app for $0: DuckDB, Astro, and no BI tool
This article details building a $0, fully interactive data app for finding tropical fruit in Hawaii using DuckDB, Astro, Leaflet, and GitHub Actions, bypassing traditional BI tools.
What: Josh built a data app with zero infrastructure cost, pulling 13,000 observations from the iNaturalist API, transforming them with DuckDB into a single data.json file, serving it with Astro and Leaflet, and refreshing weekly via GitHub Actions cron jobs.
Why it matters: It demonstrates a viable, cost-effective alternative to commercial BI tools like Tableau, Omni, or Hex for bespoke, on-brand data products, especially when robust governance or heavy analytics are not the primary need. It also highlights the growing power of AI-assisted coding for custom UI.
Takeaway: Consider using DuckDB and static site generators like Astro with GitHub Actions for interactive, custom data apps if you prioritize low cost, full design control, and don't need extensive BI features.
Deep dive
- The app tracks seasonality and island density for 10 tropical fruits using 13,000 iNaturalist observations.
- The stack includes iNaturalist API (data), DuckDB (transform), Astro/Leaflet/SVG (serve), GitHub Actions (refresh), and existing static hosting.
- DuckDB, an in-process SQL engine like SQLite for analytics, directly reads CSVs, eliminating a load step, server, or warehouse.
- The app generates a single data.json file after DuckDB processing, finishing in under a second.
- Cost is $0 because data is open, engine embedded, cron included in free tier, and hosting is on an existing site.
- Custom data visualization uses CSS variables for themes, allowing the entire app to restyle with a single toggle.
- The entire interface was specified in natural language and coded by Claude Code, demonstrating AI's role in custom UI generation.
- Compares open-source approach to Omni (governance), Hex (notebook-style apps), and Tableau (drag-to-explore).
- Open source offers seamless integration with existing site design, unlike BI tools that embed their own chrome.
Decoder
- DuckDB: An in-process SQL OLAP database system designed for analytical queries on structured data, often used for local data transformations.
- Astro: A web framework for building fast, content-focused websites, popular for static site generation.
- Leaflet: An open-source JavaScript library for mobile-friendly interactive maps.
- iNaturalist API: A public API providing access to biodiversity observations recorded by citizens and scientists.
- Claude Code: An AI code generation tool, likely referring to Anthropic's Claude model being used for code.
Original article
Full article content is not available for inline reading.
Explore all 68 articles in today's digest
Fresh dev news, AI-digested daily. Never miss a trend at devoured.fyi