title: HTML5 Web SQL database file location in chrome
body: <p>I want to use HTML Web SQL for my next web application project, so I did a quick search to find a tutorial and wrote the following code:</p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html&gt;
  &lt;head&gt;
      &lt;meta charset="utf-8"&gt;
      &lt;title&gt;Web SQL Test&lt;/title&gt;
      &lt;script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"&gt;&lt;/script&gt;
      &lt;script type="text/javascript"&gt;
      $(function() {
          var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
          db.transaction(function (tx) {
             tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)');
             tx.executeSql('INSERT INTO LOGS (id, log) VALUES (1, "foobar")');
             tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, "logmsg")');
          });
          db.transaction(function (tx) {
             tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
             var len = results.rows.length, i;
             msg = "&lt;p&gt;Found rows: " + len + "&lt;/p&gt;";
             document.querySelector('#status').innerHTML +=  msg;
             for (i = 0; i &lt; len; i++){
                alert(results.rows.item(i).log );
             }
           }, null);
          });
      });
      &lt;/script&gt;
  &lt;/head&gt;
  &lt;body id="status"&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>I ran the code above in chrome via WAMP (<a href="http://localhost/web_sql.html" rel="noreferrer">http://localhost/web_sql.html</a>) and I can see the expected output in browser: <code>Found rows: 2</code></p>
  
  <p>Now I am trying to find the sqlite file that was created by this operation on my PC and after searching around, everyone is pointing to this particular folder for the db files: </p>
  
  <h3>C:\Users\USERNAME\AppData\Local\Google\Chrome\User Data\Default\databases</h3>
  
  <p>When I go to that location, it's empty.</p>
  
  <p>On other note, the database changes doesn't seems to be persisting. If I refresh the page, it still says <code>Found rows: 2</code> (surely it should say 4).</p>
  
  <p>Is this why I can't find the file locally on my PC?</p>