Adapter feature question / request

[gabrielgrover]

Hello @craftzdog . My team has benefitted from your work for a long time. We appreciate your contributions to the react native community. I wanted to know if an adapter system with this library is possible? We aren't able to use op-sqlite and would like to stick with expo-sqlite. Happy to do the work myself. I wanted to know if you have a suggestion of where to start or even if this is possible. Thank you!

[ccatalani-modocu]

We have similar issue: we are using react-native-sqlite-2 + @craftzdog/pouchdb-adapter-websql-core and an update to op-sqlite does break existing installations. Now we are upgrading RN to 0.76.6, but websql is no longer working correctly. Queries for non existing pocuhdb documents do not return (disappearing in a black hole.. :-) ).
Our idea is to adapt pouchdb-adapter-react-native-sqlite latest version to work with react-native-sqlite-2 again: do you think, it's a feasible way?

[craftzdog]

sqlite database files are compatible between expo-sqlite, sqlite-2, and op-sqlite since they are just wrappers.
You can specify a path to load the existing database file.

import {
  IOS_LIBRARY_PATH, // Default iOS
  IOS_DOCUMENT_PATH,
  ANDROID_DATABASE_PATH, // Default Android
  ANDROID_FILES_PATH,
  ANDROID_EXTERNAL_FILES_PATH, // Android SD Card
  open,
} from '@op-engineering/op-sqlite';

const db = open({
  name: 'myDb',
  location: Platform.OS === 'ios' ? IOS_LIBRARY_PATH : ANDROID_DATABASE_PATH,
});

Learn more: https://op-engineering.github.io/op-sqlite/docs/configuration#absolute-paths

Currently, there is no way to specify a custom location in this adapter because PouchDB doesn't support specifying adapter options.
Maybe you can tweak the init function to make it possible:

https://github.com/craftzdog/pouchdb-adapter-react-native-sqlite/blob/master/src/index.ts

Another solution would be to move the existing db files to the default location of op-sqlite.

[ccatalani-modocu]

Many thanks for your reply, it's very helpful. 🙏