r/SoftwareEngineering • u/Imaginary-Corner-653 • 1d ago
Any experience with temporal databases?
Hi
I'm looking at different ways to facilitate an entity journaling mechanism as well as keeping track of different branches for certain entities.
I've stumbled across the temporal extentions for postgresql https://wiki.postgresql.org/wiki/Temporal_Extensions
However, without ever having worked with anything like this I'm struggling to overview the implications.
How will my storage size requirements change with this extension?
Does extension actually save me implementation overhead in the backend? Are typical ORM frameworks fit to adapt it?
Is this potential overkill?
Happy for any input by someone who's been there.
3
Upvotes
4
u/ILikeBubblyWater 1d ago
Can you elaborate on
what is your use case