33 ms·
With FindTheMasks, we found that tooling written around Sheets may also confront the 5 million cell limit. As you tack on extra tabs and handle more fields, it
by ISL 6y ago
With FindTheMasks, we found that tooling written around Sheets may also confront the 5 million cell limit.
As you tack on extra tabs and handle more fields, it isn't too hard to approach that limit.
If we do trip that threshold, we will be forced to degrade some functionality.
As a bonus, I don't believe that Sheets allows anyone to see exactly how many cells are in use, so one lives with a probabilistic risk of lockup.
If we were continuing to handle large volumes of intake, a switch to Airtable would be in the works. Fortunately, the PPE situation is at least somewhat better than it was in March, so we are simply keeping the lights on and wheels turning.
- spacehunt 6y agoAirtable has a hard limit of 50,000 records across all tables in a base though.
- ISL 6y agoIf those records could have an arbitrary/large number of fields, that would suffice for our foreseeable needs. We're at ~6,000 individual entries at the moment and do not expect a 10x jump at this time. Our efforts now center on updates to and removals from our public map. Airtable-wise, I'm parroting our devs on the subject. We had perpetual/nascent plans for an Airtable migration (and did so when FindTheMakers came to life) which have been tabled for now. We believe we'll make it to sunset on Sheets, but just barely.
- arthurcolle 6y agoThat seems like a crazy low limit compared to the traditional spreadsheets I'm used to. Is there some special meaning of "record" in their vernacular?
- spacehunt 6y agoAirtable is closer to a database than a spreadsheet. Records are represented as rows in their default grid view, but there are other views available. They can also be retrieved as JSON objects through the API that Airtable automatically generate for you.
- raybb 6y agoHave you heard of or tried https://cryptpad.fr/index.html https://cryptpad.fr/index.html or https://ethercalc.net/ https://ethercalc.net/ ? I haven't used either before but cryptpad seems solid. Here's a demo sheet https://cryptpad.fr/sheet/#/2/sheet/edit/DirOb8rZr+6gfi5PCrS1c9SC/ https://cryptpad.fr/sheet/#/2/sheet/edit/DirOb8rZr+6gfi5PCrS...