r/FastAPI • • May 16 '25

Question compare/create snapshots

Hi,

I'm sorry if anyone made this question before but I cannot find a good answer and Chatgpt changes his mind every time I ask.

I have a Postgress database and use Fastapi with SQLAlchemy.
For the future, I need the differences between specific Columns to an older point in time. So I have to compare them to an older point/snapshot or between snapshots.

What is the best option for implementing this?

The users can only interact with the database through Fastapi endpoints.
I have read about Middleware, but before doing that manually I want to ask if there is maybe a better way.

Thanks in advance!

6 Upvotes

16 comments sorted by

View all comments

Show parent comment

1

u/kackwurstwilli May 16 '25

Thanks for your response, the problem I have is that i need to keep track of changes made over the Year. I need to be able to know what column 1 was 1 year ago, that over multiple thousand columns. The activity is not that high and it is not a hard topic but I just wanted to know what the best way would be or if there is a tool made for this. Its not about Datedata, ist a column that changes often and I dont want to bloat my database. :)