Skip to content

Instantly share code, notes, and snippets.

@jwolfson

jwolfson/readSQLite.R

Last active April 19, 2024 01:42
Show Gist options
  • Star 10 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save jwolfson/72bc7d7fd8d339955b38 to your computer and use it in GitHub Desktop.
Save jwolfson/72bc7d7fd8d339955b38 to your computer and use it in GitHub Desktop.
Download ZIP
Reading an SQLite .db file into R
Raw
readSQLite.R
library(RSQLite)
filename <- "your_db_file.db"
sqlite.driver <- dbDriver("SQLite")
db <- dbConnect(sqlite.driver,
dbname = filename)
## Some operations
dbListTables(db)
mytable <- dbReadTable(db,"your_table_name")
@Aaron-maku
Copy link

thanks dude! this took me a while to solve.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment