How to use sqlite in my next.js with electron template project?

[liaodalin19903]

Summary

When I create SQLite db file in my electron-src/ directory, it does not sync to main/ directory in my next.js with electron project

I use next.js with electron template created a project,

the directory structure as below:

.
├── README.md
├── electron-src
│   ├── db/
│   ├── electron-next.d.ts
│   ├── index.ts
│   ├── ipc/
│   ├── preload.ts
│   └── tsconfig.json
├── main
│   ├── index.js
│   ├── ipc/
│   └── preload.js
├── next.config.js
...

I found the main/ is generated by electron-src/, and in the actual running process, the main process what goes into effect is main/ rather than electron-src/.

but now I want to use sqlite as data persistence database in my project, when I create db/proj.sqlite.db, it do not sync to the main/ directory, whether means I cannot use sqlite as the way?

---

and when I use the better-sqlite3 code to access sqlite db:

const db = require('better-sqlite3')('../../db/proj.sqlite.db', {});

console.log('db: ', db)

it will get error:

Uncaught Exception:
TypeError: Cannot open database because the directory does not exist
at new Database (/Users/john/Desktop/projects/test/vscode-layout-demo-01/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/database.js:65:9)
at Database (/Users/john/Desktop/projects/test/vscode-layout-demo-01/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/database.js:11:10)
at Object.<anonymous> (/Users/john/Desktop/projects/test/vscode-layout-demo-01/main/ipc/test/db.test.handlers.js:6:37)
at Module._compile (node:internal/modules/cjs/loader:1269:14)
at Module._extensions..js (node:internal/modules/cjs/loader:1324:10)
at Module.load (node:internal/modules/cjs/loader:1124:32)
at Module._load (node:internal/modules/cjs/loader:965:12)
at f._load (node:electron/js2c/asar_bundle:2:13377)
at Module.require (node:internal/modules/cjs/loader:1148:19)
at require (node:internal/modules/cjs/helpers:110:18)

Additional information

No response

Example

No response

[RohitLuthra19]

Is anyone working on this?