React native sqlite optimised

import SQLite, { SQLiteDatabase, ResultSet } from 'react-native-sqlite-storage';

SQLite.DEBUG(true);
SQLite.enablePromise(true);

const database_name = "MyDatabase.db";
const database_version = "1.0";
const database_displayname = "My SQLite Database";
const database_size = 200000;

interface Item {
  id?: number;
  name: string;
  description: string;
  new_column?: string;
}

class DatabaseService {
  private async initDB(): Promise<SQLiteDatabase> {
    return SQLite.openDatabase(
      database_name,
      database_version,
      database_displayname,
      database_size
    );
  }

  private closeDatabase(db: SQLiteDatabase): void {
    db.close().catch(error => console.error(error));
  }

  async createTable(): Promise<void> {
    const db = await this.initDB();
    await db.executeSql(`
      CREATE TABLE IF NOT EXISTS items (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT,
        description TEXT
      )
    `);
    this.closeDatabase(db);
  }

  async addItem(item: Item): Promise<ResultSet> {
    const db = await this.initDB();
    const result = await db.executeSql('INSERT INTO items (name, description) VALUES (?, ?)', [item.name, item.description]);
    this.closeDatabase(db);
    return result[0];
  }

  async updateItem(id: number, item: Item): Promise<ResultSet> {
    const db = await this.initDB();
    const result = await db.executeSql('UPDATE items SET name = ?, description = ? WHERE id = ?', [item.name, item.description, id]);
    this.closeDatabase(db);
    return result[0];
  }

  async deleteItem(id: number): Promise<ResultSet> {
    const db = await this.initDB();
    const result = await db.executeSql('DELETE FROM items WHERE id = ?', [id]);
    this.closeDatabase(db);
    return result[0];
  }

  async getItems(): Promise<Item[]> {
    const db = await this.initDB();
    const [result] = await db.executeSql('SELECT * FROM items', []);
    this.closeDatabase(db);
    
    const items: Item[] = [];
    for (let i = 0; i < result.rows.length; i++) {
      items.push(result.rows.item(i));
    }
    return items;
  }

  async updateDatabaseVersion(newVersion: number): Promise<void> {
    const db = await this.initDB();
    const [result] = await db.executeSql('PRAGMA user_version');
    const currentVersion = result.rows.item(0).user_version;

    if (currentVersion < newVersion) {
      await db.executeSql('ALTER TABLE items ADD COLUMN new_column TEXT');
      await db.executeSql(`PRAGMA user_version = ${newVersion}`);
    }

    this.closeDatabase(db);
  }
}

export default new DatabaseService();

import React, { useEffect, useState } from 'react';
import { View, Text, Button } from 'react-native';
import DatabaseService from './DatabaseService';

interface Item {
  id: number;
  name: string;
  description: string;
  new_column?: string;
}

const App: React.FC = () => {
  const [items, setItems] = useState<Item[]>([]);

  useEffect(() => {
    (async () => {
      await DatabaseService.createTable();
      await DatabaseService.updateDatabaseVersion(2);
      await fetchItems();
    })();
  }, []);

  const fetchItems = async () => {
    const data = await DatabaseService.getItems();
    setItems(data);
  };

  const addItem = async () => {
    const newItem: Item = { name: 'New Item', description: 'Item Description' };
    await DatabaseService.addItem(newItem);
    await fetchItems();
  };

  const updateItem = async (id: number) => {
    const updatedItem: Item = { name: 'Updated Item', description: 'Updated Description' };
    await DatabaseService.updateItem(id, updatedItem);
    await fetchItems();
  };

  const deleteItem = async (id: number) => {
    await DatabaseService.deleteItem(id);
    await fetchItems();
  };

  return (
    <View>
      <Button title="Add Item" onPress={addItem} />
      {items.map(item => (
        <View key={item.id}>
          <Text>{item.name}</Text>
          <Text>{item.description}</Text>
          <Button title="Update" onPress={() => updateItem(item.id)} />
          <Button title="Delete" onPress={() => deleteItem(item.id)} />
        </View>
      ))}
    </View>
  );
};

export default App;