How to enable the sqliteConnection for PWA?

[nidhikachhawa24]

Scenario:

We are using eJaaduiPitara as a PWA. We want the local storage feature also, like create pitara, create playlist and list of recently Viewed contents, on the web app.

I checked that this connection of initialising the DB connection is not working:

this.sqlitePlugin = CapacitorSQLite;
this.sqliteConnection = new SQLiteConnection(this.sqlitePlugin);

How can we enable this DB connection for web application?
How can we generalise so that this can work for android as well as web application also?

cc: @swayangjit @kameshbhr

[swayangjit]

@nidhikachhawa24 As of now we are supporting only app and we haven't tested the browser support as capacitor SQLITE has browser support you can check this plugin and let us know if you are facing any difficulties.

[kameshbhr]

How can we generalise so that this can work for android as well as web application also?

Generalization may not be required as they are two different apps. You can possibly go with a different approach all together.
Mobile app can use file storage as it would have access to it, whereas web app would only have access to browser cache, not the device filesystem.