	US 12,326,876 B1
	Systems and methods for managing web, mobile, and point-of-sale servers with a customer relations management system
Mikel Lindsaar, Sydney (AU); and Ben Pritchard, Sydney (AU)
Assigned to StoreConnect International Pty Ltd, Sydney (AU)
Filed by Mikel Lindsaar, Sydney (AU); and Ben Pritchard, Sydney (AU)
Filed on Aug. 28, 2024, as Appl. No. 18/818,483.
Int. Cl. G06F 16/27 (2019.01); G06Q 30/01 (2023.01)

CPC G06F 16/27 (2019.01) [G06Q 30/01 (2013.01)]

20 Claims

1. A method for synchronizing a first database and a second database comprising:

storing the first database in a first memory of a first computing device, and the second database in a second memory of a second computing device;

detecting a first update to the first database;

creating, based on the detecting, a first message queue item;

inserting the first message queue item into a first message queue database on the first computing device;

replicating the first message queue item from the first message queue database to a second message queue item in a second message queue database on the second computing device;

selecting the second message queue item from the second message queue database; and

updating, based on the selecting, the second database to correspond to the first update;

wherein the replicating of the first message queue item comprises:

detecting the insertion of the first message queue item into the first message queue database;

creating a first queue update object representing the insertion of the first message queue item into the first message queue database;

transmitting the first queue update object to the second message queue database; and

applying the first queue update object to the second message queue database to insert the second message queue item into the second message queue database;

wherein the selecting of the second message queue item from the second message queue database comprises:

detecting the presence of the second message queue item; and

removing the second message queue item from the second message queue database; and

wherein the updating of the second database comprises:

creating a first database update object representing the first update to the first database; and

applying the first database update object to the second database;

wherein the first database update object represents an action selected from the group consisting of a change to a value in the first database, an insertion of a first record into the first database, a deletion of a second record from the first database, an addition to a schema of the first database, and a deletion from the schema of the first database.