Hello, I have a database DGN-WB_0.5.db is there is a way to explore its content in R? I don't know anything about this data base. Thanks Ana
Too little information to tell. I googled the file name though and pages about genetics came up... perhaps you should ask in the Bioconductor support area. On January 31, 2020 3:02:16 PM PST, Ana Marija <sokovic.anamarija at gmail.com> wrote:>Hello, > >I have a database DGN-WB_0.5.db is there is a way to explore its >content in R? I don't know anything about this data base. > >Thanks >Ana > >______________________________________________ >R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide >http://www.R-project.org/posting-guide.html >and provide commented, minimal, self-contained, reproducible code.-- Sent from my phone. Please excuse my brevity.
Ms Marija, Would you happen to know which program created it? If not, you can try the Unix file command, if you have access to that. -- H [[alternative HTML version deleted]]
On Fri, 31 Jan 2020 17:02:16 -0600 Ana Marija <sokovic.anamarija at 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
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 at gmail.com> wrote:> On Fri, 31 Jan 2020 17:02:16 -0600 > Ana Marija <sokovic.anamarija at 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]]