[R] how to read a database in R?
jrkr|de@u @end|ng |rom gm@||@com
Sat Feb 1 15:55:23 CET 2020
Stolen from https://gist.github.com/jwolfson/72bc7d7fd8d339955b38
I cannot remember if you will need to install any other packages besides
filename <- "your_db_file.db"
sqlite.driver <- dbDriver("SQLite")
db <- dbConnect(sqlite.driver,
dbname = filename)
## Some operations
mytable <- dbReadTable(db,"your_table_name"
Best of luck
On Sat, 1 Feb 2020 at 07:53, Ana Marija <sokovic.anamarija using gmail.com> wrote:
> Hi Ivan
> Thanks for getting back to me. Can you please share with me some code I
> would use to see what is in my database?
> On Sat, 1 Feb 2020 at 06:19, Ivan Krylov <krylov.r00t using gmail.com> wrote:
> > On Fri, 31 Jan 2020 17:02:16 -0600
> > Ana Marija <sokovic.anamarija using gmail.com> wrote:
> > > I have a database DGN-WB_0.5.db is there is a way to explore its
> > > content in R?
> > My psychic debugging powers tell me that it's an SQLite database, so
> > the answer to your question is: yes, it should be possible to both find
> > out the schema and run SQL queries on your file from R.
> > --
> > Best regards,
> > Ivan
> [[alternative HTML version deleted]]
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
Kingston ON Canada
[[alternative HTML version deleted]]
More information about the R-help