Keith Davies · @kjdavies
78 followers · 422 posts · Server dice.camp

Whoo... this is a meaty one, capturing (at a high level) pretty much everything I know today about the media library manager. Technically I'm caught up on the A-Z Blog Challenge (no posts outstanding) but I don't have one yet for tomorrow.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
78 followers · 420 posts · Server dice.camp

What with being two days behind schedule for 'L Day', 'Little Bit Late' could've been an acceptable title also.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
77 followers · 410 posts · Server dice.camp

Expanding a little on column type definitions, tomorrow probably looking more specifically at how entities would be modeled.

kjd-imc.org/blog/keiths-custom

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
76 followers · 409 posts · Server dice.camp

There's a reason 'J' is worth 8 points in Scrabble. I ended up with something of a contrived post title for 'J' day.

Here, I take a look at the metadata options in calibre, and touch a little on how I think I might implement a similar concept in my media library (which I might expand on in tomorrow's post, if I can come up with a title starting with 'K').

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
76 followers · 407 posts · Server dice.camp

Right, I knew not all programming is the same, but I haven't had it hit this hard in a while. Time to crack some books.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #todayilearn

Last updated 2 years ago

Keith Davies · @kjdavies
76 followers · 405 posts · Server dice.camp

Wrote the post last week, forgot to click 'Schedule'. Oops.

Here I take a closer look at the data models and compare performance. TL;DR: performance difference is partly due to data model, but mostly isn't (only about 2-3 times faster with the new model, usually).

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 403 posts · Server dice.camp

I've talked a fair bit about how I'm going to capture and track information in my media library, but... what am I going to do with it? What does it look like? I start exploring those questions here.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 402 posts · Server dice.camp

Despite the media library application being 'about' cataloguing and managing media information, the design I'm leaning toward makes it easy to be very liberal regarding the definition of 'media information'.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 401 posts · Server dice.camp

Yesterday I described the data elements, today I draw a picture and test the design against anticipated use cases.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 400 posts · Server dice.camp

My background is in software development and data architecture, so for me, designing a data model is an important step in understanding the problem. If the model is hard to create, I have a problem (which might be "the request is really hard to satisfy", more often it's "there is something I don't yet understand").

So far... I think I can get this.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge #datamodeling

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 399 posts · Server dice.camp

Looking at my media library management... I've been using calibre, today's post looks at how it measures up with regard to what I want.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge

Last updated 2 years ago

Keith Davies · @kjdavies
75 followers · 398 posts · Server dice.camp

On Saturday I talked a bit about an application I'd like to have. In this post I get a little more specific about what I want.

kjd-imc.org/blog/media-library

#medialibrary #sdlc #azblogchallenge

Last updated 2 years ago