hello, i'm looking for tutorial how to use multipl...
# orm-help
d
hello, i'm looking for tutorial how to use multiple database in one prisma?
d
Hmm, curious why you would try to do this? Why not setup multiple instances of Prisma and handle sending data to each instance through your GraphQL server?
d
i new on prisma, so i think it can be join data from another database on one prisma instance. like, i can get from structural DB and unstructural DB
a
www.howtographql.com might have some answers 🙂
d
wow, thanks.
d
Interesting, I don’t think Prisma will join multiple databases into one Prisma instance. However, I’m curious to hear what you find out!
n
Prisma currently doesn't support multiple database behind the same GraphQL API - but this is a super exciting research topic for us, and we've already started to investigate into that direction. Here is a relevant discussion/feature request: https://github.com/prismagraphql/prisma/issues/2873
@dex, for now you can connect one Prisma instance to one DB and join them at the application layer.
d
now, i have multi instance prisma, and join on application layer, but my project is logging data from multi database. i know this is wrong architecture 😣(my application architecture). but prisma solve my complex data structure. so i think how to connect database on one prisma instance.
n
Got it - it would be awesome if you share a description about your current approach, its shortcomings and how you envision this to work in the future in the feature request I shared above 🙂 this will allow us to take your situation into account once we start building multi-db support
d
i have hundreds cargo ship. and many warehouse. for this case. - tracking of cargo ship times and coordinates, history and at least 4 days destination - tracking items out from cargo and store to warehouse (what item, who is the carrier, etc) - join their item with client order. so i think on these case, i try to join prisma on multi DB, for get data on structural DB and unstructural DB. from structural i get user info from unstructural i get item logging information