2
0
mirror of https://expo.survex.com/repositories/troggle/.git synced 2026-01-18 22:22:53 +00:00

Can't edit same cave at the same time #17

Open
opened 2023-08-04 21:59:14 +01:00 by xle · 3 comments
Owner

In order to prevent merge errors and conflicts, people need to manually ascertain if someone else is editing a file: see Becka yelling "Is anyone editing 290?" in the tatty hut. It is 2023. SMA is a solved problem. Why is this necessary?

In order to prevent merge errors and conflicts, people need to manually ascertain if someone else is editing a file: see Becka yelling "Is anyone editing 290?" in the tatty hut. It is 2023. SMA is a solved problem. Why is this necessary?
xle added the Bug label 2023-08-04 21:59:14 +01:00
Member

because we have no file locking yet.
No work would actually be lost, because the data is commited to git as it is saved, but recovering it would be a pain.

because we have no file locking yet. No work would actually be lost, because the data is commited to git as it is saved, but recovering it would be a pain.
Member

From my to-do list:

Use select_for_update() and a transaction to prevent conflicts when 2 people try to save the same file. But MariaDB support lacking.

So yes, Django has the tools we need, but no, MariaDB doesn't support them. We would need to move to Postgres ?

From my to-do list: > Use select_for_update() and a transaction to prevent conflicts when 2 people try to save the same file. But MariaDB support lacking. So yes, Django has the tools we need, but no, MariaDB doesn't support them. We would need to move to Postgres ?
Author
Owner

Migrating from MySQL to Postgres is not a difficult process: seems to be a very high ROI change in this case.

Migrating from MySQL to Postgres is not a difficult process: seems to be a very high ROI change in this case.
Sign in to join this conversation.
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: expo/troggle#17