Have you by chance posted a similar question on Stack Overflow?
If so, then:
- consider incremental loads from the DB to the shiny app
- consider also the cross posting policy of this site
https://forum.posit.co/t/faq-is-it-ok-if-i-cross-post/
In general it is good manners either not to cross post, or if cross posting is necessary then state the fact. It can be awkward for a person trying to help to address your question on one site, only to see it pop up on the other.