fobo66’s articles about coding stuff
Android SQLite savepoints: nested transactions and workaround
Hello! In this article I’ll show one small trick with SQLite savepoints and my story how I’ve found this trick. Google claims that Android fully supports SQLite database engine. But the code that framework provides to us sometimes isn’t implemented well, so we cannot use some SQLite features and forced to search for workarounds. One of the features that doesn’t work as expected is savepoint. In short, it’s a tag in SQLite’s operations journal that can mark some important point in operations history to fall back to it if something was wrong....