Snippet Postgres loader

[thomascollett]

Summary

Load book snippets from an external dataset into the Supabase snippets Postgres table.

Identify a good source of book snippets/quotes then build a tool which bulk-fetches snippets, filters them, and bulk-writes them into Postgres. To ensure uniqueness, we could constrain the loader to only write snippets for ISBNs which are not already in the database. In the future we may want to support multiple snippets per book.

Acceptance Criteria

• External source of snippets identified
• Tool written to load snippets into the Postgres table
• Only inserts records with unique ISBNs

[malitherl]

i found this potential API that could bulk fetch snippets from the project gutenberg https://github.com/garethbjohnson/gutendex ?