expo-sqlite

import { openDatabase, SQLiteDatabase } from 'expo-sqlite'; import React, { useState, useEffect } from 'react'; import { View, Text, Button, Alert, StyleSheet } from 'react-native'; const db: SQLiteDatabase = openDatabase('my_app_data.db'); export default function App() { const [items, setItems] = useState<string[]>([]); useEffect(() => { db.transaction(tx => { tx.executeSql( 'CREATE TABLE IF NOT EXISTS notes (id INTEGER PRIMARY KEY NOT NULL, text TEXT NOT NULL);', [], () => console.log('Table "notes" created or already exists.'), (_, error) => { console.error('Error creating table:', error); return true; // Indicate transaction should rollback on error } ); }, (error) => console.error('Transaction error:', error), () => { console.log('Database initialization complete.'); fetchNotes(); }); }, []); const addNote = async () => { const newNote = `Note ${Date.now()}`; db.transaction(tx => { tx.executeSql( 'INSERT INTO notes (text) VALUES (?);', [newNote], () => { Alert.alert('Success', `Added "${newNote}"`); fetchNotes(); }, (_, error) => { console.error('Error adding note:', error); return true; } ); }); }; const fetchNotes = () => { db.transaction(tx => { tx.executeSql( 'SELECT * FROM notes;', [], (_, { rows }) => { setItems(rows._array.map((item: any) => item.text)); }, (_, error) => { console.error('Error fetching notes:', error); return true; } ); }); }; return ( <View style={styles.container}> <Text style={styles.title}>SQLite Notes</Text> <Button title="Add New Note" onPress={addNote} /> <Button title="Refresh Notes" onPress={fetchNotes} /> <View style={styles.notesContainer}> {items.length === 0 ? <Text>No notes yet.</Text> : items.map((item, index) => ( <Text key={index} style={styles.noteItem}>- {item}</Text> ))} </View> </View> ); } const styles = StyleSheet.create({ container: { flex: 1, justifyContent: 'center', alignItems: 'center', paddingTop: 50 }, title: { fontSize: 24, marginBottom: 20 }, notesContainer: { marginTop: 20 }, noteItem: { marginVertical: 5 } });