I just want to point out that the is_obsolete column in the library table is, for some reason, an integer instead of a boolean.
Is there a historical reason for this? Because it makes for a harder-to-implement field where the user needs to enter a number instead of use a checkbox.
Table "teapot.library"
Column | Type | Collation | Nullable | Default
------------------+-----------------------------+-----------+----------+----------------------------------------------------
is_obsolete | integer | | not null | 0