DEV Community

Discussion on: A stable alternative to SQLite for offline desktop app?

View post

Replies for: You might not need asynchronicity if you use SQLite in WAL mode: You can also take a look at PRAGMA synchronous Thanks. I will try to build on to...

Collapse
 
rhymes profile image
rhymes •

Yeah I think SQLite is what you are looking for. Why do you need a Node server though? Can't you just access it from the desktop app?

Thread Thread
 
patarapolw profile image
Pacharapol Withayasakpunt • • Edited

I can use ipcMain/ipcRenderer for Electron as well, but

  • I want to avoid Electron, and use web server, which is much smaller instead. And, I don't have a very good experience with zserge/webview...
  • I want to enable user-defined CSS styling, which is much better supported in real web browser, or Electron; than perhaps Qt or JavaFX.
  • I want to app to be programmable, so I expose the API via REST + OpenAPI / Swagger.
  • I do fear a little about security on localhost. Perhaps I will use a token-based authentication.