I guess the best approach would be to store a placeholder in the database, something like '[[SITE_WWWROOT]]' then substitute it with the actual value after retrieving the database data but before displaying it.

The problem is that would need to be done anywhere that saves a site url in the database, which could include a whole lot of third party modules outside of our control. In principle though, that would make the database more portable.

Simon