jeep-sqlite alternative

mustafa0x commented 3 months ago

First, I want to thank the maintainer for the huge effort they've put into this incredibly valuable plugin.

Second, I want to ask: for web, is there an alternative to jeep-sqlite? I've noticed two issues with it:

Very large size. It adds 500kb to my javascript bundle (excluding the wasm file). More than the rest of my app, combined.
It requires calling saveToStore after any changes. This creates an easy pitfall: the developer makes changes create/update/delete but forgets to call saveToStore.

oliveryasuna commented 2 months ago

Theoretically, you could proxy the web implementation and use whatever you want.

jepiqueau commented 2 months ago

@mustafa0x

regarding the saveToSore comment, i would like to say in earlier version the saveToStore was done for any new INSERT, UPDATE or DELETE sql commands. it has been removed as when developers where loading large batch of data it was taking too long to execute the process. A property has been added to the Stencil component autosave with default to false. Set this property to true when you set the jeep-sqlite component in your app, it will allow you to not care about the saveToStore and then fix the easy pitfall.
regarding the large size comment it is mainly due to the size of the sql-wasm.wasm which is intrinsec to sql.js. The only way to limit the size will be to move away from sql.js which means rewriting the stencil component.

Hope this clarify.

mustafa0x commented 2 months ago

Thanks you so much @jepiqueau, I'm very grateful for the tremendous effort you've put into this very-useful plugin!

the large size is mainly due to the size of the sql-wasm.wasm

The jeep-sqlite stencil component alone is >500kb (the sql-wasm is 640kb.)

jepiqueau commented 2 months ago

@mustafa0x see also my answer to issue#579

capacitor-community / sqlite