I use roapi to power my “book list” on my static site. I have it running on an always-on Replit repl. Try it here:

https://charlieharrington.com/library/

Click the “I’m feeling lazy” button if you just want to see some example queries.

I also wrote a tutorial, as well, if you’d like to try out roapi yourself:

https://charlieharrington.com/sql-powered-reading-list/