Event sourcing – data integrity

Before going directly onto the theme of event sourcing, it is necessary to understand the functioning of most standard applications.

Whenever we run the command UPDATE in the database, we perform a modification to our current representation in the database. With that, whenever we do a query on the database, we seek the current state of a record. This behavior is called state mutation. Let's use an example to make it clearer.

State mutation

Suppose we have a table responsible for administering the access level of a user. The table is composed as follows:

ID	user_name	status	user_manager
1	John Doe	admin	Manager1

 

As we look at the preceding table, we...