3 ms·

How does this feature compare to MS SQL's Temporal Tables https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver15

How does this feature compare to MS SQL's Temporal Tables https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/ta...? This feature seems to be well fitted to support some of the cases where event sourcing is introduced, I wonder if someone successfully applied event sourcing with use of temporal tables to reduce the amount of work that has to be done in the application code (Akka, etc.).

deleuze 6y ago
When we looked at temporal tables in SQL Server for event sourcing, I was put off by the fact that you have to read from multiple tables. CDC + some external data source still seems to be the better solution here, imo.
- polskibus 6y ago
  What do you use for your event sourcing? Do you use Akka/Akka.NET Persistence or some other application framework?
  - deleuze 6y ago
    We use Debezium and Kafka, it's been really nice.
    - polskibus 6y ago
      Do you just process events it for analytics or do you actually perform rehydrating application state or replicating application state?