APM can't install SQLite3 dependency

[luastoned]

Basically node-gyp is super oudated, if you run Windows 10 with some recent compiler (VS2015, VS2017) it will not work, no matter what.
The supposedly pre-built binaries are nowhere to be found either, so no SQLite3 is available.

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/electron-v1.3-win32-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (electron-v1.3 ABI) (falling back to source compile with node-gyp)

Please consider switching to something different, as this is not the first issue regarding the install process.

[trotzig]

Hi @luastoned, and thanks for reporting your issue!

I've had a few people reporting issues with installing atom-import-js (#12 comes to mind as the most recent one). In most (all?) cases, we've managed to find workarounds.

When you say "consider switching to something different", do you mean move off of sqlite3? It's something I've considered as well, having had issues myself during early implementation of the current version of import-js. I'd be interested to hear if you have ideas for alternatives, or if you'd be willing to explore a different implementation!

It would also be interesting to see more of the log output. In cases when prebuilt binaries can't be found, node-pre-gyp falls back to doing a native build (I believe). Are you seeing issues from that process as well, or is the installation exited right away?

[luastoned]

node-pre-gyp tries to do a native install, which fails because it can't find MSBuild.
It tries an oudated way and for VS2017 there is no solution yet: nodejs/node-gyp#1173

As for alternatives, I'm not quite sure what you are storing but https://github.com/kripken/sql.js seems interesting.

[trotzig]

Ouch, that's annoying. I'm currently exploring alternatives: https://twitter.com/henrictrotzig/status/869267951794487297

I would happily move off of node-sqlite3 if there is an alternative. I need something that can persist to a file and allow some kind of querying, allowing concurrent instances to read and write at the same time. All the db interaction is in a file called ExportsStorage, so replacing it shouldn't be too hard. Let me know if you have any ideas!

[luastoned]

Any updates regarding this issue? I still can't install 0.13

[trotzig]

As far as I can tell, no one is actively working on this issue. Any help here is appreciated!