Pub/Sub suport for Pocketbase

[eugeis]

trafficstars

Feature Request

It would be great to have support for using [PocketBase](https://pocketbase.io/) as a Pub/Sub source for [Watermill](https://github.com/ThreeDotsLabs/watermill). I am using Pocketbase and would like to use Watermill to implement CQRS pattern, https://watermill.io/docs/cqrs/.

PocketBase provides built-in support for collection model operations ([see docs](https://pocketbase.io/docs/go-collections/)) and real-time event hooks for Create, Update, and Delete actions via Go-based hooks ([event hooks documentation](https://pocketbase.io/docs/go-event-hooks/#collection-model-hooks)).

I’m interested in contributing this integration, but I’d appreciate some guidance on the recommended approach to implementing the support for Pocketbase in order to use it for CQRS. Any advice on design patterns, best practices, or existing extension points in Watermill that could simplify this effort would be very helpful.

Thank you!