This is very cool! I built a similar tool for a project with the need for two-way data syncing between Salesforce and MySQL via Laravel. Salesforce objects map quite nicely onto Laravel’s Eloquent models (and booleans work fine! ref @ianyanusko in a sibling thread) On the Salesforce side we use triggers to send a summary of field changes to Laravel to apply to its MySQL database. These are very cheap in terms of Sale…
Nice! Great point about the round trip - we do something similar for formulas and auto-generated fields like `Id`. That's awesome you built this in-house. > Syncing data from Salesforce (to seed a database for example) is done via REST too. It works OK. Have you thought about using the Bulk API for seeding? We started relying on that instead of REST, which helped us seed massive DBs much faster / more efficiently.
As you know, the REST API will deliver a maximum of 2000 records per request, so beyond a certain scale it's not really tenable in terms of speed & consumption of API calls.
So yes, Bulk API is probably going to feature soon.
Cheers Ian!