Find in-memory DB implemented on JS

[vitonsky]

To make able run app in browser, we need in-memory DB implemented on javascript.

DB must be in-memory, because we can't keep unencrypted data on disk or any persistent storage like indexedDB. Any persistent storage may potentially preserve secret data forever.

DB must be implemented on javascipt (and written on typescript ideally), because WASM implementations are non stable according to issues on their repositories. The most common problem is memory crash.

Candidates

• https://github.com/duckdb/duckdb-node - interesting, support as nodejs as wasm. They claim that DB enough fast, but better-sqlite is not presented in benchmarks
• https://signaldb.js.org/ - it looks they have only list collections, so we have to implement complex code for transactions between multiple collections
• https://pouchdb.com/ - they have in-memory adapter
• https://github.com/pubkey/rxdb/ - no, because lack of support and core maintainer with mindset "pay me for i'm beauty" who auto close any issues
• https://github.com/tinyplex/tinybase - probably no, because it just store, but not a DB who supports complex queries

Too young projects. Just to follow on progress

• https://www.npmjs.com/package/newtondb - looks interesting, they have something like tables
• https://github.com/electric-sql/pglite - wasm. They are react on issues with time. Need research how stable solution is

[vitonsky]

PGlite has been tested in nano-queries project, it works fine.

They have problem with jest electric-sql/pglite#224 but it works fine with vitest as explained in comment electric-sql/pglite#224 (comment)

Preliminary verdict is PGlite have some community, contributors looks adequate, issues lives until they will be solved, but not just because somebody want to minimize a number, project have documentation. In total, PGlite looks like good solution.