Day 4: Database connection & BFS research
First, I installed Prisma, introspected the database, and generated a client. I've worked with Prisma before (it's a great ORM), and it gives the ability to swap to a different database source in the future without too much difficulty (in case sqlite doesn't cut it).
Next, I need to implement a Breadth-first search algorithm to identify pathways through the database. The sdow project has an implementation in Python, but I'm using JS (and Prisma), so I need to build a new algorithm from scratch.