In the old Web SQL interface, if you returned true from the transaction error callback it would rollback any database changes made within the transaction. Is this how it works for the Expo SQLite API?
1 Like
Hi, we just wrap the underlying sqlite API on the respective platforms, so whatever that library does is probably what we do. cc @nikki
1 Like
(responded on Slack too)
Our implementation is based on https://github.com/craftzdog/react-native-sqlite-2 and follows the same behavior as that. Probably makes sense to just try in a simple test project.
1 Like
The problem with the library that is put on top is the transaction management. Instead of using SQLite to manage transactions it tries to manage it using the node-websql (incorrectly as noted in Transactions auto-close when queuing microtasks between executeSql() calls · Issue #46 · nolanlawson/node-websql (github.com))