News for hackers. Stuff that matters.

A comment on Things I wished more developers knew about databases. Parent comment

Re:Things I wished more developers knew about databases by zbentley on Wednesday April 22, 2020 @11:08PM (#22952478)
Not the GP, but I assume transactional consistency was important for the report, hence the need to keep the connection alive. That's a pretty common situation.
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by fendy3002 on Thursday April 23, 2020 @07:55AM (#22954986)
Does it means the report take the tables hostage for 30+ minutes? How can transactional consistency be achieved without write lock? Temporary table?
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by CodesInChaos on Thursday April 23, 2020 @12:24PM (#22957678)
Reporting can typically be split into two transactions. One long-running readonly transaction with snapshot consistency obtaining the data for the report and a separate transaction which publishes the result.
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by blattimwind on Thursday April 23, 2020 @08:10AM (#22955060)
MVCC.
[ Parent | on HN ]