New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Refactor: use jsonb_set to update metadata, instead of retrieving and rewriting #887

Open

nonprofittechy opened this issue Oct 14, 2024 · 1 comment

Member

nonprofittechy commented Oct 14, 2024

Currently, on every screen load, we get the value of the interview's metadata, edit it in Python code, and then re-save it to the database.

It would be more efficient (and probably safer for concurrency) if we use jsonb_set()

https://www.postgresql.org/docs/15/functions-json.html

Member Author

nonprofittechy commented Oct 14, 2024

We are using a function upstream AssemblyLine right now, so this could be a big refactor

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment