currently we directly hit the sg for everything, building pages, doing analytics, etc.
every time anything needs to refresh, we go and fetch all the data every time
this is not how people build applications generally, especially applications that exclusively use append only immutable data
we should only need to be querying incrementally whenever we suspect there might be new data to fetch
keep a local case in a db, e.g. sqlite or duck db
then we build the GUI from the local db
currently we directly hit the sg for everything, building pages, doing analytics, etc.
every time anything needs to refresh, we go and fetch all the data every time
this is not how people build applications generally, especially applications that exclusively use append only immutable data
we should only need to be querying incrementally whenever we suspect there might be new data to fetch
keep a local case in a db, e.g. sqlite or duck db
then we build the GUI from the local db