> New nullable columns are kryptonite to large Corrosion tables: cr-sqlite needs to backfill values for every row in the table
Is this a typo? Why does it backfill values for a nullable column?
> New nullable columns are kryptonite to large Corrosion tables: cr-sqlite needs to backfill values for every row in the table
Is this a typo? Why does it backfill values for a nullable column?
It seems to be a quirk of cr-sqlite, it wants to keep track of clock values for the new column. It's not backfilling the field values as far as I understand. There is a comment mentioning it could be optimized away:
https://github.com/vlcn-io/cr-sqlite/blob/891fe9e0190dd20917...
I assume it would backfill values for any column, as a side-effect of propagating values for any column. But nullable columns are the only type you can add to a table that already contains rows, and mean that every row immediately has an update that needs to be sent.
[flagged]
Not a word of that article came from an LLM. You just don't like my writing.
You think an LLM would have started a sentence with "Which is why that’s how"? Only me, baby.
There has been a period of call-out-ai-slop-for-upvotes here for a while that people may have bots just randomly posting such accusations.
Love your response!