How to rebuild sqlite db for R with latest version

Issues & Suggestions FAQ
1

Rebuild RSQLite with latest version

  1. Install packages:
    c(‘xml2’, ‘plogr’, revest’, ‘memoise’, ‘DBI’)
  2. Clone RSQLite source:
    https://github.com/rstats-db/RSQLite
  3. Download SQLite 3.15.0:
    http://www.sqlite.org/2016/sqlite-amalgamation-3150000.zip
  4. Copy “RSQLite/src/sqlite3/extension-functions.c” to “sqlite-amalgamation-3150000”
  5. Replace “RSQLite/src/sqlite3” with “sqlite-amalgamation-3150000”
  6. Run “R CMD INSTALL RSQLite”