MCRSF books is a listing of all the books read, upcoming, suggested and rejected at the Manchester sci-fi book club (which meets monthly online).
The list of books is kept in a spreadsheet in Google Docs, which allows everyone in the group to add suggestions and collectively decide on what to read next. However, sharing the list of books widely would mean giving edit access to the spreadsheet, which isn’t desirable.
Instead, rclone is used to automatically synchronise the Google Doc to a local spreadsheet file. This is then read into PHP using PhpSpreadsheet, and each book is converted into a row in a SQLite database. The database is uploaded to a Linux VPS where a simple PHP web application allows viewing the books by section, as well as searching and statistics (e.g. the top 5 highest scoring books).
Unlike commercial projects, the source code is available on GitHub.