How can I use SQLite in my React Native app?

How can I use SQLite in my React Native app?

You can use the 'react-native-sqlite-storage' library to integrate SQLite into your React Native app. Would you like a code example?

Yes, please provide a code example.

Sure! First, install the library using npm or yarn:

npm install react-native-sqlite-storage

Then, you can create a database like this:

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

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

Would you like to know how to perform CRUD operations?

Yes, how do I perform CRUD operations?

To perform CRUD operations, you can use the following methods:

• Create: db.transaction(tx => { tx.executeSql('INSERT INTO table_name (column1) VALUES (?)', [value]); });
• Read: db.transaction(tx => { tx.executeSql('SELECT * FROM table_name', [], (tx, results) => { console.log(results.rows); }); });
• Update: db.transaction(tx => { tx.executeSql('UPDATE table_name SET column1 = ? WHERE id = ?', [newValue, id]); });
• Delete: db.transaction(tx => { tx.executeSql('DELETE FROM table_name WHERE id = ?', [id]); });

Let me know if you need more details!