I have now read through several posts about SQLite, WASM, Cordova plugin, …
I wonder if it is possible at all to develop a Desktop app (using Electron) that accesses a SQLite database file (e. g. “customer.db” or so) that is located somewhere on a Windows or Mac computer…
I simply do not find a way…
Or lets say I have an existing SQLite db file (“customer.db”) with thousands of records that I would like to use with a web app. Where to copy / store it?
If you’re running using Electron, you have more choices than as a web app. If you google 'electron sqlite library` you’ll get more info.
As a web app, you will not be able to open an SQLite db file directly. If it was a .txt file, you could open it (with some restrictions) and import using SQLImport().
Did not have the time to google “electron sqlite library” and chk the search results.
But I found one of your sample projects that seems to work as a good starting point:
“Northwind”!!!
Within the project folder there is a file named “Northwind.db” (SQLite db file).
This file can be accessed - no matter if I start the project in Desktop Browser or Desktop App using Electron!
If I make changes to the database file using some external tool (DB Browser for SQLite or so) and restart the project (Desktop Browser or Desktop App using Electron) all changes take effect to the data shown in the data grid!
That’s all I want.
Will experiment with it the next days and report my results here…
