improve API - redesign - IN PROGRESS

[jacobg]

Update from @brodybits: redesign with preview now available is now discussed in: brody4hire/ask-me-anything#3

---

This issue is to initiate a general discussion about improving the plugin API beyond WebSql. Some potential goals of a new API would be:

• cut loose the baggage of the deprecated, and soon-to-be defunct WebSql API standard
• more control over transactions (db.transaction() is very limited)
• more fluent, less opionated, and easier-to-understand
• promise based
• multiple connections (concurrency) - separate issue to be created on that

A more general description of the purpose might be to: create a core transport and connectivity layer from the web view to sqlite, with all the expressivity that sql offers, in an intuitive api, and using modern javascript tools, such as promises and typescript.

Perhaps this might need to become a new plugin altogether?

For anyone also interested in a new API, please add your feedback and +1's, in order to let gauge demand.

@brodybits

[brody4hire]

Thanks @jacobg, I definitely want to look into this. May be related to #548 (possible redesign).

[brody4hire]

In case the redesign (#548) comes with a new API, the new API would likely be pretty simple and low-level. I would very strongly favor keeping the fluent API in higher-level JavaScript libraries, outside the Cordova plugin, that supports use in both Cordova and web browser.

[brody4hire]

I would also like to clarify that I would likely need an investment in order to justify the several months of time that would be needed for this work. As already communicated in private, I would be looking for a certain level of investment (keeping discussion private for now) to justify this work at this point. I would be happy to consider multiple investors, with a minimum investment of 20% each.

[brody4hire]

FYI I have already started the redesign based on Android-sqlite-evcore-native-driver-free, more details and maybe some updated pricing should be coming soon.