toluaina/pgsync

Write To Database Table Instead of Text File

jvanderen1 opened this issue · 2 comments

jvanderen1 commented

Maintaining the generated pgsync file in the cloud has proven slightly cumbersome. I was wondering if we could have an option instead write the checkpoint into a database table? A table with a schema like:

Checkpoint Name Value
<user>_<database>_<index> <Generated Hash>
toluaina commented

How about moving this to Redis?
I'd prefer to pollute the database as little as possible.
I think I had a POC branch to move this to Redis

  • 👍1
jvanderen1 commented

@toluaina That is fair. I ended up actually Dockerizing my application and maintaining this checkpoint file within a persistent cache layer.