I haven't used the Streaming API yet. I was just researching on it actually and I like the option for PushTopics. However it's not clear to me what's the advantage/difference using that versus a process that gets started from a trigger.
My_Object__c.Reference_Number__c gets modified and I want to update the value of this field in an outside system. Say storage table in Azure/AWS.
I can do this in the following manner: Use a trigger to fire a @future/queueable method that will make a REST API POST callout. I think that can be dangerous because the async methods might not execute in the same order the field was modified, say it was modified twice in a row. So ideally I would schedule a job to execute later to get the most current data.
Is PushTopic a better option for such a process and what would be the advantages? I see that there can be
<100 PushTopics(depends on the edition) per org, what other limitations are there that should be taken into consideration?