SQLite database in JavaScript locally

In my SQLite code, I am using three JavaScript files for controlling SQLite, one for debugging purpose, one for executing queries, and another one for initializing the database and create basic tables.

debug.js
startup.js
query.js

The reference URL is http://allinworld99.blogspot.in/2016/04/sqlite-first-setup.html

File startup.js

var CreateTb1 = "CREATE TABLE IF NOT EXISTS tbl1(ID INTEGER PRIMARY KEY AUTOINCREMENT, CreatedDate TEXT,LastModifiedDate TEXT, Name TEXT)";
var CreateTb2 = "CREATE TABLE IF NOT EXISTS tbl2(ID INTEGER PRIMARY KEY AUTOINCREMENT, CreatedDate TEXT,LastModifiedDate TEXT,Mark INTEGER)";

var DefaultInsert = "INSERT INTO tbl1(CreatedDate,Name) select '" + new Date() + "','Merbin Joe'  WHERE NOT EXISTS(select * from tbl1)";

var db = openDatabase("TestDB", "1.0", "Testing Purpose", 200000); // Open SQLite database

$(window).load(function()
{
  initDatabase();
});

function createTable() // Function for Create Table in SQLite.
{

  db.transaction(function(tx)
  {
    tx.executeSql(CreateTb1, [], tblonsucc, tblonError);
    tx.executeSql(CreateTb2, [], tblonsucc, tblonError);

    insertquery(DefaultSettingInsert, defaultsuccess);

  }, tranonError, tranonSucc);
}

function initDatabase() // Function call when the page is ready
{
  try
  {
    if (!window.openDatabase) // Check browser is supported SQLite or not
    {
      alert('Databases are not supported in your device');
    }
    else
    {
      createTable(); // If supported then call the function
                     // for creating a table in SQLite
    }
  }
  catch (e)
  {
    if (e == 2)
    {
      // Version number mismatch
      console.log("Invalid database version.");
    }
    else
    {
      console.log("Unknown error " + e + ".");
    }
    return;
  }
}

File debug.js

function tblonsucc()
{
  console.info("Your table created successfully");
}

function tblonError()
{
  console.error("Error while creating the tables");
}

function tranonError(err)
{
  console.error("Error processing SQL: " + err.code);
}

function tranonSucc()
{
  console.info("Transaction Success");
}

File query.js

function insertquery(query, succ_fun)
{
  db.transaction(function(tx)
  {
    tx.executeSql(query, [], eval(succ_fun), insertonError);
  });
}

function deletedata(query, succ_fun)
{
  db.transaction(function(tx)
  {
    tx.executeSql(query, [], eval(succ_fun), deleteonError);
  });
}

function updatedata(query, succ_fun)
{
  db.transaction(function(tx)
  {
    tx.executeSql(query, [], eval(succ_fun), updateonError);
  });
}

function selectitems(query, succ_fun) // Function for retrieving data
                                      // from the database. Display
                                      // records as list
{
  db.transaction(function(tx)
  {
    tx.executeSql(query, [], function(tx, result)
    {
      eval(succ_fun)(result.rows);
    });
  });
}

myDatabase and myDatabase.sqlite are two different filenames. Update your code to reference the correct filename with an extension.

SQLite does automatically create a new empty database if you try to open a database that doesn't exist.

I had the same problem, and I found out that you cannot use your SQLite database like this.

I used Google Chrome, and I found out that Chrome stores databases in "C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\databases".

There is a Databases.db that Chrome uses for managing databases.

If you want to use your database, you should add a record into Databases.db and put your file in "file__0" directory and rename it (your database file) to the id that is assigned to that record.