I am looking to using Statamic for one of my latest projects but am slightly unsure as to how it currently handles content between environments.

Usually I have a Production website, a Staging and a local environment (Mainly based on Wordpress). My issue with Wordpress is that during development, if any new posts or pages are created on production, it is messy to merge or copy the new content so that it is not lost when publishing the changes. There are various plugins but these tend not to be reliable or have a large monthly cost.

As Statamic uses flat file storage, how would the content sync above be maintained?

One option could be to keep the content files in an external S3 bucket so that all the storage is separated from the site files.

Looking to get some opinions and best practises around this.