We sometimes forget the impact of early mathematicians. Take for example John Venn who introduced the Venn diagram in 1881.
This is fundamental for Set Theory, and also fundamental for SQL, the basis of retrieving data in a RDBMS.
Related Posts
Fixing Old Software Bugs Without Thinking
I previously came across an issue in my benchmarking work where I relied on the Latency Histogram section of sysbench output. On Linux it worked fine — I generally ran my workload there, so it never mattered.
Read more
Curating DuckDB Datasets Leveraging AI
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 more
Why INSERT IGNORE should not be used
Let’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 more