New ✨interactive✨ explainer: Address matching using a fault tolerant trie:

robinlinacre.com/fault_tolera...

Which illustrates a powerful technique for address matching that we're currently working on building into uk_address_matcher (github.com/moj-analytic...)

When working a complex postgres schema, I find it time consuming to figure out the joins.

I had an idea: a 'join generator' that traverses the relationship graph for you, and writes the joins.

You give it a dump of the postgres schema, and it gives you a UI.

www.robinlinacre.com/vite_live_pg...

We're working on a DuckDB community extension called `splink_udfs` to add some record linkage related functions to DuckDB. It's currently very much WIP, but you can already use it wherever you're using DuckDB.
github.com/moj-analytic...

The 'build' button in google AI studio is unbelievably good. I had an idea to visualise fractions, three prompts total and it's pretty close to something useful (it does this for any arbitrary fractions). Even the one-shot attempt was pretty good

I'm presenting a 30 min introduction to Splink at PyData Global
- 4th December, 16:30–17:00 (UTC), Tough act to follow though 😅 , hope I can make it worth sticking around!

Link to my talk 👇
global2024.pydata.org/cfp/talk/YXU...