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! ☕