“balls”: The day I locked everyone out of the company intranet

Re:“balls”: The day I locked everyone out of the company int... by stevezsa8 on Saturday July 15, 2023 @06:25AM (#36735286)

Maybe I don't fully comprehend what you're saying... but is it even possible to do this?

I mean what if at some point particular entries were manually tweaked and the database was updated to fix an error in an invoice or something. And then you recreated data from what you assume is 100% reliable data.

I'm happy to try to understand if you don't mind simplifying the explanation.

[ Parent | on HN ]

Re:“balls”: The day I locked everyone out of the company int... by KennyBlanken on Saturday July 15, 2023 @11:41PM (#36743360)

Probably compared their code's recreated table against the table from the day old backup.

If twenty years worth of data (up until two days ago) match, then the recreation of the missing day is probably fine too. It's not guaranteed of course, but...

[ Parent | on HN ]

Re:“balls”: The day I locked everyone out of the company int... by fukawi2 on Sunday July 16, 2023 @01:33AM (#36743987)

I can't remember the specific details now (almost 20 years have passed!), but the STKM table was effectively a performance/convenience data store. Every bit of information was available from other transactional data, but in order to actually have a chronological historical view of "stock movements", it was maintained in this central table.

[ Parent | on HN ]