title: Accessing SQLite Database in R
body: <p>I want to access and manipulate a large data set in R. Since it's a large CSV file (~ 0.5 GB), I plan to import it<br>
  to SQLite and then access it from R. I know the <code>sqldf</code> and <code>RSQLite</code> packages can do this but I went 
  over their manuals and they are not helpful. Being a newbie to SQL doesn't help either.</p>
  
  <p>I want to know do I have to set the R directory to SQLite's and then go from there? How do I read in the database in R then?
  Heck, if you know how to access the DB from R without using SQL, please tell me.</p>
  
  <p>Thanks! </p>