aaronksaunders/ionic7-react-sqlite

ionic7-react-sqlite

See a video walkthrough of the code here - https://youtu.be/tixvx5nsJO8

Links

• Ionic Visual Studio Code Plugin - https://marketplace.visualstudio.com/items?itemName=ionic.ionic
• Ionic React - https://ionicframework.com/docs/react/overview
• Capacitor - https://capacitorjs.com/
• SQLite Plugin - https://github.com/capacitor-community/sqlite

ionic7-react-sqlite's Issues

Setting initialized at the right time

Does it make sense to replace your

initializeDB().then(() => {
     initializeTables();
     setInitialized(true);
   });
 }, []);

with

initializeDB().then(async () => {
    await initializeTables();
    setInitialized(true);
  });
}, []);

to ensure, that initialized isn't set to early?

What's the location of the database file?

I've searched high and low for the sqlite database file. Where does this app place it?

android: database is undefined initially

Problem

Hi! I'm encountering an issue while trying to integrate the useSQLiteDB into my Ionic project. The problem appears when running the app on an Android emulator. The database object seems to be undefined initially and only becomes accessible after performing specific operations, such as adding an item.

Example

It's initialized two times

the useEffect in useSQLiteDB.tsx is run twice. Is this neccessary? And if not: How to prevent this?

Is serialize possible

Is it possible to use db?.serialize with performSQLAction?

I guess, that I've got a performance problem with when executeing many rows with something like this. Not on my pc but on my android. That's why I'm would like to know if I can use serialize.

for (let id = 1; id <= 20; id++) {
          const respSelect = await db?.query(
            `SELECT COUNT(*) as count FROM techniques WHERE id = ?`,
            [id]
          );
          
          ...
          const respInsert = await db?.execute(`
              INSERT INTO techniques (id) VALUES (${id});`);