I use MusicBrainz dataset a lot across projects, so decided to distill their JSON dumps into a DuckDB database.

It’s a huge, and nested, dataset - but you can run trivial queries easily enough, directly against the object store:

INSTALL httpfs;
LOAD httpfs;

ATTACH 'https://musicbrainz-duckdb-store.lon1.digitaloceanspaces.com/musicbrainz.duckdb' AS mb (READ_ONLY);

SELECT
    date AS release_date,
    title AS release_title,
    barcode AS release_barcode,
    "artist-credit"[1].name AS primary_artist,
    status,
    country
FROM
    mb.release
WHERE
    "artist-credit"[1].name ILIKE 'Linkin Park'
ORDER BY
    date ASC;

For more complex use cases, you’ll want to pull it down and build out some custom tables locally - like if you’re working with tracks, because they’re nested under releases. This nicely gets me around rate limits on the hosted API, and saves me having to run an MB server too.

I’m opening this up as fully free/OSS as is permissable - but you should also consider the MusicBrainz data license if you use it.

Well, that was that. We kicked off Macc.xyz with a social last night. 120+ people turned up! Guess it’s a thing now.

I used to run a meetup in my local town, Macclesfield. I let it slide when I got overloaded with my former startup, and became much more London and Manchester centric. I miss having a community of like minded folks on my doorstep, so I’m starting one up again: Macc XYZ.

I think I did quite well getting that domain name. I really didn’t want to endure Meetup’s hostile lock in, so I spun up a Rails API to store the members, and built the frontend in Astro. I’m using Luma to run the RSVP/comms - and it’s a joy! The most modern event platform I’ve seen to date.

For anyone and everyone around Macclesfield, and with an interest in tech, I would love to see you at our Launch Social.

Well October was quite an eventful month - I turned 36, and got married.

I came across the “target panic” phenomenon listening to a podcast this week. It’s a condition archers suffer, where the fear of missing the target prevents them from releasing a shot. I think I’ve suffered similar with startups - not wanting to work on the wrong thing. Imagine many others have too.

I picked up Golang last year - I shipped an “embedded” app across a few hundred kiosks at DFW airport, and Go’s ability to compile down to a single exe across platforms was a big enabler. But with the 1.2 release of Bun, I’d probably use that instead. Bun’s got the same compilation capability now, comparable performance and is rapidly providing a rich standard library. I also find Typescript more enjoyable than Go (just personal preference). Makes me wonder what the future looks like for Go.

I, somehow, came into possession of an M2 Macbook Pro that only has 8GB of RAM. The low memory makes using OS X thoroughly unenjoyable, so I decided to take a shot at running Fedora via Asahi Linux on it.

It’s actually great; quite consistent with Ubuntu running on my main rig, and so snappy it’s become my primary laptop. I recommend anyone with an aging Apple Silicon laptop try it out. The only frustration I’ve had is that the battery consumption when it’s suspended is bizarrely high.

Giving the blogging thing another go. Super simple stack - but hopefully that means I’ll keep it updated:

• Astro for dev/build
• MDX for content
• Swup for client side page transitions
• Tailwind for styling (with @tailwdindcss/typography)
• Space Grotesk for display, Poppins for body
• Deployed to Vercel
• As always, photo of me by Rachel Carney

I’ll definitely refine the design over time, but let’s see how well I do at keeping this thing up-to-date for now…