Custom scan of all streams, mt_streams and seq_id

[Mastahh]

Hello,

We are using Marten in one of our new project.
And we are using Marten to store events from RabbitMQ messages which our system needs.
And later we transform these events into our domain format events.

And we have issue that sometimes events stored not in sequence and we need go back and process some events that were skipped.
Also we need to have ability to scan all events and reprocess events or find gaps.

So the simplest way would be to read data from mt_streams, but we need to have ability read page by page what is not possible with mt_stream.
So we are using mt_events which have seq_id and very easy to read batches.
But problem that we need also get latest version which is stored in mt_streams, what adds additional performance issuer.

Do you have plan to add seq_id to mt_streams?

[jeremydmiller]

Hey, can you please prefer Discord or Discussions here for questions?

And I'd simply point you at the formal subscription support rather than suggest any direct table access.