Skip to content

Instantly share code, notes, and snippets.

@edwinjue
Last active June 7, 2023 23:14
Show Gist options
  • Save edwinjue/d06e12b1a351b9b3f31f770eea52a71e to your computer and use it in GitHub Desktop.
Save edwinjue/d06e12b1a351b9b3f31f770eea52a71e to your computer and use it in GitHub Desktop.
For the latest version of our project attempting to query duckdb database from within a React component
Quick Start:
nvm install lts/erbium # install & use node 12
nvm use lts/erbium
git clone git@github.com:edwinjue/311-data-v2-gh-pages.git
cd 311-data-v2-gh-pages
git fetch && git checkout duckdb
mkdir -p ./db/
wget --no-check-certificate 'https://docs.google.com/uc?export=download&id=1N6QJgErawp8N0Oq27HnrBDnieg0yiwbZ' -O ./db/master.duckdb
npm run setup
npm start
Console:
Issues (1 Error, 5 Warnings):
WARNING in ./node_modules/duckdb/lib/duckdb-binding.js 4:14-35
Critical dependency: the request of a dependency is an expression
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
WARNING in ./node_modules/@mapbox/node-pre-gyp/lib/util/versioning.js 17:18-65
Critical dependency: the request of a dependency is an expression
@ ./node_modules/@mapbox/node-pre-gyp/lib sync ^\.\/.*$
@ ./node_modules/@mapbox/node-pre-gyp/lib/node-pre-gyp.js
@ ./node_modules/duckdb/lib/duckdb-binding.js
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
WARNING in ./node_modules/keyv/src/index.js 18:14-40
Critical dependency: the request of a dependency is an expression
@ ./node_modules/cacheable-request/src/index.js
@ ./node_modules/got/index.js
@ ./node_modules/@mapbox/mapbox-sdk/lib/node/node-layer.js
@ ./node_modules/@mapbox/mapbox-sdk/lib/node/node-client.js
@ ./node_modules/@mapbox/mapbox-sdk/lib/client.js
@ ./node_modules/@mapbox/mapbox-sdk/index.js
@ ./node_modules/@mapbox/mapbox-gl-geocoder/lib/index.js
@ ./components/Map/controls/MapSearch.jsx
@ ./components/Map/Map.jsx
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
WARNING in ./node_modules/@mapbox/node-pre-gyp/lib/util/compile.js
Module not found: Error: Can't resolve 'npm' in '/home/user/311-data-v2-gh-pages/node_modules/@mapbox/node-pre-gyp/lib/util'
@ ./node_modules/@mapbox/node-pre-gyp/lib/util/compile.js
@ ./node_modules/@mapbox/node-pre-gyp/lib sync ^\.\/.*$
@ ./node_modules/@mapbox/node-pre-gyp/lib/node-pre-gyp.js
@ ./node_modules/duckdb/lib/duckdb-binding.js
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
WARNING in ./node_modules/@mapbox/node-pre-gyp/lib/util/nw-pre-gyp/index.html 1:0
Module parse failed: Unexpected token (1:0)
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders
> <!doctype html>
| <html>
| <head>
@ ./node_modules/@mapbox/node-pre-gyp/lib sync ^\.\/.*$ ./util/nw-pre-gyp/index.html
@ ./node_modules/@mapbox/node-pre-gyp/lib/node-pre-gyp.js
@ ./node_modules/duckdb/lib/duckdb-binding.js
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
WARNING in ./node_modules/node-gyp/lib/Find-VS2017.cs 7:6
Module parse failed: Unexpected token (7:6)
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders
| // Usage:
| // powershell -ExecutionPolicy Unrestricted -Version "2.0" -Command "&{Add-Type -Path Find-VS2017.cs; [VisualStudioConfiguration.Main]::Query()}"
> using System;
| using System.Text;
| using System.Runtime.InteropServices;
@ ./node_modules/node-gyp/lib sync ^\.\/.*$ ./Find-VS2017.cs
@ ./node_modules/node-gyp/lib/node-gyp.js
@ ./node_modules/@mapbox/node-pre-gyp/lib/util/compile.js
@ ./node_modules/@mapbox/node-pre-gyp/lib sync ^\.\/.*$
@ ./node_modules/@mapbox/node-pre-gyp/lib/node-pre-gyp.js
@ ./node_modules/duckdb/lib/duckdb-binding.js
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
ERROR in ./node_modules/node-gyp/lib/node-gyp.js
Module not found: Error: Can't resolve '../package' in '/home/user/311-data-v2-gh-pages/node_modules/node-gyp/lib'
@ ./node_modules/node-gyp/lib/node-gyp.js 67:16-37
@ ./node_modules/@mapbox/node-pre-gyp/lib/util/compile.js
@ ./node_modules/@mapbox/node-pre-gyp/lib sync ^\.\/.*$
@ ./node_modules/@mapbox/node-pre-gyp/lib/node-pre-gyp.js
@ ./node_modules/duckdb/lib/duckdb-binding.js
@ ./node_modules/duckdb/lib/duckdb.js
@ ./components/Map/index.js
@ ./components/main/Desktop/index.js
@ ./Routes.jsx
@ ./App.jsx
@ ./index.js
Link to source code:
https://github.com/edwinjue/311-data-v2-gh-pages/tree/duckdb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment