Using local database after electron build

[j-nguyen]

Hey all. I'm currently using Electron 5.0.1, Vue 2.6, and The Electron Builder v1.3.1. I'm having trouble getting SQLite to work when I'm trying to build a MacOS or Windows app.

Here's what my vue.config.js looks like:

module.exports = {
  css: {
    loaderOptions: {
      sass: {
        data: `
          @import "@/styles/main.scss";
        `,
      },
    },
  },
  configureWebpack: {
    externals: {
      sequelize: "require('sequelize')",
    },
  },
  pluginOptions: {
    electronBuilder: {
      externals: ['sequelize'],
      builderOptions: {
        extraResources: ['src/data.db'],
      },
    }
  },
};

and Here's how I connect via my db:

import Sequelize from 'sequelize';
import Component from '@/models/component';
import Element from '@/models/element';
import Kiosk from '@/models/kiosk';
import Page from '@/models/page';
import path from 'path';

const isBuild = process.env.NODE_ENV === 'production';
const pathToDbFile = path.join( // eslint-disable-next-line
  (isBuild ? __dirname : __static),
  (isBuild ? '../../' : ''),
  '../src/data.db',
);

// setup the connection to make sure it works
const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: pathToDbFile,
  logging: (process.env.NODE_ENV !== 'production') ? console.log : false,
  define: {
    timestamps: false,
    underscored: true,
  },
});

const db = {};

// test for the connection
if (process.env.NODE_ENV !== 'production') {
  sequelize.authenticate()
    .then(() => {
      console.log('Connection has been established.');
    })
    .catch(console.error);
}

db.Component = Component.init(sequelize);
db.Element = Element.init(sequelize);
db.Kiosk = Kiosk.init(sequelize);
db.Page = Page.init(sequelize);

Object.keys(db).forEach((modelName) => {
  if (db[modelName].associate) db[modelName].associate(db);
});

db.Sequelize = Sequelize;
db.sequelize = sequelize;

export default db;

Any idea what's going on?

[nklayman]

I don't see any error when I run it myself. Please send me a demo repo that has the error.

[j-nguyen]

Hello, @nklayman.

Here's the repo:
https://github.com/j-nguyen/demo_vue_electron_sqlite

Here's some context. When I use npm run electron:build to generate a MacOS binrary, or Windows app, this is the error I receive:

[nklayman]

Use this:

const pathToDbFile = path.join(
  // eslint-disable-next-line
  isBuild ? __dirname : __static,
  '../src/data.db',
);

not sure why the path changed, but this works now.

[j-nguyen]

@nklayman

Thank you! This works, but I have another issue with sequelize and SQLite. I don't have a table named fs, but it keeps yelling at me that there is no such table for it. This hasn't happened to me when doing electron:serve, so I'm a bit confused now.

[j-nguyen]

Oh, nevermind. Got it cleared up. Just had to declare the modelName on sequelize. Thank you for your help!

[techuila]

@j-nguyen Have you encountered this error?

Please install sqlite3 package manually

[ihewro]

@j-nguyen Have you encountered this error?

Please install sqlite3 package manually

externals: ['sequelize'] in the vue.config.js works for me