Re: [libreoffice-users] Re: Currently Using Spreadsheet for Personal Project - Thinking About Database

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