do prisma support real time sync?

Are you referring to a feature of typeorm?

no really

Socket.io can send real time notifications, but none of the backend databases that tie into Prisma are really ideal for sending real time notifications. Better to use a message queue that watches for the real-time events of the type you need, and then every Socket.io listener can watch that queue for appropriate events filtered by what that client wants to hear. Or depending on the nature of the updates (and the message queue you use) you could send each update category to a different queue channel. There do exist databases that specialize in change notifications (for example RethinkDB), but the only database Prisma supports that has any kind of change notifications (that I can find in a quick search) is SQLite, and that's if you're embedding it. tl;dr: It's not something that Prisma is really built to help you with, though it's not a missing Prisma feature as much as a feature that doesn't really belong in Prisma.

Did you look into GraphQL subscriptions? I'm using GraphQL & Apollo Server for the first time and am planning on using subscriptions to implement a chat feature similar to Slack. Not sure if it could work for your use case. Doesn't have anything to do with Prisma.

Prisma doesn’t support real-time sync, but you can use Sockets or if you’re using GraphQL go for subscriptions as mentioned above.

Pusher.com is also an easy way to get started doing real-time stuff but it can get expensive.