mbtiles converter dependency 'sqlite3' not available

[canadaduane]

When I yarn install the node modules for ./converter/mbtiles/ I get the following error:

node-pre-gyp info it worked if it ends with ok
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | darwin | x64
node-pre-gyp info check checked for "/Users/dujohnson/tmp/geopackage-js/converters/mbtiles/node_modules/sqlite3/lib/binding/node-v64-darwin-x64/node_sqlite3.node" (not found)
node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz
node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz
node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v64 ABI) (falling back to source compile with node-gyp)
node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz
node-pre-gyp ERR! Tried to download(undefined): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v64 ABI) (falling back to source compile with node-gyp)
node-pre-gyp http Connection closed while downloading tarball file

And indeed, when I visit https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v64-darwin-x64.tar.gz I get the following error:

<Error>
  <Code>AccessDenied</Code>
  <Message>Access Denied</Message>
  <RequestId>F2735A74E4249542</RequestId>
  <HostId>nROeg5Ex5GGEQuNYvefpuGITA3fV4ambpNX8gSD0bBPj3ZY46kn+pUlf07lgdto8n2ky6M9hQcQ=</HostId>
</Error>

[danielbarela]

I am in the process of upgrading the converters to the new version of geopackage-js which removes the dependency on mapbox sqlite3. I will update this ticket when the mbtiles converter is updated.

[canadaduane]

As a temporary workaround, I was able to yarn install with this in the ./converters/mbtiles/package.json:

  "resolutions": {
    "**/sqlite3": "^4.0.0"
  },

[canadaduane]

BTW we are in the midst of replacing an older mbtiles->geopackage converter with what will likely be your ngageoint/geopackage-js converter. What is the approximate timeline for the updated work you're doing on the mbtiles converter? i.e. weeks vs months?

[danielbarela]

I would say weeks. It is not as straightforward as I would like because the original node-mbtiles was written with only node in mind and not the browser. So I have to update my fork of that first and then I can update this project.

[canadaduane]

Thanks!

On Fri, Apr 17, 2020 at 1:37 PM Dan [email protected] wrote:

I would say weeks. It is not as straightforward as I would like because the original node-mbtiles was written with only node in mind and not the browser. So I have to update my fork of that first and then I can update this project.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ngageoint/geopackage-js/issues/147#issuecomment-615429114, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAABAKN3DZLWTZM7PFKU3DRNCVYVANCNFSM4MI6BGMA .

[danielbarela]

Sorry this has taken so long, got pulled onto a different project. I have a readonly version working so far which really just creates views from the existing MBTiles tables and adds the appropriate GeoPackage tables.

[canadaduane]

Great! Thank you.

On Tue, Jun 30, 2020 at 5:59 AM Dan [email protected] wrote:

Sorry this has taken so long, got pulled onto a different project. I have a readonly version working so far which really just creates views from the existing MBTiles tables and adds the appropriate GeoPackage tables.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ngageoint/geopackage-js/issues/147#issuecomment-651746817, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAABAJKGOKMT6LEZLIUM43RZHHRFANCNFSM4MI6BGMA .