Hi Simon, I'm using Couchbase Lite actually, not Couchbase server. Couchbase Lite 1.4 to be specific. Couchbase Lite 2.0 is still under development and it does in fact use SQLite under the hood as does Couchbase Lite 1.4. They had worked on using ForestDB, but I think they've abandoned that for their Couchbase Lite 2.0 version.
I've tried calling pragma fullfsync=1 just after the database file was opened, but I still had the same problem with corruption after a power failure. There's a big discussion I've had with the Couchbase Lite developers here on their Github issues: https://github.com/couchbase/couchbase-lite-ios/issues/1482 (newer posts are at the bottom) On Tue, Apr 18, 2017 at 2:52 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 18 Apr 2017, at 6:01am, Brendan Duddridge <brend...@gmail.com> wrote: > > > Perhaps the only think I can think of that I'm doing that may be > unorthodox > > is by storing the SQLite files inside a macOS package. But at the unix > > layer that's really just a directory, so I don't know how that could > cause > > a problem. Unless macOS treats the package in a way differently than a > > normal folder and is causing things to get moved around or written when a > > power failure occurs. > > You should be safe storing a SQLite database inside a package. As you > write, a package is really just a folder with one extra bit set. > > Any demonstration code which uses the SQLite API directly we can attempt > to debug. > > If the problem you need solving is actually with Couchbase, you can solve > it by upgrading to any version from 2.0 onwards. Since that no longer uses > SQLite, SQLite database corruption can no longer be a problem. Current > versions of Couchbase no longer use SQLite for a persistence layer and > Couchbase developers are unlikely to assist with any problem you find with > such an old version. > > If your program demonstrating the problem has access to the SQLite > database solely via libsqlcrypt.a, can you explain what you’re using it for > ? Is your database actually direct access to a Lotus Notes file ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
