Hacker News new | ask | show | jobs
by polskibus 2170 days ago
How does this feature compare to MS SQL's Temporal Tables 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.).
1 comments
deleuze 2170 days 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.
link
polskibus 2169 days ago
What do you use for your event sourcing? Do you use Akka/Akka.NET Persistence or some other application framework?
link
deleuze 2169 days ago
We use Debezium and Kafka, it's been really nice.
link
polskibus 2166 days ago
Do you just process events it for analytics or do you actually perform rehydrating application state or replicating application state?
link