I’m in the process of consolidating all my work scattered across the WWW to www.ronaldbradford.com
As part of the process I was originally redirecting this to my present blog but I was not doing it the correct way. You should Use standard redirects: don’t break the back button! from W3C.
For now, I’ve reverted to a splash page and physical links until I can complete the new site.
In Curated MySQL Data Sets for Realistic Testing I described datasets assembled the manual way — download, schema, load, validate, document — over hours or days per source. This post is the follow-up I promised: what changes when AI assists the same workflow, using DuckDB as the target engine and GeoNames as the first example.
Read moreLet’s say you’re building a reference table from source data, e.g. a silver medallion table from a primary source. In this example I am using a file of random locations on the globe extracted from OpenStreetMap (OSM) as my primary source.
Read moreClean data is one of those terms everyone uses and few define precisely. Row counts match? No nulls in key columns? Values within expected ranges? All useful checks — and all insufficient once you move from a table view to a visualization view.
Read more
