ianb
January 17, 2024, 8:33pm
2
This might help:
Here’s my updated version of this to work with the modern (as of January 2022) anvil.yaml file format. I only use this with a Git version of the file, not with an exported one.
from __future__ import annotations
# standard-lib modules:
import pathlib
import sqlite3 as dblib
import datetime
import json
import shutil
# third-party modules:
import yaml # i.e., py -m pip install pyyaml
# web-service imports
import anvil.server
from tables import app_tables
# Note: Reading a full-project .yam…
Or this, after you download your tables to csv on your local machine you might use this code:
https://anvil.works/build#clone:Z4O2BXJEL6TVJ4QK=2LL4HNW3TZQAG7FICS57W6JN
[csvexample]
I see many new anvil users struggling to load data sets into the data tables for the first time without having an example of how to avoid abusing the free resources while still loading your use case sample data under the 30 second limit provided by the server modules.
So I created this full example app.
Feel free to clone it and use it for testing, reference, ideas, or anything else.
It is not fast. That’…
Either way, what I am suggesting is using some sort of backup to download your tables data, then loading it to the data tables system located in your local self-hosted anvil environment.
4 Likes