Protocol Dataset | Notify Updates

This mode tries to solve a scenario where server and clients share a single database (server and clients are connected to the same physical database) and clients want to be notified every time other client has done any change on a dataset.

You can check in Demos folder, SQLLite/SingleDatabase demo.

Configure Dataset Server

Create a new Dataset Protocol Server and configure using the following properties

ApplyUpdates: set to True, every time there is a change, this will be broadcasted to clients
AutoSynchronize: set to False, here is not needed to set to true, because client is connected to the same database than server.
UpdateMode: set to upRefreshAll.


oServer := TsgcWebSocketServer.Create(nil);
oProtocolDataset := TsgcWSPServer_Dataset.Create(nil);
oProtocolDataset.Server := oServer;
oProtocolDataset.Dataset := <...your dataset..>;
oProtocolDataset.ApplyUpdates := true;
oProtocolDataset.AutoSynchronize := false;
oProtocolDataset.NotifyUpdates := true;
oProtocolDataset.UpdateMode := upRefreshAll;
>oServer.Port := 80;
oServer.Active := true;

Configure Dataset Client

Create a new Dataset Protocol Client and configure using the following properties

ApplyUpdates: set to True, every time there is a change, this will be sent to server.
AutoSubscribe: set to True, every time a new client connects to server, the client subscribes automatically to update, delete and new record.
UpdateMode: set to upRefreshAll.


oClient := TsgcWebSocketClient.Create(nil);
oProtocolDataset := TsgcWSPClient_Dataset.Create(nil);
oProtocolDataset.Client := oClient;
oProtocolDataset.Dataset := <...your dataset..>;
oProtocolDataset.ApplyUpdates := true;
oProtocolDataset.AutoSubscribe := true;
oProtocolDataset.NotifyUpdates := true;
oProtocolDataset.UpdateMode := upRefreshAll;
oClient.Host := '127.0.0.1';
oClient.Port := 80;
oClient.Active := true;