Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi Again - and thanks!




Well, you have a few choices:

a) you could have one table for books read and one for the books still
to read, and when you've read a book you have the database transfer the
record from the one table to the other.

b) you could have a table for all books, and a flag in the table to
show when it's read

c) you could have a table for all books, and another table with your
rating and such details that gets a record added when you've read the
book


So my thought was to have three tables -
*Table - BooksRead*
Author
Book
SeriesName (can allow Null because most books are not in a series)
Pages

*Table - Series*
SeriesName (not unique per row)
BookName (This + SeriesName would be unique)
Read (binary true/false auto set dependeing on if the book is in BooksRead
or not)

*Table - Rating*
Each category (ie, story, ending, character development, etc...)
Overall - auto calculated based on combo of other values
(here I'd love to have some kind of graphical representation of my ratings,
like stars, incremented by half star, 1-5 star total)

*So then what would be left is:*
Figuring out how to summarize my data like I do in the spreadsheet (pages
read per year, pages remaining, pages read per month, etc....)

Figuring out how to get some printout of "next book in series" - I suspect
some kind of query would work that checks in "Series" table and finds the
"next" book in a given series that does not have a true value in "Read"
field. In spreadsheet I was going to use match/index to accomplish this.

Other cool things like summarizing my opinions of particular authors, a
list of "want to read" books independent of the series. Possibly add genre
somewhere and a randomized "suggest a book" thing.

At some point I'd love to figure out how to pull series data from some
source so I don't have to manually add books that are in a series. Some
series have 50+ books, entering them all manually might be brutal ;)

Sound feasible?

Best,
Joel









-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero.dev@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.