SqlProjectionStoreType

Stores one durable, contiguous sequence position per projection and persistence ID. Connection factories must return new, unopened connections. The journal factory must read the authoritative journal database, not a replica. Read-model writes must use the connection and transaction supplied to the projection handler, so they commit with progress. Journal history must remain available until every required projection has processed it. Table and column names are quoted as individual identifiers; schemas are separate arguments. The progress table and its companion lock table are owned by FCQRS and must not be edited. Journal source settings are compared conservatively. Password changes are excluded from the persisted source binding so a new store can resume existing progress after credential rotation.