schema getting lost after a browser refresh

[Drashij]

Hi,

I am using AlaSQL in my Ionic Capacitor app for web-based SQL operations on IndexedDB. The tables are created correctly, and data is inserted in the expected format initially. However, after refreshing the browser, the schema appears to be lost, and while data continues to be inserted, it no longer follows the correct format. Tables are present but their schema is getting lost so when i am inserting after a browser refresh, the data is inserted as it is, not in a correct format.

Is there a way to persist the schema, or am I overlooking something?

Here is how I’m initializing the database:

async initDB(): Promise<void> {
  try {
    const result = await alasql.promise(
      `CREATE INDEXEDDB DATABASE IF NOT EXISTS ${this.dbName}`
    );
    await alasql.promise(`ATTACH INDEXEDDB DATABASE ${this.dbName}`);
    await alasql.promise(`USE ${this.dbName}`);

    console.log(`IndexedDB '${this.dbName}' initialized successfully`);
  } catch (error) {
    console.error('Error initializing IndexedDB:', error);
  }
}

After this, I run the CREATE TABLE queries and then perform data insertions.