Re: [R] SQL and R

2024-12-12 Thread akshay kulkarni
Dear Gabor, THanks a lot THanking you, Yours sincerely, AKSHAY M KULKARNI From: Gabor Grothendieck Sent: Thursday, December 12, 2024 7:39 PM To: akshay kulkarni Cc: R help Mailing list Subject: Re: [R] SQL and R The advantages of SQL

Re: [R] SQL and R

2024-12-12 Thread Gabor Grothendieck
The advantages of SQL are that - it can be used from many languages so if you know SQL you can easily move that part of your code to python, say, and visa versa - it is widely used - it can handle data stored outside of R and possibly otherwise too large for R - some SQL databases support multiple

Re: [R] SQL and R

2024-12-12 Thread akshay kulkarni
From: R-help on behalf of Eberhard W Lisse Sent: Thursday, December 12, 2024 2:53 AM To: r-help@r-project.org Subject: Re: [R] SQL and R Looks like an assignment question. If so, do your homework yourself. Google is your friend el On 2024-12-11 15:16, akshay kulkarni wrote: > dear Memb

Re: [R] SQL and R

2024-12-12 Thread akshay kulkarni
...@gmail.com ; Ben Bolker Subject: Re: [R] SQL and R And to answer the dependency question. Neither is dependent on the other. But both can be complimentary. If you consider that SQL*may* be a route to accessing your data (if it's in a database). And R *may* be a route to analysis of the

Re: [R] SQL and R

2024-12-12 Thread akshay kulkarni
imore, MD 21201-1524 Cell phone 443-418-5382 From: R-help on behalf of akshay kulkarni Sent: Wednesday, December 11, 2024 8:16 AM To: R help Mailing list Subject: [R] SQL and R dear Members, I have recently started studyin

Re: [R] SQL and R - tangential

2024-12-12 Thread akshay kulkarni
Dear JC, THanks . THanking you, Yours sincerely, AKSHAY M KULKARNI From: R-help on behalf of J C Nash Sent: Wednesday, December 11, 2024 10:27 PM To: r-help@r-project.org Subject: Re: [R] SQL and R - tangential My late friend Morven

Re: [R] SQL and R

2024-12-12 Thread akshay kulkarni
Dear Bert, THanks a lot From: Bert Gunter Sent: Wednesday, December 11, 2024 9:25 PM To: akshay kulkarni Cc: R help Mailing list Subject: Re: [R] SQL and R Just a slight technical note -- Ben gave you a good answer already, imo. The note is

Re: [R] SQL and R

2024-12-11 Thread Jeff Newmiller via R-help
Some people prefer SQL syntax. Also, SQL implementations are generally intrinsically linked with persistent disk storage, so it works straightforwardly with data sets larger than RAM. Finally, most implementations support shared access to the data from multiple clients. A long time ago in a com

Re: [R] SQL and R

2024-12-11 Thread CALUM POLWART
; 10 North Greene Street > <https://www.google.com/maps/search/10+North+Greene+Street?entry=gmail&source=g> > GRECC (BT/18/GR) > Baltimore, MD 21201-1524 > Cell phone 443-418-5382 > > > > > ________ > From: R-help on behalf

Re: [R] SQL and R

2024-12-11 Thread Sorkin, John
18/GR) Baltimore, MD 21201-1524 Cell phone 443-418-5382 From: R-help on behalf of akshay kulkarni Sent: Wednesday, December 11, 2024 8:16 AM To: R help Mailing list Subject: [R] SQL and R dear Members, I have recently started stu

Re: [R] SQL and R

2024-12-11 Thread Eberhard W Lisse
Looks like an assignment question. If so, do your homework yourself. Google is your friend el On 2024-12-11 15: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

Re: [R] SQL and R - tangential

2024-12-11 Thread avi.e.gross
8 AM To: r-help@r-project.org Subject: Re: [R] SQL and R - tangential My late friend Morven Gentleman, not long after he stepped down from being chair of Computer Science at Waterloo, said that it seemed computer scientists had to create a new computer language for every new problem they encounter

Re: [R] SQL and R - tangential

2024-12-11 Thread J C Nash
To: R help Mailing list Subject: [R] SQL and R 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&#x

Re: [R] SQL and R

2024-12-11 Thread avi.e.gross
sions of SQL have been tuned over decades ... -Original Message- From: R-help On Behalf Of akshay kulkarni Sent: Wednesday, December 11, 2024 8:17 AM To: R help Mailing list Subject: [R] SQL and R dear Members, I have recently started studying SQL and MySQ

Re: [R] SQL and R

2024-12-11 Thread Bert Gunter
Just a slight technical note -- Ben gave you a good answer already, imo. The note is: R is Turing complete, which mean that *anything* any language can do, R could be programmed to do also. The point is what can be done well in R and what can be done (often much) better with other tools, as Ben ex

Re: [R] SQL and R

2024-12-11 Thread 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 mu

[R] SQL and R

2024-12-11 Thread akshay kulkarni
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 ta