The decreased cost of prototyping is one of my favorite things about "vibe coding."
Last semester I wanted to teach my students SQL.
Years ago I used CartoDB for this. I wanted the same experience: load a dataset, run a query, see the result live on a map.
Replicating this is do-able with today's tech: @duckdb WASM in the browser connected to @maplibre.
Before LLMs, this would take me weeks to build myself - which isn't worth the time investment.
With LLMs? This app took me a day and I was able to host it self-contained on my website and hand off to students.
See the example: loading 39k Utah oil and gas wells in the browser, querying for an operator and Federal surface ownership.
Even includes nice touches like click a row in the table, highlight the circle on the map.
This isn't a sellable product like CartoDB was, you still can't build that in a day.
But the fact that we can put this sort of thing together nowadays opens up so many new pathways for teaching, sharing information, and sketching out project ideas.
You can try out the tool yourselves at personal.tcu.edu/kylewalker/…
Video