I have the .db file, which I managed to open with RSQLite package locally. The local shiny app works as expected, however, when I published it to the shinyapps.io, an error occurred.
The loading bar went red with some sort of HTML error (nothing in logs, only on the bar).
The code I used:
`conn <- dbConnect(RSQLite::SQLite(), input$sempi_data$datapath)
data <- dbGetQuery(conn, "SELECT * FROM tbl_segments") data <- data %>% filter(trackid==6)`
input$sempi_data is a fileinput field in the UI, where user can upload their database file (.db)
Any help ?(: