Imagine a world where the past is the only truth… all the truth (part 1)

By éric de carufel

Your computer systems surely contain several structured and relational databases. You must regularly make copies to avoid losing information. Despite these precautions, you lose all the intermediate states (system states after a past event) of your information systems.

If all you are interested in is the final state, it is not too serious. However, it is a safe bet that one day, you will have to answer questions like:

  • How much time elapses between the moment a customer puts an item in their virtual shopping cart and the moment they complete their transaction?
  • How many times has this item been removed from a shopping cart?
  • What was the order’s status before the crash?

If you have not defined these needs during the initial design of your system, you will not be able to answer such questions. Of course, you will be able to do it, but only when the necessary features are deployed… And again, you will only have data from then on.

So I propose a solution that you can implement first and that will allow you to answer these questions at any time, and even those that you have not yet thought of: CQRS and Event Sourcing.

The strength of this duo comes from Event Sourcing (I will talk about CQRS in a future post).

Do you remember everything you’ve heard about side effects? Among other things, that you should do everything to avoid them?! Well, in this case, these effects are the only things that matter.

How does Event Sourcing work?

In this type of system, we do not keep the actual data, but rather its effect, in the form of past events. For example, if I launch the following command:

var command = new AddItemToCart(cartId, itemId);

The system will create the following event:

var @event = new ItemAdded(cartId, itemId);

One of an events system’s strengths is that it is now possible to follow the withdrawals made to the system, since instead of deleting the information, we add some:

var command = new RemoveItemFromCart(cartId, cartItemIndex);

Which will create the following event:

var @event = new ItemRemoved(cartId, cartItemIndex);

In this system, all the events will derive from basic classes:

public class EventBase  {    public Guid Id { get; set; }    public int Sequence { get; set; }    public DateTime TimeStamp { get; set; }  }

An infrastructure class will also be necessary in order to make sure that all the events are assigned a date and a sequence.

Basic principle

In such a system, only the events have value. They reflect what actually happened. These events will serve to build reading patterns specific to each interested system. They will each have their small database to answer their immediate needs, and changes will only affect one system.

And then?

In my next post, I will go into more details and give some examples of the value brought by the events preserved in this way.

Other Stories You Might Be Interested In

Three tips for dealing with the IT labour shortage

If you’re reading this page, it’s probably because you too have been affected by the new labour shortage “pandemic” that began a few years ago and has been impacting large companies’ information technology recruitment efforts as they attempt to find qualified workers.   The labour shortage has hit the IT sector hard This new pandemic...

Did you know that your technology may be outdated?

Are you overwhelmed with internal requests? Is your IT support team overwhelmed? Are you still able to deliver to your customers? Are your employees frustrated?  Very often, these situations are related to tools that are no longer adequate or to aging technology that no longer meets the changing needs of the company. Eric De Carufel,...

Web development: Why Blazor is the ideal framework?

Blazor. In early November 2018, when it was still an experimental product, I was talking about Blazor at an event we had organized at our office. By the way, I had surprised many colleagues when I revealed at the end that my PowerPoint presentation had been prepared with Blazor. I followed the evolution of this...