Create a pekko.projection.Projection with at-least-once processing semantics. It stores the offset in Cassandra after the handler has processed the envelope. This means that if the projection is restarted from previously stored offset some elements may be processed more than once.

The offset is stored after a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with AtLeastOnceProjection.withSaveOffset of the returned AtLeastOnceCassandraProjection. The default settings for the window is defined in configuration section pekko.projection.at-least-once.

Create a pekko.projection.Projection with a FlowWithContext as the envelope handler. It has at-least-once processing semantics.

The flow should emit a Done element for each completed envelope. The offset of the envelope is carried in the context of the FlowWithContext and is stored in Cassandra when corresponding Done is emitted. Since the offset is stored after processing the envelope it means that if the projection is restarted from previously stored offset then some envelopes may be processed more than once.

If the flow filters out envelopes the corresponding offset will not be stored, and such envelope will be processed again if the projection is restarted and no later offset was stored.

The flow should not duplicate emitted envelopes (mapConcat) with same offset, because then it can result in that the first offset is stored and when the projection is restarted that offset is considered completed even though more of the duplicated enveloped were never processed.

The flow must not reorder elements, because the offsets may be stored in the wrong order and and when the projection is restarted all envelopes up to the latest stored offset are considered completed even though some of them may not have been processed. This is the reason the flow is restricted to FlowWithContext rather than ordinary Flow.

Create a pekko.projection.Projection with at-most-once processing semantics. It stores the offset in Cassandra before the handler has processed the envelope. This means that if the projection is restarted from previously stored offset one envelope may not have been processed.

For testing purposes the projection offset and management tables can be created programmatically. For production it's recommended to create the table with DDL statements before the system is started.

Create a pekko.projection.Projection that groups envelopes and calls the handler with a group of Envelopes. The envelopes are grouped within a time window, or limited by a number of envelopes, whatever happens first. This window can be defined with GroupedProjection.withGroup of the returned GroupedCassandraProjection. The default settings for the window is defined in configuration section pekko.projection.grouped.

It stores the offset in Cassandra immediately after the handler has processed the envelopes, but that is still with at-least-once processing semantics. This means that if the projection is restarted from previously stored offset the previous group of envelopes may be processed more than once.