New Database Server and Coffee Bag Archiving

If you didn’t see it on the status page then you know from the title - Visualizer is now on Postgres 18. It’s very unlikely you were affected by the two downtimes of ~3 and ~2 mins respectfully. If you were, I’m very sorry! 🙏

That said, I’m incredibly happy with how smoothly the upgrade went. It could have been even smoother, but I decided to bump the db server up a notch, so now it’s even beefier and has plenty of room to grow for all our future shots. Currently there are almost 3.5 million shots and all together the database is ~40GB in size. Any DB level actions are always super stressful to me. But this one went really well! 🥳

It was an all morning affair with many moving parts, and I’ll probably write a technical blog post on how I did it. Let me know if you’d be interested!

I also shipped a small but surprisingly satisfying quality-of-life change in Coffee Management: you can now archive coffee bags. They’ll move to the bottom of the list, be grayed out, and no longer appear in the list when you’re editing your shots. This all syncs to Airtable, so your lists stay tidy in both places.

Every bag now also has a Place of purchase field. It’s completely free form, so you can input a store address, a website, or anything else you might want.

As always, there were tons of smaller changes since the last update and if you’re curious, feel free to explore the diff.

With that, have a lovely weekend and enjoy some great coffee! ☕


Loffee Labs meets Coffee Management

Ever since I introduced Loffee Labs Integration I’ve been thinking about how to introduce it to Coffee Management users as well. And today I’m happy to say it finally shipped!

This is what a linked roaster looks like (notice the shield check):

Coffee Management

When you edit a Coffee Bag on a linked roaster, you’ll see a familiar dropdown with all coffees from the Loffee Labs Bean Base. Once you select one, Visualizer fills in the fields just like Visualizer AI.

Coffee Management

As Coffee Management is available only to Premium users, this feature is, too. Feel free to try it out with a free trial.

As always, there were many updates and bug fixes since the last update. Most notably, we’re now running Rails 8.1 beta 1, announced at the latest edition of Rails World, where I also gave a lightning talk about Visualizer. It was an absolute blast to share the journey and success of this project from the most humblest beginnings.

Enjoy your weekend! ☕


Copy From Any Shot

Not much has changed since the last update—mostly small bug fixes and dependency updates. Oh, and I switched AI coffee bag extraction from Claude 3.5 Haiku to OpenAI GPT-5 Nano. It’s better, faster, and cheaper. Hitting the trifecta is rare. 😅

There is one new feature, though: you can now copy data from any shot. Inspired by a GitHub issue and the existing comparison UI (where you get a drop-down of recent shots and an input for any shot), there’s now a similar UI when editing a shot. Just pick from recent shots or paste the URL of any shot, and I’ll pull out the relevant info for you. How cool is that? 🤯

Enjoy your weekend! ☕