jepiqueau / angular-sqlite-app-starter Goto Github PK

Hello, I tried to debug with visual studio code, but for some reason webpack is not showing.

With a normal ionic angular project I have

which allows debugging, any idea?

The starter app works on Android (Didn't try it on iOS). I can see (using Device File Explorer in Android Studio) that, the app creates two databases. But, when I use the plugin in my Ionic, Capacitor app, it doesn't work. The database is not created.

I created Ionic Capacitor using usual method (ionic start myApp blank --type=ionic-angular) and then followed the instructions given on the starter app page. But, my app could not create database. So, I deleted my node_modules directory, package.json and the lock files. Copied and pasted the package.json and the lock files from starter app and did npm install. Even after using the same package.json file, I was not able to create a database.

There is a thread in Ionic Forums (https://forum.ionicframework.com/t/cant-get-sqlite-plugin-to-work-in-my-app/185622) that has similar issue. After going through the same, I thought of creating an issue here to seek help.

Any help is appreciated.

With latest version of:
"@capacitor-community/sqlite": "3.5.1-2",
"jeep-sqlite": "1.5.1",

This project doesn't work on browser (work fine on mobile), and print some error like:

core.mjs:6485 ERROR Error: Uncaught (in promise): TypeError: Cannot read properties of undefined (reading 'apply')
TypeError: Cannot read properties of undefined (reading 'apply')
    at e.stackAlloc (jeep-sqlite.entry.js:2661:506)
    at e.onRuntimeInitialized (jeep-sqlite.entry.js:2561:213)
    at a (jeep-sqlite.entry.js:2663:432)
    at dd (jeep-sqlite.entry.js:2664:321)
    at cd (jeep-sqlite.entry.js:2662:343)
    at a (jeep-sqlite.entry.js:2650:176)
    at b (jeep-sqlite.entry.js:2650:197)
    at push.23484._ZoneDelegate.invoke (zone.js:409:1)
    at Object.onInvoke (core.mjs:25592:1)
    at push.23484._ZoneDelegate.invoke (zone.js:408:1)
    at resolvePromise (zone.js:1262:1)
    at zone.js:1169:1
    at zone.js:1185:1
    at push.23484._ZoneDelegate.invoke (zone.js:409:1)
    at Object.onInvoke (core.mjs:25592:1)
    at push.23484._ZoneDelegate.invoke (zone.js:408:1)
    at push.23484.Zone.run (zone.js:169:1)
    at zone.js:1326:1
    at push.23484._ZoneDelegate.invokeTask (zone.js:443:1)
    at Object.onInvokeTask (core.mjs:25579:1)

The current version of these package work fine but when I tried to update them to latest, this error happen.

I have tried to update typescript, capacitor/core...etc and other things but still no luck. even with a brand new project have everything update date.

Doesn't know what cause it 🤔

Hi,

I have an electron app in angular with ionic; I use @capacitor-community/electron and @capacitor-community/sqlite ( so your plugin too).

I use Angular 11, Electron 10.3.1, @journeyapps/sqlcipher 5.2.0, Node v14.17.0.

I can't open the electron app without rename electron\node-module@journeyapps\sqlcipher\lib\binding\napi-v6-win32-ia32 to ..\napi-v3-win32-ia32 .

Once rename, electron app could be open. But when I package electron app in the same PC ,I can't use the .exe generated. The packaging is going well, but the app generated is a blank app with error :

I don't know why the pakage changes ( napi-v6-win32-x64). I tried to add manually this package in electron\node_modules.

I don't know if it's a version's problems. I can't package either this exemple project.

Can anyone help me please ?

jepiqueau/react-sqlite-app-starter#10

It's the same problem as this ticket. I'm trying to find a way around it. It's difficult to solve.

I am stuck at this code statement .
const db: SQLiteDBConnection = await this.sqlite.createConnection(database, encrypted, mode, version);

The below error is shown for the 'db' -
Type 'SQLiteDBConnection | null' is not assignable to type 'SQLiteDBConnection'.
Type 'null' is not assignable to type 'SQLiteDBConnection'.ts(2322)

There is a problem in parsing data in query function , if you pass a number in values array it will be parsed as a string which will make a wrong query

"I would like to know which function is used to initiate a transaction in SQLite, as I do not see it in the documentation. Typically, it would be 'Begin transaction,' and then 'Commit' to confirm, but I can't find the correct command for that."