A technical study on a webgl export engine

One of my favorite things about DuckDB is that it makes it extremely easy to run SQL queries on top of almost any data source. This has a ton of applications such as data analysis, data transformation, but one of my favorite ones that I rarely see mentioned is the ability to turn random data sources into structured websites.

Of course, this isn’t anything new. You could always read data from a CSV and then write code to parse, transform, and render it as a website. But the nice thing about DuckDB is that it makes the entire process a lot easier and more flexible.

So let’s give this a shot. I have found a NASA meteorite dataset that I think would make for a fun website. You can download it here.

const a = 1;
const b = 2;
const c = 3;
// ... more code
const highlightedWord = 'highlight-this-word';

Now that we have our database, we can load the data. You can both pass a path to or a URL to DuckDB and it will know how to load it. To be respectful of their API, I will download the data into my data directory and then load it from there.