0

I'm creating an application in which users should be able to travel back in time on documents, and pick an older doc state to set as a new one. Kind of like a nice undo-redo functionality, with history all the way back to the start of the document.

Now I'm reading about point-in-time-recovery (PITR). Can I use this to travel back in time on one part of the db? (One document that Has Many paragraphs)? Or is this only to put the complete DB back in a previous state, for actual emergencies?

I've read about bitemporal data, but I just wondered if this may be a more ready-to-go solution

Sventies
  • 2,314
  • 1
  • 28
  • 44

1 Answers1

1

It's the latter. Supabase point in time recovery is to put the entire database back to a state sometime in the past, and it would not be suited for your usecase.

dshukertjr
  • 15,244
  • 11
  • 57
  • 94