title: How to use SQLite data in R without loading data
body: <p>I am using <code>R Studio</code> for some data analysis. I have a 500MB <code>.csv</code> 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 - </p>
  
  <blockquote>
    <p>Error: cannot allocate vector of size 9.5MB </p>
  </blockquote>
  
  <p>So, to save space, I decided to use <code>SQLite</code>. 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. </p>