SQLite database in shiny app created as a package

[martonbalazskovacs]

Hi,

I am trying to create a shiny app that uses a local SQLite database. I am also trying out the fairly new {golem} package that helps you to build your shiny apps as a package. Do you have any recommendation on where should I place my code that connects and builds the database? Where should I store it if I do not want to make it available for the users? Should I just put it in the R/ folder?

Thanks!

[martonbalazskovacs]

I've asked the golem package developer @colin, and he created a little example for golem and SQLite. Here it is: https://github.com/ColinFay/golemqlite