title: How to connect to a remote sqlite database in r
body: <p>I am not familiar SQLite. So I wonder if I can fetch SQLite data from a remote server?</p>
  
  <p>I know I can do this quite easily with MySQL data,</p>
  
  <pre><code># Load package.
  library("RMySQL")
  
  # MySQL connection.
  DB &lt;- dbConnect(MySQL(), user="root", password="xxx", host="127.0.0.1", db="xxxx")
  
  # Select data from a table.
  data = dbGetQuery(DB, "SELECT * FROM article")
  </code></pre>
  
  <p>But for SQLite, it seems that it requires a path,</p>
  
  <pre><code># Load package.
  library("RSQLite")
  
  # Connect to the sqlite file.
  DB &lt;- dbConnect(SQLite(), dbname = "C:/SQLite/xxxx.sqlite")
  </code></pre>
  
  <p>How can I know and obtain the path of a remote server then? Can I do this below?</p>
  
  <pre><code>http://mywebsite-name.com/sqlite/xxxx.sqlite
  </code></pre>