Provide binaries

[oldium]

Summary

This is a continuation of #14, #16, possibly others. The original package TryGhost/node-sqlite3 is now officially deprecated. Despite your intentions not to be another distribution of the package, you became one - you are the last maintained version of the node-sqlite3 package.

Proposed implementation

Please provide pre-built binaries for all supported Node versions.

[oldium]

Also please update the embedded SQLite, this one is outdated.

[gms1]

There's already another well maintained fork:
https://github.com/AppThreat/node-sqlite3

Unfortunately, I didn't know that either until now, and therefore created my own

[oldium]

I would not call it "maintained". There are commits, sure, but I would question what the author is doing when he is able to double-sign a single commit... AppThreat/node-sqlite3@4f055a6

[gms1]

hopefully nothing worse will happen :-)

[oldium]

Well, I do not want to take the optimism from you, but this is definitely not how a well-maintained project looks like. This is on the main branch:

[gms1]

and what do you think about this one:
https://www.npmjs.com/package/@homeofthings/sqlite3

[oldium]

Looks like AI driven experiment without actually notifying AI has credits. The MacOS memory corruption issue is scary for a library to be used in production.

[gms1]

That's not any experiment, it's the current state that AI is revolutionizing software development...and since I am trying to keep the memory bank up-to-date, everyone can benefit from it. You too it seems :-)
Yes, the macOS crash worries me too, but it happens even without any add-ons being involved or any other node-sqlite3 library:
https://github.com/TryGhost/node-sqlite3/actions/runs/22959939094/job/66647471711#step:11:32
I've already spent a lot of time trying to narrow it down so I can pass it on to nodejs, but I haven't succeeded yet.

[oldium]

Don't get me wrong. Openly using AI is fine, experimenting on master/main branch is not (AI or not). Anyway, I switched to Node.js native sqlite support already, it is sufficient for my use cases.