powered by
Function to dump sqlite database (Now only use system version sqlite)
sqlite2sql(sqlite_bin = c(Sys.which("sqlite"), Sys.which("sqlite3")), dbname = "", out.sql = "", cmd = "{sqlite_bin} {dbname} '.dump' | gzip > {out.sql}", debug = FALSE, ...)
Sqlite executable file
Sqlite database path
Output SQL (gzip format)
The command be used to dump
If set TRUE, only print the command
Other parameters pass to system
system
# NOT RUN { sqlite2sql('sqlite3', 'default.sqlite', debug = TRUE) # }
Run the code above in your browser using DataLab