Books Catalog

Get book categories from BookShop.org

docker container run --rm -v ${PWD}/backend:/books_app \
                     --network mybooklibrary_default \
                     --env-file .env \
                     -it python:3.12-bookworm bash -c \
                        "apt update && \
                         apt install -y postgresql && \
                         cd /books_app && \
                         pip install -qU pip fastapi uvicorn[standard] sqlalchemy psycopg2 && \
                         bash"

SELECT id,title,author,category,substring(cover_art,1,40)||'...' FROM books;