SQLite boilerplate and offline data persistence

[fairking]

I am trying to get sqlite working in my app and just thinking would be nice to have sqlite boilerplate in CLI in the same way as axios and i18n. So when you create a new project you can choose a sqlite option as well.

I am planning to use typeorm.
Here is a working example of it: https://github.com/jepiqueau/vue-typeorm-app

Other resources:
typeorm/typeorm#6854
nklayman/vue-cli-plugin-electron-builder#699 (comment)

I am not sure about the approach with electron, there maybe a better way by using https://capacitor-community.github.io/electron/docs/gettingstarted

Basic requirements:

• ability to use sqlite database in order to persist data locally on android/ios/desktop device,
• sqlite db file stored in file (not in browser storage, unless it is dev web browser mode),
• capacitor (android/ios) and electron (windows/linux) support,
• ...

What do you think guys?

[fairking]

No answer since then. Looks like nobody is using quasar framework for such type of applications :-(

[moksamedia]

I am looking into the same thing.

[moksamedia]

Did you get it to work?

[fairking]

Did you get it to work?

I switched to Maui, it was easier to me to get access to the backend api. Apart of that the ui framework is Quasar in webview and there is a communication between ui and backend in place. As a .net developer it was the shortest way to me to get there. If you are not familiar with .net and rather want to use js/ts for backend, I cannot help you.

[moksamedia]

Thanks. .NET is one of the few programming worlds I've never even dipped a toe in so I'll figure something else out.

…

On Wed, Jun 29, 2022, 8:45 AM fairking ***@***.***> wrote: Did you get it to work? I switched to Maui, it was easier to me to get access to the backend api. Apart of that the ui framework is Quasar in webview and there is a communication between ui and backend in place. As a .net developer it was the shortest way to me to get there. If you are not familiar with .net and rather want to use js/ts for backend, I cannot help you. — Reply to this email directly, view it on GitHub <#12460 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJ6N5YSVKFTGSWYZ2UMBK3VRRVSXANCNFSM5OKBC4JA> . You are receiving this because you commented.Message ID: ***@***.*** com>

[fairking]

Sorry mate, but writing the backend in js/ts is a nightmare to me. Have a look at Tauri if you need a strong backend but you don't want to use .net (maui). Otherwise java as the second solution.