Created a sqlite adapter for nodejs

[craftzdog]

Just wanted to share another adapter for PouchDB.

https://github.com/inkdropapp/pouchdb-adapter-node-sqlite

Why?

PouchDB uses leveldown by default, which is quite old and unmaintained at the moment.
You cannot use it on node >= 20 because:

• node-gyp-build tries to spawn an external helper script (prebuild-install.cmd, node-gyp.cmd, etc.) while installing leveldown.
• Since Node v20.12.2 / v22.x the Windows-only security patch for CVE-2024-27980 blocks any direct spawn of a .cmd or .bat file unless the caller passes {shell:true}. When a blocked call happens, Node now throws Error: spawn EINVAL instead of running the command nodejs.org.

Upgrading leveldb would look overwhelming for me. So I decided to make this module.

SQLite3 is fast enough and lightweight

It internally uses better-sqlite3.
Compiling the native module is quite faster than leveldown.

Stable (I hope)

I copied integration tests from PouchDB and this module passes them:

• https://github.com/inkdropapp/pouchdb-adapter-node-sqlite/tree/main/tests

It supports arm64

• https://github.com/inkdropapp/pouchdb-adapter-node-sqlite/actions/runs/17395148054

---

I'm going to use it in my product.
I hope some people will find this module useful as well.