Make natively compatible with Capacitor

[jpike88]

I've been migrating to Capacitor from Cordova, this plugin is the only one I am unable to have a capacitor-equivalent for. The reason is that I am relying on pouchdb-adapter-cordova-sqlite, which means I can't use something like https://github.com/capacitor-community/sqlite as no pouchdb adapter exists for it.

What needs to be done to convert this library forwards for a capacitor project, without the need for Cordova to be installed?

[jpike88]

@brodybits i know this library isn't something frequently maintained, but can I ask for your input on roughly how difficult you think this may be? I'm considering forking it

[mirko77]

See https://github.com/capacitor-community/sqlite/blob/master/docs/MigratingCordovaDatabases.md

[jpike88]

Thanks... just need to figure out how to get the rest of the way there with pouchdb-adapter-cordova-sqlite

[brody4hire]

Thanks & apologies ... see ^^^ https://github.com/capacitor-community/sqlite/blob/master/docs/MigratingCordovaDatabases.md

I think this DOES need to be documented, considering this as a documentation bug for now.

[jpike88]

After some consideration, i have opted to stick with this library instead over capacitor-community/sqlite... two main reasons.

• This library uses the HTML5/Draft WebSQL API, and even thought that's deprecated, it's a standard. And I think it's better to stick to A standard, not make up yet another one, especially in the world of hybrid development.
• It's a hell of a lot easier to get this one to be 100% capacitor friendly, than to reimplement a pouchdb plugin for capacitor-community/sqlite

Looking forward to its future! In meantime, I'll continue to watch this issue.

[jpike88]

Actually, because I only use ios for this plugin, I will make my own capacitor native plugin that supports only ios to start.

[jpike88]

I have forked successfully a working version for capacitor (iOS only for now as I just use it for iOS)

https://github.com/jpike88/capacitor-sqlite-storage

and have published to capacitor-sqlite-storage on npm