Useful small bridge example. Two tests I'd add before using it across accounts: (1) give two servers the same numeric login and confirm the rows stay separate, so the key should include server; (2) change every copied account field and confirm the conflict branch updates each one. One field in the INSERT is missing from the UPDATE. Also, a single upsert keeps only the latest snapshot, not an audit history. If compliance needs changes over time, store timestamped observations separately and reconcile gaps after a disconnect.
Arnold Holm
I turn your trading setup into an MT5 bot with your prop firm's daily and max loss rules built in. Try it free on demo first.
Useful small bridge example. Two tests I'd add before using it across accounts: (1) give two servers the same numeric login and confirm the rows stay separate, so the key should include server; (2) change every copied account field and confirm the conflict branch updates each one. One field in the INSERT is missing from the UPDATE. Also, a single upsert keeps only the latest snapshot, not an audit history. If compliance needs changes over time, store timestamped observations separately and reconcile gaps after a disconnect.