Hacker News Reader

Is there a way to handle scenarios where the data does update? Like backfill of latent events within a 1-2 day window.

You can copy the stable data to another table, then insert the updated data. The database has excellent compression and copying from one table to another is super fast.

Reply on news.ycombinator.com