0010852: Store in-db sync cursor

ID	Project	Category	View Status	Date Submitted	Last Update
0010852	Taler	Cyclos integration	public	2026-01-06 10:20	2026-08-29 19:42

Reporter	Antoine A	Assigned To	Antoine A	Resolution deadline
Implementer		Reviewer
Release signed by		Deployed by
Verifier		Communicator
Data protection authority notification required	No
CSIRT notification required	No
Estimated effort (hours)		Actual effort (hours)	0
Fast-track	No
Work package	none
Priority	high	Severity	major	Reproducibility	N/A
Status	implementing	Resolution	open
Target Version	1.9

Summary	0010852: Store in-db sync cursor
Description	The current pagination system uses a page/offset design, which should mean that paginated lists should be append-only, otherwise it would be possible to miss some transactions. There is also a way to filter using dates, which would be a more durable cursor to store. I need to ask the Cyclos manager what he thinks is the best solution. Since the history JSON is not complete enough for our use case, we need to retrieve transfer details, which creates an N+1 query problem, making the cursor very important for performance.
Tags	No tags attached.

Date Modified	Username	Field	Change
2026-01-06 10:20	Antoine A	New Issue
2026-01-06 10:20	Antoine A	Status	new => assigned
2026-01-06 10:20	Antoine A	Assigned To	=> Antoine A
2026-08-29 19:42	Florian Dold	Target Version	=> 1.9
2026-11-03 07:21		Status	assigned => implementing