Amplify DataStore compatibility with Expo SQLite instead of react-native-sqlite-storage

[pascalito007]

Before opening, please confirm:

• I have searched for duplicate or closed issues and discussions.
• I have read the guide for submitting bug reports.
• I have done my best to include a minimal, self-contained set of instructions for consistently reproducing the issue.

JavaScript Framework

React Native

Amplify APIs

DataStore

Amplify Version

v6

Amplify Categories

No response

Backend

None

Environment information

Need to install the following packages:
[email protected]
Ok to proceed? (y) 

  System:
    OS: macOS 15.2
    CPU: (16) x64 Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
    Memory: 4.12 GB / 16.00 GB
    Shell: 5.9 - /bin/zsh
  Binaries:
    Node: 20.11.1 - /usr/local/bin/node
    Yarn: 1.22.22 - ~/.yarn/bin/yarn
    npm: 10.2.4 - /usr/local/bin/npm
    bun: 1.1.30 - ~/.bun/bin/bun
    Watchman: 2024.09.30.00 - /usr/local/bin/watchman
  Browsers:
    Safari: 18.2
  npmPackages:
    @aws-amplify/datastore-storage-adapter: ^2.1.66 => 2.1.66 
    @aws-amplify/react-native: ^1.1.6 => 1.1.6 
    @azure/core-asynciterator-polyfill: ^1.0.2 => 1.0.2 
    @babel/core: ^7.25.2 => 7.26.0 
    @expo/vector-icons: ^14.0.2 => 14.0.4 
    @react-native-async-storage/async-storage: 1.23.1 => 1.23.1 
    @react-native-community/netinfo: 11.4.1 => 11.4.1 
    @react-navigation/bottom-tabs: ^7.0.0 => 7.2.0 
    @react-navigation/native: ^7.0.0 => 7.0.14 
    @types/jest: ^29.5.12 => 29.5.14 
    @types/react: ~18.3.12 => 18.3.18 
    @types/react-test-renderer: ^18.3.0 => 18.3.1 
    aws-amplify: ^6.11.0 => 6.11.0 
    aws-amplify/adapter-core:  undefined ()
    aws-amplify/analytics:  undefined ()
    aws-amplify/analytics/kinesis:  undefined ()
    aws-amplify/analytics/kinesis-firehose:  undefined ()
    aws-amplify/analytics/personalize:  undefined ()
    aws-amplify/analytics/pinpoint:  undefined ()
    aws-amplify/api:  undefined ()
    aws-amplify/api/server:  undefined ()
    aws-amplify/auth:  undefined ()
    aws-amplify/auth/cognito:  undefined ()
    aws-amplify/auth/cognito/server:  undefined ()
    aws-amplify/auth/enable-oauth-listener:  undefined ()
    aws-amplify/auth/server:  undefined ()
    aws-amplify/data:  undefined ()
    aws-amplify/data/server:  undefined ()
    aws-amplify/datastore:  undefined ()
    aws-amplify/in-app-messaging:  undefined ()
    aws-amplify/in-app-messaging/pinpoint:  undefined ()
    aws-amplify/push-notifications:  undefined ()
    aws-amplify/push-notifications/pinpoint:  undefined ()
    aws-amplify/storage:  undefined ()
    aws-amplify/storage/s3:  undefined ()
    aws-amplify/storage/s3/server:  undefined ()
    aws-amplify/storage/server:  undefined ()
    aws-amplify/utils:  undefined ()
    expo: ~52.0.20 => 52.0.21 
    expo-blur: ~14.0.1 => 14.0.1 
    expo-constants: ~17.0.3 => 17.0.3 
    expo-font: ~13.0.2 => 13.0.2 
    expo-haptics: ~14.0.0 => 14.0.0 
    expo-linking: ~7.0.3 => 7.0.3 
    expo-router: ~4.0.14 => 4.0.14 
    expo-splash-screen: ~0.29.18 => 0.29.18 
    expo-status-bar: ~2.0.0 => 2.0.0 
    expo-symbols: ~0.2.0 => 0.2.0 
    expo-system-ui: ~4.0.6 => 4.0.6 
    expo-web-browser: ~14.0.1 => 14.0.1 
    jest: ^29.2.1 => 29.7.0 
    jest-expo: ~52.0.2 => 52.0.2 
    react: 18.3.1 => 18.3.1 (19.0.0-rc-6230622a1a-20240610)
    react-dom: 18.3.1 => 18.3.1 (19.0.0-rc-6230622a1a-20240610)
    react-native: 0.76.5 => 0.76.5 
    react-native-gesture-handler: ~2.20.2 => 2.20.2 
    react-native-get-random-values: ~1.11.0 => 1.11.0 
    react-native-reanimated: ~3.16.1 => 3.16.5 
    react-native-safe-area-context: 4.12.0 => 4.12.0 
    react-native-screens: ~4.1.0 => 4.1.0 
    react-native-sqlite-storage: ^6.0.1 => 6.0.1 
    react-native-web: ~0.19.13 => 0.19.13 
    react-native-webview: 13.12.5 => 13.12.5 
    react-test-renderer: 18.3.1 => 18.3.1 
    typescript: ^5.3.3 => 5.7.2 
  npmGlobalPackages:
    @angular/cli: 14.2.9
    @aws-amplify/cli: 12.3.0
    @ionic/cli: 6.20.1
    corepack: 0.23.0
    create-expo-app: 3.1.1
    create-react-app: 3.4.1
    csv-to-firestore: 1.0.0
    csvtojson: 2.0.10
    eas-cli: 12.6.2
    firebase-import: 2.2.0
    firebase-tools: 8.12.1
    ionic: 5.4.16
    n: 7.1.0
    netlify-cli: 10.7.1
    npm-check-updates: 16.14.20
    npm: 10.2.4
    react-native-cli: 2.0.1
    react-native: 0.71.8
    serve: 11.3.2
    serverless: 3.22.0
    ts-node: 10.9.1
    yarn: 1.22.19

Describe the bug

When following the documentation available here the command line make use of react-native-sqlite-storage wich is Unmaintained. The doc suggest to make use of Expo SQLite adapter but it is not working because of a known issue available here and opened since Jan 5 .
Please make React native expo DataStore compatible with Expo SQLite and remove react-native-sqlite-storage

Thanks

Expected behavior

Amplify JS react native expo project that use DataStore for offline purpose:

• Should be compatible with Expo SQLite
• Remove react-native-sqlite-storage

Reproduction steps

1. Create new expo project
2. configure amplify with a backend
3. follow this doc to integrate DataStore
4. Make use of Expo SQLite Adapter
5. The project is broken and the offline not works

Code Snippet

Log output

N/A

aws-exports.js

No response

Manual configuration

No response

Additional configuration

No response

Mobile Device

No response

Mobile Operating System

No response

Mobile Browser

No response

Mobile Browser Version

No response

Additional information and screenshots

No response