Re: [R] How to parallelize a process called by a socket connection

2020-02-01 Thread Hervé Pagès
Seems like you've replied to an existing thread to ask a new question (your post gets buried deep inside the "How to extract or sort values from one column" thread in my Thunderbird). Unfortunately this means that a lot of people who might be able to help you will miss it. H. On 2/1/20 11:24

[R] How to parallelize a process called by a socket connection

2020-02-01 Thread James Spottiswoode
Hi R Experts, I’m using R version 3.4.3 running under Linux on an AWS EC2 instance. I have an R code listening on a port for a socket connection which passes incoming data to a function the results of which are then passed back to the calling machine. Here’s the function that listens for a so

Re: [R] how to read a database in R?

2020-02-01 Thread John Kane
What happens if you run "dbListTables(db) "? That is a warning not an error. I am a real novice with data bases so I may not be of much help but do you know where the db file came from? When I suggested the code above. i checked that ii worked on a sqlite file I had, and hoped that Ivan's miracul

Re: [R] how to read a database in R?

2020-02-01 Thread Ana Marija
Hi John, I tried it but this is what I got: > library(RSQLite) > filename <- "DGN-WB_0.5.db" > sqlite.driver <- dbDriver("SQLite") > db <- dbConnect(sqlite.driver, + dbname = filename) Warning message: Couldn't set synchronous mode: disk I/O error Use `synchronous` = NULL to turn

Re: [R] how to read a database in R?

2020-02-01 Thread John Kane
Hi Ana Stolen from https://gist.github.com/jwolfson/72bc7d7fd8d339955b38 I cannot remember if you will need to install any other packages besides RSQLite library(RSQLite) filename <- "your_db_file.db" sqlite.driver <- dbDriver("SQLite") db <- dbConnect(sqlite.driver, dbname = filen

Re: [R] how to read a database in R?

2020-02-01 Thread Ana Marija
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 wrote: > On Fri, 31 Jan 2020 17:02:16 -0600 > Ana Marija wrote: > > > I have a database DGN-WB_0.5.db is there is a way to explore i

Re: [R] how to read a database in R?

2020-02-01 Thread Ivan Krylov
On Fri, 31 Jan 2020 17:02:16 -0600 Ana Marija 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