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
