com_xbbooks v0.6.1 (beta1) 
16th November 2020  

xbBooks is a component for cataloguing books you have read and reviews of them. Version 0.6.0 is the first public beta release, it should really not be used on production sites (although I am ;-) ). There are definitely bugs and missing functions - although I've not found anything fatal yet.

It started out as I needed something to replace a flat-file database I had been using to save details of books I read and short reviews/comments. Previous to that I had been using a simple spreadsheet and originally an paper file.

Documentation  Demo Page

 xbBooks provides views into a relational database of books, people, characters and reviews.

People may be authors, editors, real people mentioned or fictional characters in a book. One person may have several roles in different books. A distinction is made between real people and fictional characters.

Books may have more than one author, several characters and mention several people you want to track. So books and people is a many-to-many relationship

A review is of a single book, but a book may have several reviews: a one-to-many relationship. A book may be reviewed by more than one user, or you can simply link to external reviews for alternative comments.

The people and characters tables are be shared with the xbFilms component (in development) and possibly other related future components. A film director may also write a book and appear in films as an actor and be the subject of a biography. 

In general xbBooks allows the user to define categories and tags to suit your particular preferences. For example you might consider genres to be mutually exclusive and so use them as categories (an item can only belong to one category), or you might think that a book can be both a historical fiction and a crime novel - the genres are not mutually exclusive so you would use tags to identify them. 

Categories, on the other hand, are exclusive - an item can only belong to one category. So you would use categories for a set of non-overlapping attributes. For example the standard library Dewey Decimal system assigns every book to a single subject number, so you could use Dewey numbers as categories for books. For people you could use nationality as category names - although there is a separate dedicated field for this.

There are two system generated categories:  "Uncategorised" and "Imported". Uncategorised is used by default for all items that you don't assign to another category, and Imported is the default for items you import from CSV or SQL files - although you can override this during the import.

In addition all books are flagged as either fiction or non-fiction, and dedicated fields are provided for publisher, year of publication and other attributes.

People have fields for nationality and year of birth and death, as well as name and biography. Reviews can have a reviewer name, date, format of the book reviewed. The full list of fields available for each item time is given in the Documentation.

Reviews have a star rating for the book. I find a 1 to 5 star scale inadequately fine grained (you often end up wanting to give half-stars). I have been using a 10 star scale for many years, but looking at the results I see the majority of books fall between 6 and 9 stars. Possibly this is because I don't tend to read things that I don't think I'll like, but I also find that 10 points seems too many. So for xbBooks I have switched to a 7 point scale, this may become an option in a future version. In addition to 1 to 7 stars, I have added the ability to grant no stars for things that are so bad that I don't even finish them. This is an optional setting.

For further information see the xbBooks Documentation page



Improvements and bug fixes

  1. v0.7 - add Help system to admin side (beta2)
  2. v0.8 - additional menu options for simpler listings on front-end (RC1)
  3. v0.9 - finalise language strings and error trapping
  4. v1.0 - Release version
  5. v2.0 - Joomla 4 version

Possible New features

  1. ability to specify rating scale
  2. front-end editing and creation of reviews
  3. add field for historical period for fiction books
  4. import and export to JSON and/or XML



v0.6.0 10th November 2020 BETA1
    separate table for characters
v0.5.8 7th November 2020 ALPHA5
    site tags views working
    export CSV working, import csv improved
    removed real/fictional flag on persons table pending new characters table
    many minor tweaks to all views (site & admin)
0.5.6 and 0.5.7 bug fixes
v0.5.5 25th October 2020 ALPHA4
    removed requirement for either summary or details to be set for books, people and reviews
    added new book field 'cat_date' for the date that the book was acquired or read
    refactored field name 'date_read' to 'rev_date' for the bookreviews table
0.5.4 24th October 2020 ALPHA3
    Import CSV, improvments to SQL Import and Site List views 
v0.5.2 and 0.5.3 bug fixes
v0.5.1 14th October 2020