Skip to content

Instantly share code, notes, and snippets.

View drveera's full-sized avatar

Veera drveera

View GitHub Profile
@jwolfson
jwolfson / readSQLite.R
Last active April 19, 2024 01:42
Reading an SQLite .db file into 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")