Does that correspond to 48h « exactly »?
To confirm with @pierre-gilles, but the data on this timeline may be stored in memory then transferred to the file…
I’ll take a look!!
EDIT: No storage in « memory ».
From what I see, unlike the SQL DB, when we stop gladys, duckdb’s .duckdb.wal remains and is more recent than the .duckdb … Can you confirm? What are the dates and times of the two files for you?

For my part I only have 1 hour of inaccessible data (which corresponds to the time difference between the files - 9:52 vs 10:48):
