Because the editable text box for the query reacts to both a button press and losing focus, the query is executed even when the user clicks outside of the box, which usually means they want to cancel writing, not start the query.

Extend the top context menu with some more buttons and add individual panels for each button. Essentially, this should work similar to the way the egui demo shows the different paragraphs like demos, HTTP requests, the fractal clock etc.

Possible panels include

• Search for books on Goodreads
• Show table of books on database
• Show graphical representation of reading over time (plots etc.)
• Possibly a file picker to load books from a file (Excel, Goodreads export)

Instead of having to iterate over the whole list from the top every time, instead provide an option to skip a book. Saves a lot of time waiting on the web scraper to return the book metadata

Add an option to edit a book entry before writing it to the database.

Either add a column for all rows of the table and give each one a date picker, or upon selecting a row, open a new dialog with the date picker.

Add calls to the logger so the debugging process gets easier.

While it is now possible to select files via egui_file_dialog, this currently just prints the path. A function should be added to take the selected path, possibly verify that the path points to an Excel file, and then iterate through it and use the Goodreads API to search for every entry.

This is a larger issue that contains multiple smaller aspects:

• Add new book from Goodreads table to the database
• Modify date fields of a book (date bought, started, finished)
• Modify names and authors of books, might be necessary in case of ill-formed names
• Load data into app for visualization
• [ ]

Currently, whenever the results of a Goodreads query are available, the table has a fixed size and is only adjusted if the user does so manually. The table should be either dynamically adjusted based on the cell contents (e.g. set the column width to the width of the longest element in said column), or it should be set to a fixed, sensible default.

In addition, cover images are currently displayed in the default size, which is much too small.

Change database connection settings, then adjust values in .env file and make the repository public. Changing the parameters of the database guarantees that previous commits with potential secrets can no longer be exploited to access the database.

Start with a simple window with a text box, maybe even remove the Excel integration for now. See if there is a way of creating multiple text cells that can be edited by the user and simultaneously by the program. That way, the workflow could be as follows:

1. User enters some query
2. API looks up results on Goodreads
3. User selects one of said results
4. Selection is displayed in some sort of table
5. User can edit all fields if necessary, then confirms
6. Program writes to database

Would automatically close #2