Electron desktop app that I am writing is required to be offline all the time. It is not offline first - it is entirely offline app. It should be able to save transactions (rows to the table) and show them again. No need for joins with other tables too. Table data has to be stored within the app. Application has to start from pre-filled DB data.
I know about sqlite3 which is giving troubles when built for windows.
With PouchDB, I couldn't find any good tutorial to start it with pre-filled data from a file with in the App.
Any other suggestions (preferrable JS based DB) or pointers will be highly appreciated?
In case of Windows, you can make use of the MS SQL Server compact. Often that can be easily used if you use Visual Studio IDE for building your electron App. That being said, it's easy to Connect sqlite database in Node.JS .
I'd recommend you to try couchdb too. It's also compact. And it should be easy to Connect CouchDB in Node.JS .
You can also use rethinkDB.
i'm looking for the same thing, an offline app, did you manage to accomplish that somehow ?
Atul Sharma
Full Stack Developer | Cloud Native Applications
No doubt, setting up sqlite is a pain.
Use this boilerplate to get it done quickly.
github.com/sjmelia/electron-boilerplate-sqlite
Clone the Git :
git clone https://github.com/sjmelia/electron-boilerplate-sqliteInstall :
npm install npm start