There are some ways to encrypt sqlite db?

[peppababy7]

This library is good. But I have some questions, please help me.

1. Is there some way to encrypt sqlite db? That is very important!
2. If I'm query and update use SELECT so frequently (maybe 1-4 times/sec, maybe 1-4 times/min), should I increase the stack or memory size? What should I do.

[peppababy7]

In other platforms I would encrypt the entire database and decrypt it on first opening. But in the this lib the sqlite db will write to the indexDB and split into many sub, so what should I do.

[sgbeal]

1. Encryption of an SQLite db is a project in and of itself, with several implementations available. See this forum post for a recent discussion which mentions the available options.

2. 1-4 times/second is, in the general case, not terribly frequent for SQLite. As a rule of thumb, you don't need to change anything unless/until you determine, through observation and measurement, that doing so actually helps. Increasing the stack memory size won't help queries because they use dynamic memory, not stack memory. Depending on how the .wasm file is built, it may have a fixed or growable dynamic memory size. If it's fixed, you may need to increase it for large queries, but the query frequency, by itself, plays no significant role in memory usage. RAM usage is next to impossible to calculate accurately in advance, but if your app fails with allocation errors from wasm, growing the memory will be required.

[rhashimoto]

In this project, Issues are only for possible bugs in project code.