[wp-trac] [WordPress Trac] #60375: Site Transfer Protocol

[WordPress Trac]

#60375: Site Transfer Protocol
-------------------------+------------------------------
 Reporter:  zieladam     |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Import       |     Version:
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+------------------------------

Comment (by zieladam):

 @dmsnell had an idea of setting up a state table on both the "source" and
 the "target" site. It would consist at least of a "Connection ID",
 "Version number", and "Record identifier". Potentially it could also
 include a "Last updated" timestamp.

 A connection ID would be different for each connected site – I could have
 a single WordPress propagating content to three different sites.

 A Version Number would be a simple counter. Anytime a database record
 changes, it's incremented. The actual data revision wouldn't be stored
 here, just the number. The only purpose is to check whether a given record
 changed since the last sync.

 A Record identifier would uniquely identify a record. It could be two
 columns – one for the table, and one for the record ID.

 The timestamp would enable querying changes made since a specific point in
 time, e.g. "the last sync" but also "yesterday".

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/60375#comment:20>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform