Node.js Persistence

[jlarmstrongiv]

Continuing discussion from #48

Proposed solutions:

• Node.js VFS implementation like node-sqlite3-wasm
• OPFS Polyfill

[AlphabetsAlphabets]

Hi, about this warning:

Node.js is currently only supported for in-memory databases without persistence.

I'd like clarification. Does this mean that I can't store data into the private FS provided by OPFS? From the proposed solution that seems to be the case.

An additional question: Are there types for the Promiser api? A quick glance at index.d.ts says no as there isn't a Promiser type.

[tomayac]

I'd like clarification. Does this mean that I can't store data into the private FS provided by OPFS? From the proposed solution that seems to be the case.

Correct, in Node.js, there's no OPFS. There are other storage mechanisms like regular files, but currently this version of SQLite Wasm can't make use of them.

An additional question: Are there types for the Promiser api? A quick glance at index.d.ts says no as there isn't a Promiser type.

This is #53.

[AlphabetsAlphabets]

I'd like clarification. Does this mean that I can't store data into the private FS provided by OPFS? From the proposed solution that seems to be the case.

Correct, in Node.js, there's no OPFS. There are other storage mechanisms like regular files, but currently this version of SQLite Wasm can't make use of them.

An additional question: Are there types for the Promiser api? A quick glance at index.d.ts says no as there isn't a Promiser type.

This is #53.

Thank you. For my second question the answer is no then, thanks.

[jurerotar]

In case anyone wants to experiment a bit, I maintain opfs-mock, which polyfills OPFS API to Node.js for purpose of testing. There's maybe a way modify opfs-mock a bit to patch-in persistence?