I have 3 installations of my website: beta, demo, and production. Template and functionality changes are made on beta, content is entered on demo and everything moves to production as it is approved.
We are using Assets for all of our, um, assets (images, audio files, etc.). I would like to move everything to Amazon S3 and have all 3 installations point to one place so that I don't have to have 3 copies of everything. Is this possible? In order to update the database, right now, I back up the version on demo and move it to the other locations. So that would have the index information, right?
If anyone has any other ideas on the best way to store assets in one location for use in multiple installations, I would appreciate hearing about them.