|
[QUOTE=kovidgoyal@HarryT
I use an sqlite database. What metadata do you maintain in your database?[/QUOTE]
Basically for each book I store:
- Author(s)
- Title
- Category(s)
- Series
- Series Position
- Format (s)
- Source
- Comments
It's a bit more complicated that that in that, for example, I have a "Book" table, an "Author" table, and a "Book/Author" link table; this lets me have a "many to many" relationship between books and authors. Similarly with category and format.
|