-
Notifications
You must be signed in to change notification settings - Fork 1
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ACID in SQLite vs Couchbase #71
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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:additional reference:
P.S. Ionic now seems to give some kind of an "offline storage" offering ref:
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:
The text was updated successfully, but these errors were encountered: