If I use Prisma, can I add a field that query data from a redis db? Also what about implementing my own caching layer on top of psql? Is this possible?

Yeah, you can absolutely do that. You have to define a sub-resolver in your application schema and there you could fetch the data from a different data source. Please note that you have to write the particular fetch mechanism yourself then.

Ok

Let me know, if you have any further questions. I’m happy to help 🙂

So calling external apis would be also possible right?

Yes, calling external APIs is possible. You can communicate with any external system you want.

Yup. For example if I need to get a list of messages, if it's already in redis, then fetch it. Otherwise query it from psql db

Not at the moment, no.

Prisma

has an internal caching mechanism built-in though. It is memory only and not based on an external system,

Internal caching layer? Wow

There are plans for having a Redis connector: You can track the progress here: https://github.com/graphcool/prisma/issues/1722

So how does it work? Inbuilt memory?

Yes, it utilizes Facebooks

dataloader

, you can find the Graphcool library here: https://github.com/graphcool/http-link-dataloader

Hmm. Let me go through it

👍

My application is pretty big, not just a curd. Currently it's built with Apollo graphql. Would like to migrate to Prisma. Have to make sure Prisma is customizable for my needs

You could definitely write your own caching mechanism which wraps the

context.db

calls and goes to the Prisma service. That is the approach I would suggest: Write an own layer that uses

conext.db

and your

Redis caching implementation

and utilize that in your resolver functions.

Great!