Guys at my work we have a php lumen REST API. It u...
# orm-helpa
Alex Freire Spinola
02/13/2019, 12:42 AMGuys at my work we have a php lumen REST API. It uses two databases MySQL and Mongo it is possible to use Prisma to interface with 2 databases?
Alex Freire Spinola
02/13/2019, 12:47 AMI am planning to rewrite this API using graphql as a first usage of graphql at my job
Alex Freire Spinola
02/13/2019, 12:47 AMDo you guys have any tips to start?
j
jangerhofer
02/13/2019, 5:20 AMTo my understanding, it is possible to create a Prisma schema which spans multiple databases however that particular feature is in closed beta (or will soon be). The feature is spec'ed out to be included in what has been dubbed
Datamodel v2jangerhofer
02/13/2019, 5:23 AMIf you want to stick to the beaten path, you might consider simply setting up two separate Prisma services, one per database. The main drawback to this approach is that you cannot host the two services on the same Prisma Server instance, as each Prisma Server (in its stable iteration -- dunno' what the Datamodel v2 changes look like!) allows for only a single database. So, you would need two instances of Prisma Server.
jangerhofer
02/13/2019, 5:25 AMIf you have the two instances set up, you can provide a single "public" schema which unifies the two "private" Prisma servers. The trick from there would simply be writing resolvers which make requests using two different Prisma Clients (see my answer to @Benoit Ranque just below this thread for more detail on configuring the two Clients) and properly combine the two databases' contents.
9 Views