package.json

{
  "name": "database",
  "version": "1.0.0",
  "description": "database",
  "main": "main.js",
  "scripts": {
    "start": "electron .",
    "package-mac": "electron-packager . --overwrite --platform=darwin --arch=x64 --icon=assets/icons/icon.png --prune=true --out=release-builds",
    "package-win": "electron-packager . database --overwrite --asar=true --platform=win32 --arch=ia32 --icon=assets/icons/store.ico --prune=true --out=release-builds --version-string.CompanyName=CE --version-string.FileDescription=CE --version-string.ProductName=\"ShoppingList\"",
    "package-linux": "electron-packager . database --overwrite --asar=true --platform=linux --arch=x64 --icon=assets/icons/icon.png --prune=true --out=release-builds"
  },
  "author": "Gordon Chan",
  "license": "ISC",
  "devDependencies": {
    "electron": "^5.0.1",
    "electron-packager": "^13.1.1"
  },
  "dependencies": {
    "sql.js": "^0.3.2"
  }
}

db.js

  var sql = require('./node_modules/sql.js/js/sql-debug.js');
  var fs = require("fs");
  //Ditto, path module
  var path = require('path');

  try {
      var filebuffer = fs.readFileSync(path.join(__dirname, 'filename.sqlite'));
  } catch (e) {
      console.log(e);
  }

  if (filebuffer != null) {
      var db = new SQL.Database(filebuffer);
  } else {
      var db = new SQL.Database();
  }

  try {
      db.run("CREATE TABLE lorem (info INT)");
  } catch (e) {
      console.log(e);
  }

  for (var i = 0; i < 10; i++) {
      db.run("INSERT INTO lorem VALUES (" + i + ")");
  }

  db.each("SELECT * FROM lorem", function(row) {
      console.log(row.info + " is an integer!");
  });

  try {
      fs.unlinkSync(path.join(__dirname, 'filename.sqlite'));
  } catch (e) {
      console.log("Unable to delete file; Exception: " + e);
  }
  fs.writeFileSync("filename.sqlite", new Buffer(db.export()));

main.js

'use strict';
const electron = require('electron');
const app = electron.app;

// prevent window being garbage collected
let mainWindow;

function onClosed() {
	// dereference the window
	// for multiple windows store them in an array
	mainWindow = null;
}

function createMainWindow() {
	const win = new electron.BrowserWindow({
		width: 1750,
		height: 950
	});

	win.loadURL(`file://${__dirname}/index.html`);
	win.on('closed', onClosed);

	return win;
}

app.on('window-all-closed', () => {
	if (process.platform !== 'darwin') {
		app.quit();
	}
});

app.on('activate', () => {
	if (!mainWindow) {
		mainWindow = createMainWindow();
	}
});

app.on('ready', () => {
	mainWindow = createMainWindow();
	mainWindow.openDevTools();
});

package.json of test_electron_sqljs