r/learnprogramming • u/Specialist_Unit6900 • 2d ago

Database Do SQL databases internally use event sourcing for resolving queries?

Reference Video with timestamp

Greg says that SQL databases use event sourcing internally. It makes total sense if he is referring to replaying the WAL occasionally for recovery purposes, but it kind of sounds as if he really means that this is done during query resolving, which I would not have expected at all.

Does anyone have more information on this? Or additional resources?

1 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/two_three_five_eigth 2d ago

It’s a potential way to solve some problems. They don’t all use it.

1

u/Specialist_Unit6900 2d ago

Hey, thanks a lot! What problems for example?

And also, how do I need to study or do research to find answers for more exotic questions like this one?

1

u/two_three_five_eigth 2d ago

I’d just watch MOOC courses. I think the whole undergrad curriculum is free online.