Seeking Advice on Building an Integration Testing System with Effect and Prisma
I'm trying to build an integration testing system with Effect and prisma here's a demo repository
My thinking is that it would be a good use case for effect's structured concurrency. Originally I kind of made it work (at least the migration part), by having Effect run a semaphore where I can only have so many instances of dbs, and each test runs on a new sqlite file. But I feel like it would be much faster if I could reuse 20 or so sqlite files and have a queue of them run in parallel (or something along those lines).
I would love to grok this with someone more experienced, I don't have much experience with structured concurrency in general. The limit for my normal self is just using the heck out of promises.
My thinking is that it would be a good use case for effect's structured concurrency. Originally I kind of made it work (at least the migration part), by having Effect run a semaphore where I can only have so many instances of dbs, and each test runs on a new sqlite file. But I feel like it would be much faster if I could reuse 20 or so sqlite files and have a queue of them run in parallel (or something along those lines).
I would love to grok this with someone more experienced, I don't have much experience with structured concurrency in general. The limit for my normal self is just using the heck out of promises.
