Revision history [back]

There are multiple ways to create a backup of data from a SQLite database in React Native for Android, but one possible method is as follows:

1. Install the SQLite plugin for React Native using the following command:

npm install --save react-native-sqlite-storage

1. Initialize the SQLite database and create a table for the data using the following code:

import SQLite from 'react-native-sqlite-storage';

const db = SQLite.openDatabase({
  name: 'mydb.db',
  location: 'default',
});

db.transaction(function(txn) {
  txn.executeSql(
    'CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, value REAL)'
  );
});

1. Define a function to export the data from the database as a JSON object using the following code:

function exportData() {
  return new Promise((resolve, reject) => {
    db.transaction(function(txn) {
      txn.executeSql('SELECT * FROM mytable ORDER BY id ASC', [], function(
        tx,
        results
      ) {
        const rows = results.rows.raw(); // Convert to plain JavaScript object
        resolve(rows);
      });
    });
  });
}

1. Call the exportData() function and save the result to a file using the following code:

import { writeFile } from 'react-native-fs';

const data = await exportData();
const jsonString = JSON.stringify(data);
const filePath = '/sdcard/mybackup.json'; // Choose a location to save the file
await writeFile(filePath, jsonString, 'utf8');

Note: The writeFile() function requires the react-native-fs plugin to be installed and the app to have the necessary permissions to access the file system. Also, make sure to choose a secure location to save the backup file and protect it with encryption or other security measures if needed.