Media Library: Just What Metadata Is There?

In looking at the data models, I’ve focused mostly on ‘user-defined columns’ in the expectation that I’d use the same mechanism for ‘built-in columns’. Which raises the possibility of someone taking the library and bending it in strange ways, doing things I had no reason to think they would. If …

Media Library: Having a Closer Look

‘Test your assumptions’ is an important step in any kind of analysis and design exercise. It appears calibre’s database design is not entirely the cause of poor performance at higher record volumes. Don’t get me wrong, the design and implementation of the database can certainly be tightened up… but I …

Media Library: ER Diagram and Evaluation

Yesterday I explored some data objects I expect to need in my media library. That’s a good start, but a relational database is not particularly useful until it has relationships. Thus, I’ll want an Entity Relationship (ER) Diagram showing how the different pieces are related. In this post I’ll also …

Back to Top