Message approach for multiuser mode of a client-server application

Usually when working with data rows in a database, it is necessary to differentiate between the work of different users or to restrict data for other users. However, a problem can arise when multiple users need to access the same data simultaneously. For example, an issue may appear when a user tries to delete a data sample while another user tries to edit it. In this case, data integrity will be violated. To solve this problem, it is necessary to provide a multiuser mode of operation of the client-server application for accessing the database. It can be obtained and organized using the transaction and locking mechanism. However, since there are quite a few different database management systems (DBMS), the proposed approach can differ significantly in the implementation process. Consequently, a different solution is proposed, which is similar to the mechanism of transactions and locks but works differently.