22 ms·
This theoretically should be possible with MVCC, right? It's not an area I've explored and I could immediately see some issues with resource clean-up, but I cou
by mikedouglas 4y ago
This theoretically should be possible with MVCC, right? It's not an area I've explored and I could immediately see some issues with resource clean-up, but I could imagine it being possible with most modern DBs.
- vbezhenar 4y agoYep, keep transaction open with necessary isolation. But it requires very thorough design of queries, as you'll run into locks pretty quickly. MVCC is not magic.
- twic 4y agoOr using an Oracle style AS OF query: https://oracle-base.com/articles/10g/flashback-query-10g https://oracle-base.com/articles/10g/flashback-query-10g