Get URL Schemes For Your Apple Books on MacOS

get-books.sh

#!/bin/bash

# Path to the BKLibrary file
BKLIBRARY_PATH=~/Library/Containers/com.apple.iBooksX/Data/Documents/BKLibrary

# Check if BKLibrary file exists
if [ ! -f "$BKLIBRARY_PATH/BKLibrary-"*".sqlite" ]; then
    echo "BKLibrary file not found. Please make sure Books app is installed and has been opened at least once."
    exit 1
fi

# Get the full path of the BKLibrary file
BKLIBRARY_FILE=$(ls "$BKLIBRARY_PATH"/BKLibrary-*.sqlite)

# Execute sqlite command to fetch book titles and asset IDs
sqlite3 "$BKLIBRARY_FILE" <<EOF
select ztitle, 'ibooks://assetid/' || zassetid from zbklibraryasset;
EOF

TODO: Use SimonwW's datasette plugins to do something useful with the sqlite DB