TheCandidStartup / TheCandidStartup.github.io

The Candid Startup Blog
https://www.thecandidstartup.org
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

2023/06/05/spreadsheet-insert-delete #20

Open utterances-bot opened 1 year ago

utterances-bot commented 1 year ago

Making Spreadsheet Snapshots work with Insert and Delete

When you’re implementing a cloud spreadsheet, it’s tempting to think of it as just another kind of database. Each row of the spreadsheet is equivalent to a row in a database. Each column in the spreadsheet is equivalent to a column in a database. Yes, spreadsheets don’t have schemas. Yes, spreads...

https://www.thecandidstartup.org/2023/06/05/spreadsheet-insert-delete.html

timwiegand commented 1 year ago

I updated the "Inverting a transform" section in this commit.

I realized that you can invert tranforms on the fly, even as you do a binary chop over the original. There's no need to create a complete inverse transform and then worry about how to store or cache it.