News for hackers. Stuff that matters.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @01:32PM (#42880657)
As the sibling says, it is easy to think about in terms of what you are doing with the data. Reporting on how many transactions of a type have happened over a duration? Probably OLAP. Really, if the word "report" shows up, at all, probably OLAP. Executing parts of a workflow for an active transaction? OLTP.

Briefly looking, I can't find the books that I thought covered a lot of this in a good way. Will keep looking, apologies.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by datadrivenangel on Thursday January 30, 2025 @01:33PM (#42880668)
Designing Data Intensive Applications is a very good book in this space.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by bobnamob on Friday January 31, 2025 @01:44AM (#42885186)
Designing Data Intensive Applications by Martin Kleppmann is required reading if you're in this space.

I can't recommend it highly enough.

[1] https://www.amazon.com/Designing-Data-Intensive-Applications...

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Friday January 31, 2025 @12:07PM (#42889417)
Indeed, I upvoted that response to me, but I should have said as much. This is the book I couldn't remember the name of for the life of me. Really good book.