Hi. Node-sqlite3 is indeed a native (i.e. not pure JavaScript) module which must be built for your target OS and node API version. On Windows, this means you will need to download the free Visual Studio Express 2010 (the current release). The good news is, you don't need to know anything about Visual Studio except that it invludes the msbuild toolset.
Use npm to install node-gyp and node-bindings. Next, go to GitHub and download a copy of the "gyp" branch of node-sqlite3 created by a very helpful gentleman who goes by the moniker TooTallNate. (There's a pull request to merge his branch into main, but I don't know if that has happened yet.). Follow the directions in the readme, and the gyp script will build node-sqlite for you. See also the discussion attached to Nate's branch. I apologize for not explaining how all this magic works. (Others know more than me anyway.). As complex as this seems, it is waaay better than it was a couple months ago, and there is a cocerted effort to improve the experience on all platforms, coordinated on this list. On Mar 1, 2012 1:46 AM, "Lam" <[email protected]> wrote: > C. Mundi, > > I am very new to node.js and github for that matter. I am trying to > install the node-sqlite3 module in my Windows XP Pro environment (yup, it's > still stable for now...). Well, first I try npm install sqlite3 and I > receive all kinds of errors that I have listed below. As you can see, > there are too many errors for this. Then I start google the node-sqlite3 > in windows and I come across your github posting. However, I am not seeing > any more notes about how an end user like myself can install this Windows > version of the node-sqlite3 module. Granted, I am not even a strong > Windows developer. So I don't even have Visual Studio. I am more of a > backend Oracle ERP database development type. So web development is > something that I want to focus more on. Anyway, would you mind pointing me > to the right direction on how can I install the node-sqlite3 module please? > > Thanks in advance! > > ======== start of error ============ > C:\Documents and Settings\<UserName>\Application Data\npm>npm install > sqlite3 > npm http GET https://registry.npmjs.org/sqlite3 > npm http 304 https://registry.npmjs.org/sqlite3 > > > [email protected] preinstall C:\Documents and > Settings\<UserName>\Application Data\npm\node_modules\sqlite3 > > node-waf clean || (exit 0); node-waf configure build > > node-waf was unexpected at this time. > npm ERR! error installing [email protected] > > npm ERR! [email protected] preinstall: `node-waf clean || (exit 0); node-waf > configure build` > npm ERR! `cmd "/c" "node-waf clean || (exit 0); node-waf configure build"` > failed with 1 > npm ERR! > npm ERR! Failed at the [email protected] preinstall script. > npm ERR! This is most likely a problem with the sqlite3 package, > npm ERR! not with npm itself. > npm ERR! Tell the author that this fails on your system: > npm ERR! node-waf clean || (exit 0); node-waf configure build > npm ERR! You can get their info via: > npm ERR! npm owner ls sqlite3 > npm ERR! There is likely additional logging output above. > npm ERR! > npm ERR! System Windows_NT 5.1.2600 > npm ERR! command "C:\\Program Files\\nodejs\\\\node.exe" "C:\\Program > Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" " > sqlite3" > npm ERR! cwd C:\Documents and Settings\<UserName>\Application Data\npm > npm ERR! node -v v0.6.10 > npm ERR! npm -v 1.1.0-3 > npm ERR! code ELIFECYCLE > npm ERR! message [email protected] preinstall: `node-waf clean || (exit 0); > node-waf configure build` > npm ERR! message `cmd "/c" "node-waf clean || (exit 0); node-waf configure > build"` failed with 1 > npm ERR! errno {} > npm ERR! > npm ERR! Additional logging details can be found in: > npm ERR! C:\Documents and Settings\<UserName>\Application > Data\npm\npm-debug.log > npm not ok > =============== End of error =============== > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > > On Friday, January 6, 2012 10:36:01 PM UTC-5, C. Mundi wrote: >> >> I do not see a Google group specific to node-sqlite, so I hope it's ok >> to post here since this is probably relevant to many people trying to >> get their node environment set up on Windows and I'd like to give back >> a little for all the help I'm getting from this group. >> >> So I got the node-sqlite built in Debug. Only took me three >> hours. :) And I am confident that I can get it built in Release with >> just a little more effort. I have posted my experience as an issue >> at >> >> https://github.com/**developmentseed/node-sqlite3/**issues/55<https://github.com/developmentseed/node-sqlite3/issues/55> >> >> But now I realize that I have no idea how to install the module so >> that node can use it. Ha! Welcome to the next step in the learning >> curve. Anyway, if you have been having trouble building node-sqlite >> for Windows, I hope this helps you. >> > -- > Job Board: http://jobs.nodejs.org/ > Posting guidelines: > https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines > You received this message because you are subscribed to the Google > Groups "nodejs" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nodejs?hl=en?hl=en > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
