TrickJarrett.com

Sunday, May 19th, 2024

« Previous Day Next Day »

Working on 'Wyrmling'

Spent several hours so far this weekend getting my custom collection management project. My goal is for it to be an open source self-hosted solution others can use. It's meant to be flexible to use for any set of collections. For example, Katie and I will be able to use it for my Magic cards, her PEZ, my D&D books, our vinyl albums, etc.

You may recall I shared a database diagram a few years ago. The database structure has remained largely the same with some changes since then. The core concept remains the same: there are collections and there are libraries. Collections are what you personally possess. Libraries are the type of collection and its things.

For example, a library would be 'Magic: The Gathering' cards. Pulling that data in from an outside source to include every Magic card. The collection would track which cards I personally own. You don't have to have/use a library for your collection, you can just enter your own title and description, but the library makes things simpler.

A lot of the work has been fleshing out the collection and library database tables. Things like adding fields and foreign key relations, etc. I just added a table for tracking changes to collections, so you can see adding things, removing things, etc.

I'm getting close to being ready to begin building the UI in earnest. That's going to be the brunt of this work.

5/19/2024 8:13 am | | Tags: collecting, programming, project

Much love to Jurgen Klopp. I wish him all the best in his next adventure. I'll watch wherever he lands. I followed him from Dortmund to Liverpool and I'll follow him on.

5/19/2024 10:46 am | | Tags: soccer, football, jurgen klopp, liverpool, premier league

Automated Archives for May, 19th 2024

This post was automatically generated

Chess For the Day

Record: 3-0-6
Net Elo Change: -17

Games Played

Blog Posts On This Day

5/19/2024 11:45 pm | | Tags: automated, chess
« Previous Day Next Day »