I am building an app on GlideOS and trying to understand a few things about storage and data retrieval before it goes into wider use. I could not find these answered in the docs or the security whitepaper, so hoping someone here can help, or point me to the right place.
Quick first question: the security whitepaper on the site is dated January 2023 and describes the classic Glide architecture with a spreadsheet backend. Does that document still apply to GlideOS, or is there a newer one?
For the rest, some context on scale. The app collects operational records that have to be kept for several years for compliance reasons. I am estimating around 1,000 records per month, each linked to five to ten child rows and at least one photo. Over a ten-year period that works out to roughly 120,000 parent records, over a million child rows, and a lot of images.
- Is that volume normal for GlideOS, or am I pushing it? Does performance hold up at that size?
- Are there row limits per table or per app, and what happens if you hit one?
- Are there limits on image storage, either per file or in total?
- If a subscription lapsed or was cancelled, what happens to the data? How long is it still retrievable, and in what format can it be taken out?
- Is there an API or a scheduled export for pulling all tables at once, rather than exporting one view at a time?
Number 4 is the one I most need to get right. The retention requirement runs longer than any subscription I can commit to, so I need to understand what could be retrieved and when.
Thanks in advance.