A system configured for synchronizing database operations with a distributed blockchain, the database operations being performed on a database that is hosted on one or more database servers that are accessible by multiple users including a first user and a second user, the system comprising:
- a database server configured to host the database, wherein the database server is accessible by the first user through a first client computing platform and by the second user through a second client computing platform, wherein the database server is further configured to receive notifications and propagate database operations to different local versions of the database, wherein the different local versions include a first local version of the database and a second local version of the database, wherein the first local version of the database is accessible by the first user through the first client computing platform and not accessible by the second user, and wherein the second local version of the database is accessible by the second user through the second client computing platform and not accessible by the first user;
- and
- one or more hardware processors configured by machine-readable instructions to:
- receive, from the first client computing platform, a first set of database information reflecting a first set of one or more database operations performed locally by the first user on the first local version of the database, wherein the first set of one or more database operations effectuates changes to a first set of one or more cells of the first local version of the database;
- receive, from the second client computing platform, a second set of database information reflecting a second set of one or more database operations performed locally by the second user on the second local version of the database, wherein the second set of one or more database operations effectuates changes to a second set of one or more cells of the second local version of the database, wherein the second set of one or more cells of the second local version of the database is different from the first set of one or more cells of the first local version of the database;
- record on the distributed blockchain a first message, wherein the first message describes or refers to a description of a first set of one or more modifications to the database, wherein the first set of one or more modifications corresponds to the first set of one or more database operations;
- record on the distributed blockchain a second message, wherein the second message describes or refers to a second description of a second set of one or more modifications to the database, wherein the second set of one or more modifications corresponds to the second set of one or more database operations;
- perform a first verification whether the first set of one or more database operations is allowed to be performed by the first user;
- perform a second verification whether the second set of one or more database operations is allowed to be performed by the second user;
- effectuate transmission to the database server, responsive to the first verification verifying the first user is allowed to perform the first set of one or more database operations, of a first notification, wherein, subsequent to receipt by the database server of the first notification, the first set of one or more database operations is propagated to the second local version of the database, such that the second local version of the database, upon being accessed by the second user, reflects that the first set of one or more database operations has been performed on the second local version of the database;
- record on the distributed blockchain a third message, responsive to the second verification verifying the second user is not allowed to perform the second set of one or more database operations, wherein the third message describes or refers to a third description of a third set of one or more modifications to the database, wherein the third set of one or more modifications to the database reverts the changes to the second set of one or more cells of the second local version of the database, that were due to the second set of one or more modifications to the database, as previously recorded through the second message;
- and
- effectuate transmission to the database server, responsive to the second verification verifying the second user is not allowed to perform the second set of one or more database operations, of a second notification, wherein, subsequent to receipt by the database server of the second notification, the second set of one or more database operations on the second local version of the database is reverted such that the second local version of the database no longer includes the changes to the second set of one or more cells of the second local version of the database, and wherein the second set of one or more database operations is not propagated to the first local version of the database, such that the first local version of the database, upon being accessed by the first user, reflects that the second set of one or more database operations has not been performed on the first local version of the database.