Is MySql installed on SageMathCloud?

[Peter Luschny]

Hi all,

on https://www.tutorialspoint.com/r/r_database.htm I read:

"R can connect easily to many relational databases like MySql ..., 

R has a built-in package named "RMySQL" which provides native 

connectivity with MySql database."

It is this context which might be interesting for me.

Peter

[Harald Schilly]

Hello, we don't run any database instances on the back-end, so you
would have to run it inside a project on your own. That's usually not
really exciting and we rather recommend file-based databases like
SQLite3. There is a wrapper package for SQLite3 in R, would this fit
your needs?

-- harald

> --
> You received this message because you are subscribed to the Google Groups
> "sage-cloud" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sage-cloud+...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sage-cloud/bdacbc77-e0e8-43fe-ac72-1cc9978ecfa7%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Peter Luschny]

SQLite3. There is a wrapper package for SQLite3 in R, would this fit
your needs?

I would use it primarily to learn R and try out prototypes so I think it would certainly suffice.

Peter

 

[Harald Schilly]

Ok, sounds good.

And FYI and whoever is reading this: we have two R environments. The
one inside of SageMath (in Jupyter it's the "R (SageMath)" kernel,
named "ir-sage") and the "official" R from the project "R (R-Project)"
kernel, named "ir". On the command-line, there is "R" vs "R-sage" and
"Rscript" vs "Rscript-sage".

The R-Project R is more recent and has more packages installed
(including the mentioned RSQLite), so I suggest to use that one by
default.

-- harald

[Hal Snyder]

I would use it primarily to learn R and try out prototypes so I think it would certainly suffice.

Peter

 

SMC is an excellent platform for learning R. You can use:

- sage worksheets with %r mode

- jupyter notebooks with R kernel

- R Markdown with .Rmd

- and most recently Sweave with .Rnw files.

I've used SMC with several online courses in R, including The Analytics Edge from MIT (https://www.edx.org/course/analytics-edge-mitx-15-071x-2) and several courses in the Data Science series from Johns Hopkins (https://www.coursera.org/specializations/jhu-data-science).

Hal

[Peter Luschny]

The R-Project R is more recent and has more packages installed
(including the mentioned RSQLite), so I suggest to use that one by
default.

Thanks Harald! 

[Peter Luschny]

I've used SMC with several online courses in R, including The Analytics Edge from MIT (https://www.edx.org/course/analytics-edge-mitx-15-071x-2) and several courses in the Data Science series from Johns Hopkins (https://www.coursera.org/specializations/jhu-data-science).

Thanks Hal!

[kcrisman]

- and most recently Sweave with .Rnw files.

You mean knitr :) since SMC ads have been touting that lately - but agreed! 

[kcrisman]

On Friday, January 13, 2017 at 11:47:06 AM UTC-5, kcrisman wrote:

- and most recently Sweave with .Rnw files.

You mean knitr :) since SMC ads have been touting that lately - but agreed! 

(And to be clear, I didn't me YOU but rather "one can upgrade to", nothing personal intended.)