Hi! Can somebody please point me in the right dire...
# orm-help
m
Hi! Can somebody please point me in the right direction? I am fairly new to GraphQL/Prisma and I have question on my mind that I could not resolve for myself 🤔😬 I have client that has been asking us to create a sort of middle ware to to abstract away his legacy systems. He wants to give his Franchisees a nice API to connect to to get their data. In this middleware we have to export large sets of data (like a product catalog) from one backend system to the next. Does it make sense to create a Prisma/GraphQL middleware fore this? I just need a hint where I can go look for answers 🙏 Thank you so much
j
Hello! From your description, it sounds to me like you're aiming to set up a new datastore (i.e. likely a brand new database) to house existing data. If that is the case, then Prisma is a perfectly good choice to use as the "pipe" in a one-time transfer and then as a object-relational mapping for further access via the API you described.
If, instead, you're looking to create a reusable "pipe" that presents existing information in existing datastores in a nicer way to said franchisees, then it gets a little more hairy! Specifically, while it is entirely feasible -- even easy -- to set up Prisma with a preexisting MySQL, Postgres, or Mongo instance, you are constrained to those stores today. GraphQL, as a separate stack from Prisma, might solve the challenge elegantly even if you can't fit Prisma itself in.