[R] SQL and R

[Ben Bolker]

   Others may know more than I do, but roughly:

   (1) SQL provides access to relational database management systems 
that are much more robust and handle large-scale data;
   (2) methods based on SQL will often handle data that are too large to 
fit in memory

   R complements SQL by providing a much  larger set of statistical 
tools. The typical workflow would be that you would use SQL queries to 
do the extraction, subsetting, and simple manipulation of data to reduce 
the data to a manageable size for analysis on a single machine, then use 
R to analyze it.

   See also various packages (arrow, dbplyr) that provide alternative 
big-data workflows.

   cheers
    Ben Bolker


On 12/11/24 08:16, akshay kulkarni wrote:
> dear Members,
>                              I have recently started studying SQL and MySQL. My question is, what exactly is SQL used for? That is, whatever can be done by SQL, like subsetting and filtering of data sets, can also be done by R. What's, then, the advantage of SQL?  It is OK if you tag this question as offtopic, but I could'nt find any info on the web. Can you please refer me to some online resources that shed some light on this? Finally, how does SQL complement R? Are both dependent?
> 
> THanking you,
> Yours sincerely,
> AKSHAY M KULKARNI
> 
> [https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>  Virus-free.www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide https://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

-- 
Dr. Benjamin Bolker
Professor, Mathematics & Statistics and Biology, McMaster University
Director, School of Computational Science and Engineering
* E-mail is sent at my convenience; I don't expect replies outside of 
working hours.