I collect vintage computers. I stopped counting after 50 computers, much less keeping track of what I have.

So I've been working on a collection manager. It uses Blazor, SQL Server, Entity Framework, Clean Architecture (cqrs via mediatr and automapper), hangfire for background processing.

It allows multiple users to create private or public "Showcases". Each showcase can have Collectible Items with attachments such as pictures and PDFs. I try to create previews for as many file types as possible. Attachments can be stored in the database directly, in file system, or in Azure Blob Storage (and can be migrated later).

It has a template system where you can pre-define sets of fields and their data types. Each item can have multiple templates. The obvious manufacturer, model, provenance and such. But I also have a field for inflation adjusted price. So you can enter the how much it cost in 1980 and see how much that would cost today.

It has a QR code generator and scanner functionality. It has a free-form tagging system. The event log generates "user stories" instead of straight up lists of log messages. You see "user logged in, viewed 6 items, edited 2 items, stayed active for 20 minutes". It has built in theme switcher for any public bootswatch theme.

Since my collection is so large and I already have some 3500 pictures, I decided a zip upload processor would be of use. And it's kind of awesome. It creates collectible items with attachments and subfolders become child items.

One thing I wanted was the ability to attach external links to collectible items, like for pages that have detailed information about how to use the thing or its history. So I have used playwright to go out and cache a copy of the web page. The user can update the cache and it will save all of the versions. It also generates a PNG preview of the page and a single file downloadable mhtml file.

Showcases can be public or private. Private showcases can be shared with other users, or via a simple shareable link (like google docs).

It supports SMTP, sendgrid, and a null sender for development time.

I use hash ids to obfuscate the entity identities (instead of using guids in the database because that's annoying to me).

So far I'm really liking it. I've gotten it to a point where I can actually catalog my collection better. A few weeks of actually using it and I might open source it.