I'm using R (R Studio) with large SQLite databases and it's a dream come
true.
Here's a simple example of a ToxCast chemical table inside a Substance
database.
# Load the following libraries into R
# DBI R Database Interface
# RSQLite SQLite interface for R
drv <- dbDriver("SQLite")
con <- dbConnect(drv, dbname = "substance.db", flags=SQLITE_RO)
dbListTables(con)
dbGetQuery(con, "select * from toxcast_phase2")
dbGetQuery(con, "select id, dsstox_rid, cas_no, formula,
molecular_weight, chemical_name from toxcast_phase2 where id < 10")
dbDisconnect(con)
dbUnloadDriver(drv)
Once you have access to the SQLite database, you can of course direct
your queries into a Vector, Matrix, or Array object and utilize in R as
needed.
Awesome!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users