[gentoo-user] R +which database ?

[James]

Howdy,


I'm experimenting with R. It seems easy, as I used SAS some decades ago.
Rstudio is a very, very cool interface.


So to build up some datasets using R and then using R to save them
into a dataset for simple web page tabular representation, would
it be a good idea to use sqlite, first to prototype the R code. What database
has anyone use with R?


Last, after some experimentation and I want to build something, large
and permanent, I really want to end up with a postgresql solution, before
moving to a 'Big Data' dataset solution. I figure learning some tricks
with sqlite, which allows simple browser viewing and debugging, then
postgresql are both useful things to know, before trying to use/test
one of the 'sql_ish' big data engines.

Discussion and suggestions are warmly received.


James