Better update methods in database

sharingcloud / github-scbot

A custom GitHub Bot to manage our development workflows

MIT License

2 stars 0 forks source link

Better update methods in database #109

Closed Srynetix closed 3 years ago

Srynetix commented 3 years ago

Cause of a lot of troubles: there are excessive uses of save(), which creates a big UPDATE SET query with all fields changed. We have two options:

Tracking modifications through use of Option on a dedicated model (like a copy-on-write) (more difficult)
Adding unitary field update methods: more queries, but more safe to data races.

Srynetix commented 3 years ago

Linked to #107