Solid practical write-up! Handling state persistence across CSV re-exports without primary keys is a classic ETL headache. Relying on (author, handle, comment) as a composite key is spot-on. Have you considered hashing the tuple (e.g., SHA-256) for faster dictionary lookups on larger datasets, or do you keep the raw tuple directly in memory
Ahmed Adawy
Computational Nuclear Engineer • Scientific Python • AI Engineering
Solid practical write-up! Handling state persistence across CSV re-exports without primary keys is a classic ETL headache. Relying on (author, handle, comment) as a composite key is spot-on. Have you considered hashing the tuple (e.g., SHA-256) for faster dictionary lookups on larger datasets, or do you keep the raw tuple directly in memory