Timeline for How can I efficiently diff a CSV file against a database?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 1, 2022 at 6:14 | comment | added | Christophe | @GACy20 I agree for the scenario of the temporary db table, since it moreover allows to share the same code for calculating the hash. In ly answer I was more neutral, since this approach can also be used to accelerate the local scenario. Thanks for making it more explicit. | |
| Aug 31, 2022 at 13:25 | comment | added | GACy20 | I'd personally let the DB compute the hashes during the loading of the CSV into a temporary table. Seems faster and makes the process simpler, since in that way it remains an internal detail inside the DB and doesn't require any kind of external change. | |
| Aug 31, 2022 at 10:44 | vote | accept | Isvara | ||
| Aug 31, 2022 at 10:43 | comment | added | Isvara | Unfortunately it's not possible at this point to get those events—they happen in someone else's system. Using a combination of answers, pulling all the digests from the database and comparing those locally might be the way to go. | |
| Aug 31, 2022 at 8:56 | history | answered | Christophe | CC BY-SA 4.0 |