How to use SQLite data in R without loading data
===

I am using `R Studio` for some data analysis. I have a 500MB `.csv` file. System specs: i5 + 4GB RAM. If I load the file in R, it takes up some 1.5GB of my RAM and I don't have enough RAM left for other operations. It gives errors like - 

> Error: cannot allocate vector of size 9.5MB 

So, to save space, I decided to use `SQLite`. I stored my data in a SQLite database file. I want to know if there's a way I can do operations on the data without loading it in R. Using all those R functions directly on my SQLite database. 