I have a website based database (PostgreSQL) and many remote databases (also PostgreSQL). In most cases, the remote databases will need to periodically update the website based database. Originally I was thinking of using JSON to do this, but was also thinking that a direct connection from the remote to the website database may be better.
In some cases there will be only one or two records consisting of about 20 fields, but in other cases there may be hundreds of records that need to be sent to update the website based database.
Can anyone suggest the best way to do this sort of updating?