Cannot open the uploaded .db file in the shinyapp.io.

[pavlohrab]

Greeting,

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 ?(:

[nirgrahamuk]

@pavlohrab

The loading bar went red with some sort of HTML error (nothing in logs, only on the bar).

Seems like the file itself failed to upload.
Most browsers have inspector tools that will let you monitor javascript errors as they occur. I'd check there.