TrickJarrett.com

Semper Ad Meliora

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 | Share to:

May 18th, 2024

Automated Archives for May, 18th 2024

This post was automatically generated

Chess For the Day

Record: 4-0-2
Net Elo Change: +12

Games Played

Blog Posts On This Day

5/18/2024 11:45 pm | Tags: automated, chess | Share to:

Sometimes your body wakes you up in the middle of the night, and when you can't fall back asleep you finally pick up a coding project you've been thinking about for way too long.

5/18/2024 8:45 am | Tags: programming | Share to:

May 17th, 2024

Automated Archives for May, 17th 2024

This post was automatically generated

Chess For the Day

Record: 3-0-4
Net Elo Change: -7

Games Played

Blog Posts On This Day

5/17/2024 11:45 pm | Tags: automated, chess | Share to:

May 16th, 2024

Automated Archives for May, 16th 2024

This post was automatically generated

Chess For the Day

Record: 0-0-5
Net Elo Change: -27

Games Played

Blog Posts On This Day

5/16/2024 11:45 pm | Tags: automated, chess | Share to:

May 15th, 2024

Automated Archives for May, 15th 2024

This post was automatically generated

Chess For the Day

Record: 6-0-4
Net Elo Change: +19

Games Played

Blog Posts On This Day

5/15/2024 11:45 pm | Tags: automated, chess | Share to:

May 14th, 2024

Automated Archives for May, 14th 2024

This post was automatically generated

Chess For the Day

Record: 2-0-2
Net Elo Change: +1

Games Played

Blog Posts On This Day

5/14/2024 11:45 pm | Tags: automated, chess | Share to:

May 13th, 2024

Automated Archives for May, 13th 2024

This post was automatically generated

Chess For the Day

Record: 7-0-8
Net Elo Change: -8

Games Played

Blog Posts On This Day

5/13/2024 11:45 pm | Tags: automated, chess | Share to:

May 12th, 2024

Automated Archives for May, 12th 2024

This post was automatically generated

Chess For the Day

Record: 4-2-2
Net Elo Change: +13

Games Played

Blog Posts On This Day

5/12/2024 11:45 pm | Tags: automated, chess | Share to:

May 11th, 2024

Automated Archives for May, 11th 2024

This post was automatically generated

Chess For the Day

Record: 6-0-3
Net Elo Change: +27

Games Played

Blog Posts On This Day

5/11/2024 11:45 pm | Tags: automated, chess | Share to:

"Three Whole Onions with Secretary Pete Buttigieg"

5/11/2024 12:07 am | Tags: youtube, hank green, pete buttigieg | Share to:

May 10th, 2024

NOAA Space Weather Prediction Center issued a Severe (G4) Geomagnetic Storm Watch

Listened to Carl Sagan's "Pale blue dot" while looking up at the night sky. The colors weren't as vivid as the photo shows, but it was still a magical moment to know we were seeing a special life event.

Another excellent segment from Sagan, titled 'Humility'

5/10/2024 11:47 pm | Tags: science, space, astronomy, northern lights | Share to:

Automated Archives for May, 10th 2024

This post was automatically generated

Chess For the Day

Record: 7-0-7
Net Elo Change: -4

Games Played

Blog Posts On This Day

5/10/2024 11:45 pm | Tags: automated, chess | Share to:

May 9th, 2024

Automated Archives for May, 9th 2024

This post was automatically generated

Chess For the Day

Record: 0-0-1
Net Elo Change: -6

Games Played

Blog Posts On This Day

5/9/2024 11:45 pm | Tags: automated, chess | Share to:

May 8th, 2024

Automated Archives for May, 8th 2024

This post was automatically generated

Chess For the Day

Record: 3-1-2
Net Elo Change: +7

Games Played

Blog Posts On This Day

5/8/2024 11:45 pm | Tags: automated, chess | Share to:

May 7th, 2024

Automated Archives for May, 7th 2024

This post was automatically generated

Chess For the Day

Record: 0-0-4
Net Elo Change: +1

Games Played

Blog Posts On This Day

5/7/2024 11:45 pm | Tags: automated, chess | Share to:

May 6th, 2024

Automated Archives for May, 6th 2024

This post was automatically generated

Chess For the Day

Record: 10-2-12
Net Elo Change: -16

Games Played

5/6/2024 11:45 pm | Tags: automated, chess | Share to:

May 5th, 2024

Automated Archives for May, 5th 2024

This post was automatically generated

Wallabag Additions

These are articles that which I saved today so that I may read them later. Substance and quality will vary drastically.

Chess For the Day

Record: 0-0-6
Net Elo Change: -27

Games Played

Blog Posts On This Day

5/5/2024 11:45 pm | Tags: automated, longreads, chess | Share to:

May 4th, 2024

Automated Archives for May, 4th 2024

This post was automatically generated

Chess For the Day

Record: 5-0-0
Net Elo Change: +29

Games Played

Blog Posts On This Day

5/4/2024 11:45 pm | Tags: automated, chess | Share to:

May 3rd, 2024

Automated Archives for May, 3rd 2024

This post was automatically generated

Chess For the Day

Record: 6-2-6
Net Elo Change: -1

Games Played

Blog Posts On This Day

5/3/2024 11:45 pm | Tags: automated, chess | Share to: