Includes in Prisma Pulse or Stream a db Views
idk if that sounds dumb or not but can i for example include a foreign table when a new event comes in from a pulse trigger (update/create) ?
or if i create a view can i stream that directly when ever a new record got added?
6 Replies
You selected the carefully hand-crafted route. A dev artisan will respond soon. Meanwhile, the
#ask-ai channel awaits if you're curious!Can you please elaborate on your use case?
Currently, Prisma Pulse does not work with Views.
Pulse is dependent on Replication logs to stream the events. However, views aren’t represented in the replication log. Instead they are generated on each replica instance.
ah if that so, i don't think my case would work without executing an extra query
ok no worries.
on a side note at some instance Prisma Pulse decided to stop sending events and i couldn't troubleshoot or do anything until i had to recreate a new prisma project at the console/dashboard
i think it happend when i had to switch from beta to GA
Ah, thanks for reporting. Did you get any errors when Pulse stopped working?
Do you still have the project running?
the project should still exist, i haven't removed it but i'm no longer using it
i didn't get any errors, i just didn't receive any kind of events
That's indeed strange. Can you please let us know in case you observe the same behaviour again?