ACID in SQLite vs Couchbase

[brodycj]

Interesting article: https://blog.couchbase.com/acid-properties-couchbase-part-1/

In comparison, SQLite is fully ACID compliant, see this: https://www.sqlite.org/transactional.html

From the article on the Couchbase blog, it seems like Couchbase favors speed over durability, at least by default configuration. In contrast, SQLite is designed to be fully durable from the beginning.

All versions of the SQLite plugin that I am actively maintaining are using extra-durable SQLITE_DEFAULT_SYNCHRONOUS=3 build-time setting to be extra robust against potential corruption effects in case of a crash ref:

• https://www.sqlite.org/pragma.html#pragma_synchronous
• EXTRA DURABLE build setting to improve robustness against corruption cordova-sqlite-storage#736
• cordova-sqlite-storage-help issue Dealing with possible database corruption #34 - dealing with possible database corruption

additional reference:

• issue Document transactional (ACID) characteristics on Android & other platforms #20 - document transactional (ACID) characteristics on Android & other platforms

P.S. Ionic now seems to give some kind of an "offline storage" offering ref:

• https://ionicframework.com/offline-storage
• https://ionicframework.com/docs/enterprise/offline-storage - this page is linked by an "Ionic Native" page here: https://ionicframework.com/docs/enterprise
• https://ionicframework.com/resources/webinars/offline-storage-build-secure-offline-first-apps - came from an Ionic newsletter

Reading through https://ionicframework.com/docs/enterprise/offline-storage I found mention of CRUD and Couchbase Lite but no mention of ACID.

Adding another Ionic reference:

• https://itnext.io/make-offline-capable-ionic-apps-with-cached-observables-12d79a3a1e75 - looks nice from API perspective, not clear to me how the data is stored