FAQ

[nodejs] Re: Building node-sqlite for Windows

Lam
Mar 1, 2012 at 8:46 am
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
sqlite3@2.1.1 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 sqlite3@2.1.1

npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 nodejs@googlegroups.com
To unsubscribe from this group, send email to
nodejs+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
reply

Search Discussions

19 responses

  • C. Mundi at Mar 1, 2012 at 3:50 pm
    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Jude Lam at Mar 1, 2012 at 4:32 pm
    C. Mundi,

    Thanks for your explanation. I have one more newbie question on Github. That is how do you pull a branch version of the code? I will read a bit on Github. I have used cvs and subversion before. But I am new to git and Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone
    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • C. Mundi at Mar 1, 2012 at 5:30 pm
    Maybe better ways, but I do this..

    1. Make sure you're looking at the branch you want.

    2. Click the download zip icon...generally above and to the left of the
    file display.

    Note that Nate's branch is part of his own repo (forked from the main
    node-sqlite3 repo) and not part of that main repo.
    On Mar 1, 2012 9:31 AM, "Jude Lam" wrote:

    C. Mundi,

    Thanks for your explanation. I have one more newbie question on Github.
    That is how do you pull a branch version of the code? I will read a bit
    on Github. I have used cvs and subversion before. But I am new to git and
    Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone

    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Jude Lam at Mar 2, 2012 at 12:23 am
    Thanks! I will give this a try.

    Sent from my iPhone
    On Mar 1, 2012, at 12:30 PM, "C. Mundi" wrote:

    Maybe better ways, but I do this..

    1. Make sure you're looking at the branch you want.

    2. Click the download zip icon...generally above and to the left of the file display.

    Note that Nate's branch is part of his own repo (forked from the main node-sqlite3 repo) and not part of that main repo.

    On Mar 1, 2012 9:31 AM, "Jude Lam" wrote:
    C. Mundi,

    Thanks for your explanation. I have one more newbie question on Github. That is how do you pull a branch version of the code? I will read a bit on Github. I have used cvs and subversion before. But I am new to git and Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone
    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Jude Lam at Mar 3, 2012 at 2:21 pm
    C. Mundi,

    Sorry for bugging you again. I have installed the node-gyp and bindings
    module. I have also installed the Visual C++ Express 2010.

    I think that I have successfully "configured" the build directory with
    node-gyp configure command.

    Now, when I run the node-gyp build command, it crashes with the following
    error. I have opened Visual C++ Express and load the bindings.sln, it
    complains that "Some of the properties associated with the solution could
    not be read." But when I right click it and do Build or Rebuild solution,
    it ends with success count of 2. But it did say that my target path does
    not match with my library path, etc.

    Do you have any idea what may cause this? I guess that more importantly,
    should I run the node-gyp build command and if I do, is there any issue
    with the command itslef then? I have deleted the build folder and rerun
    the node-gyp configure as well and this doesn't help.

    So any pointers are appreciated. Again, sorry to bug you with this basic
    question. Thanks.

    C:\Internet_Download\TooTallNate_SQLite3>node-gyp build
    info it worked if it ends with ok
    spawn C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe [
    'build/bindings.sln',
    '/clp:Verbosity=minimal',
    '/nologo',
    '/p:Configuration=Release' ]
    C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln.metaproj :
    error MSB4126: The specified solution configuration "Release
    MCD" is invalid. Please specify a valid solution configuration using the
    Configuration and Platform properties (e.g. MSBuild.exe S
    olution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those
    properties blank to use the default solution configuration
    . [C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln]
    ERR! Error: `C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe`
    failed with exit code: 1
    at Array.0 (C:\Documents and Settings\<User Name>\Application
    Data\npm\node_modules\node-gyp\lib\build.js:139:25)
    at EventEmitter._tickCallback (node.js:192:40)
    ERR! not ok
    On Thu, Mar 1, 2012 at 12:30 PM, C. Mundi wrote:

    Maybe better ways, but I do this..

    1. Make sure you're looking at the branch you want.

    2. Click the download zip icon...generally above and to the left of the
    file display.

    Note that Nate's branch is part of his own repo (forked from the main
    node-sqlite3 repo) and not part of that main repo.
    On Mar 1, 2012 9:31 AM, "Jude Lam" wrote:

    C. Mundi,

    Thanks for your explanation. I have one more newbie question on Github.
    That is how do you pull a branch version of the code? I will read a bit
    on Github. I have used cvs and subversion before. But I am new to git and
    Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone

    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en


    --
    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Jude Lam at Mar 3, 2012 at 3:06 pm
    C. Mundi,

    You probably start thinking that I am a psycho or something. But I want to
    pass this info to you to see if this makes sense. I manually type in the
    following command and it seems like that it builds successfully.

    C:\Internet_Download\TooTallNate_SQLite3>C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe
    build/bindings.sln /verbosity:m /nologo
    /p:Configuration=Release;Platform="win32"

    But now I need to know what's next to package it to be used by node, i.e.
    make this into a folder with all the files where it will say node-sqlite3
    or something like this.

    I will keep hacking my way through. But if you have any pointers, they are
    always welcome.

    Many thanks in advance and you have provided me enough to move forward
    anyway.
    On Sat, Mar 3, 2012 at 9:20 AM, Jude Lam wrote:

    C. Mundi,

    Sorry for bugging you again. I have installed the node-gyp and bindings
    module. I have also installed the Visual C++ Express 2010.

    I think that I have successfully "configured" the build directory with
    node-gyp configure command.

    Now, when I run the node-gyp build command, it crashes with the following
    error. I have opened Visual C++ Express and load the bindings.sln, it
    complains that "Some of the properties associated with the solution could
    not be read." But when I right click it and do Build or Rebuild solution,
    it ends with success count of 2. But it did say that my target path does
    not match with my library path, etc.

    Do you have any idea what may cause this? I guess that more importantly,
    should I run the node-gyp build command and if I do, is there any issue
    with the command itslef then? I have deleted the build folder and rerun
    the node-gyp configure as well and this doesn't help.

    So any pointers are appreciated. Again, sorry to bug you with this basic
    question. Thanks.

    C:\Internet_Download\TooTallNate_SQLite3>node-gyp build
    info it worked if it ends with ok
    spawn C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe [
    'build/bindings.sln',
    '/clp:Verbosity=minimal',
    '/nologo',
    '/p:Configuration=Release' ]
    C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln.metaproj :
    error MSB4126: The specified solution configuration "Release
    MCD" is invalid. Please specify a valid solution configuration using the
    Configuration and Platform properties (e.g. MSBuild.exe S
    olution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those
    properties blank to use the default solution configuration
    . [C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln]
    ERR! Error: `C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe`
    failed with exit code: 1
    at Array.0 (C:\Documents and Settings\<User Name>\Application
    Data\npm\node_modules\node-gyp\lib\build.js:139:25)
    at EventEmitter._tickCallback (node.js:192:40)
    ERR! not ok
    On Thu, Mar 1, 2012 at 12:30 PM, C. Mundi wrote:

    Maybe better ways, but I do this..

    1. Make sure you're looking at the branch you want.

    2. Click the download zip icon...generally above and to the left of the
    file display.

    Note that Nate's branch is part of his own repo (forked from the main
    node-sqlite3 repo) and not part of that main repo.
    On Mar 1, 2012 9:31 AM, "Jude Lam" wrote:

    C. Mundi,

    Thanks for your explanation. I have one more newbie question on Github.
    That is how do you pull a branch version of the code? I will read a bit
    on Github. I have used cvs and subversion before. But I am new to git and
    Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone

    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en


    --

    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com


    --
    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • C. Mundi at Mar 3, 2012 at 4:21 pm
    You're not crazy. You are looking at the wrong readme, but there was no
    good way for you to know that ahead of time. It's confusing.

    You don't need to ever launch visual studio. So any instructions which say
    to do that are the wrong instructions for us. The gyp branch by
    tootallnate has a vcbuild.bat file which invokes the command line tools
    from the visual studio kit.

    HTH, I am on the road and can't log in from here.
    On Mar 3, 2012 8:06 AM, "Jude Lam" wrote:

    C. Mundi,

    You probably start thinking that I am a psycho or something. But I want
    to pass this info to you to see if this makes sense. I manually type in
    the following command and it seems like that it builds successfully.

    C:\Internet_Download\TooTallNate_SQLite3>C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe
    build/bindings.sln /verbosity:m /nologo
    /p:Configuration=Release;Platform="win32"

    But now I need to know what's next to package it to be used by node, i.e.
    make this into a folder with all the files where it will say node-sqlite3
    or something like this.

    I will keep hacking my way through. But if you have any pointers, they
    are always welcome.

    Many thanks in advance and you have provided me enough to move forward
    anyway.
    On Sat, Mar 3, 2012 at 9:20 AM, Jude Lam wrote:

    C. Mundi,

    Sorry for bugging you again. I have installed the node-gyp and bindings
    module. I have also installed the Visual C++ Express 2010.

    I think that I have successfully "configured" the build directory with
    node-gyp configure command.

    Now, when I run the node-gyp build command, it crashes with the following
    error. I have opened Visual C++ Express and load the bindings.sln, it
    complains that "Some of the properties associated with the solution could
    not be read." But when I right click it and do Build or Rebuild solution,
    it ends with success count of 2. But it did say that my target path does
    not match with my library path, etc.

    Do you have any idea what may cause this? I guess that more importantly,
    should I run the node-gyp build command and if I do, is there any issue
    with the command itslef then? I have deleted the build folder and rerun
    the node-gyp configure as well and this doesn't help.

    So any pointers are appreciated. Again, sorry to bug you with this basic
    question. Thanks.

    C:\Internet_Download\TooTallNate_SQLite3>node-gyp build
    info it worked if it ends with ok
    spawn C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe [
    'build/bindings.sln',
    '/clp:Verbosity=minimal',
    '/nologo',
    '/p:Configuration=Release' ]
    C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln.metaproj :
    error MSB4126: The specified solution configuration "Release
    MCD" is invalid. Please specify a valid solution configuration using the
    Configuration and Platform properties (e.g. MSBuild.exe S
    olution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those
    properties blank to use the default solution configuration
    . [C:\Internet_Download\TooTallNate_SQLite3\build\bindings.sln]
    ERR! Error: `C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe`
    failed with exit code: 1
    at Array.0 (C:\Documents and Settings\<User Name>\Application
    Data\npm\node_modules\node-gyp\lib\build.js:139:25)
    at EventEmitter._tickCallback (node.js:192:40)
    ERR! not ok
    On Thu, Mar 1, 2012 at 12:30 PM, C. Mundi wrote:

    Maybe better ways, but I do this..

    1. Make sure you're looking at the branch you want.

    2. Click the download zip icon...generally above and to the left of the
    file display.

    Note that Nate's branch is part of his own repo (forked from the main
    node-sqlite3 repo) and not part of that main repo.
    On Mar 1, 2012 9:31 AM, "Jude Lam" wrote:

    C. Mundi,

    Thanks for your explanation. I have one more newbie question on
    Github. That is how do you pull a branch version of the code? I will read
    a bit on Github. I have used cvs and subversion before. But I am new to
    git and Github. So your quick input will be very much appreciated. Thx

    Sent from my iPhone

    On Mar 1, 2012, at 10:50 AM, "C. Mundi" wrote:

    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" 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
    sqlite3@2.1.1 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 sqlite3@2.1.1

    npm ERR! sqlite3@2.1.1 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 sqlite3@2.1.1 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 sqlite3@2.1.1 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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en


    --

    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com


    --

    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com


    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Mscdex at Mar 3, 2012 at 3:16 pm
    FWIW here's a vcbuild.bat that I use for building the node-sqlite3 on
    Windows (for use with node v0.6): https://gist.github.com/d831529c9c08c754ee47

    Just make sure the the deps/ folder contains sqlite3.c and sqlite3.h
    and that you have NODE_ROOT set to the root (of the node source) where
    it can find the necessary node-related lib and header files.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Jude Lam at Mar 3, 2012 at 7:38 pm
    mscdex,

    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.

    Per my last email, I use the msbuild command and it appears that it
    generates the node_sqlite3.lib and node_sqlite3.node files. I can see
    these files in my "build/Release" directory. It also has a sub-folder
    "lib" and has the sqlite3.node file in it.

    So does this mean that I need to use the node source file to combine these
    library into the node executable itself or is there a way for me to create
    the "node module" out of these files?

    Again, thanks for the support. You guys are great.

    Thanks.
    On Sat, Mar 3, 2012 at 10:16 AM, mscdex wrote:

    FWIW here's a vcbuild.bat that I use for building the node-sqlite3 on
    Windows (for use with node v0.6):
    https://gist.github.com/d831529c9c08c754ee47

    Just make sure the the deps/ folder contains sqlite3.c and sqlite3.h
    and that you have NODE_ROOT set to the root (of the node source) where
    it can find the necessary node-related lib and header files.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en


    --
    ================================================================================
    Jude Lam, CEO
    LForge, LLC
    Mobile: 865-300-4829
    Email: judelam.lforge@gmail.com

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Mscdex at Mar 3, 2012 at 8:41 pm

    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat.  Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-win-dev.zip
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • C. Mundi at Mar 3, 2012 at 9:09 pm
    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-win-dev.zip
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Nathan Rajlich at Mar 3, 2012 at 9:55 pm
    Hey Jude, please open an Issue on the node-gyp issue tracker about the
    trouble you are having while building. I haven't seen that one yet. Include
    the Windows version you are using.

    Also, once you have the compiled bindings (which you have, in
    build/Release/node_sqlite3.node),
    just try firing up node and require()ing the node-sqlite directory (if you
    are in the root of the module, do "require('./')" ). Hope that helps!

    mscdex, if you haven't already, I recommend checking out node-gyp. It makes
    all the steps in your node-win-dev example a lot simpler.
    On Sat, Mar 3, 2012 at 1:08 PM, C. Mundi wrote:

    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-win-dev.zip
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Mscdex at Mar 4, 2012 at 12:22 am

    On Mar 3, 4:54 pm, Nathan Rajlich wrote:
    mscdex, if you haven't already, I recommend checking out node-gyp. It makes
    all the steps in your node-win-dev example a lot simpler.
    Maybe, depending on the type and size of the project. The couple of
    bindings I've needed so far on Windows (node-sqlite3 and node-pcap)
    have very few files to compile, so complexity hasn't become an issue
    yet for me.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Lam at Mar 4, 2012 at 7:31 pm
    Nathan,

    Just log a new issue per your request in github titled "Trouble using
    node-gyp to build node-sqlite3 in Windows XP". Hope this makes sense to
    you.

    Thanks and I will give your suggestion a try now with the node_sqlite3.node
    file.

    What puzzles me though is that in installing other modules in node such as
    node-gyp, they always create a directory in the node_modules folder and
    then there are plenty of other sub directories such as "lib", "bin" , etc
    that has plenty of JS scripts. So for the node-sqlite3, what should be the
    proper directory structures and the files that need to go into them.

    I probably need to read up some materials about modules in node to learn
    more about how to create modules. So any link will be appreciated.

    Thanks.
    On Saturday, March 3, 2012 4:54:28 PM UTC-5, Nathan Rajlich wrote:

    Hey Jude, please open an Issue on the node-gyp issue tracker about the
    trouble you are having while building. I haven't seen that one yet. Include
    the Windows version you are using.

    Also, once you have the compiled bindings (which you have, in
    build/Release/node_sqlite3.node), just try firing up node and
    require()ing the node-sqlite directory (if you are in the root of the
    module, do "require('./')" ). Hope that helps!

    mscdex, if you haven't already, I recommend checking out node-gyp. It
    makes all the steps in your node-win-dev example a lot simpler.
    On Sat, Mar 3, 2012 at 1:08 PM, C. Mundi wrote:

    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-win-dev.zip
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Lam at Mar 4, 2012 at 7:54 pm
    Well, I am reading the modules section on nodejs.org now.... Hope this
    will help me understand this build process. Thanks.
    On Sunday, March 4, 2012 2:31:09 PM UTC-5, Lam wrote:

    Nathan,

    Just log a new issue per your request in github titled "Trouble using
    node-gyp to build node-sqlite3 in Windows XP". Hope this makes sense to
    you.

    Thanks and I will give your suggestion a try now with the
    node_sqlite3.node file.

    What puzzles me though is that in installing other modules in node such as
    node-gyp, they always create a directory in the node_modules folder and
    then there are plenty of other sub directories such as "lib", "bin" , etc
    that has plenty of JS scripts. So for the node-sqlite3, what should be the
    proper directory structures and the files that need to go into them.

    I probably need to read up some materials about modules in node to learn
    more about how to create modules. So any link will be appreciated.

    Thanks.
    On Saturday, March 3, 2012 4:54:28 PM UTC-5, Nathan Rajlich wrote:

    Hey Jude, please open an Issue on the node-gyp issue tracker about the
    trouble you are having while building. I haven't seen that one yet. Include
    the Windows version you are using.

    Also, once you have the compiled bindings (which you have, in
    build/Release/node_sqlite3.node), just try firing up node and
    require()ing the node-sqlite directory (if you are in the root of the
    module, do "require('./')" ). Hope that helps!

    mscdex, if you haven't already, I recommend checking out node-gyp. It
    makes all the steps in your node-win-dev example a lot simpler.
    On Sat, Mar 3, 2012 at 1:08 PM, C. Mundi wrote:

    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-win-dev.zip
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Nathan Rajlich at Mar 4, 2012 at 8:20 pm
    Lam, definitely read up on how modules work, but the questions you were
    asking are more related to how "packages" work (as in, a collection of
    modules in a directory tree). The heart of how packages work is the
    package.json file, which describes, among other things, the entry point of
    the package and the name. That's how node knows which file to load
    initially when requiring a "package" like node-sqlite3.

    So for the case of node-sqlite3, you can see that the entry
    point<https://github.com/developmentseed/node-sqlite3/blob/29cb28e543b6e30495c462c02d9168d7b8d2065a/package.json#L36>is
    "lib/sqlite3.js". Now the fork that I made of node-sqlite3 that has
    gyp
    support, I used node-bindings
    <https://github.com/TooTallNate/node-bindings>to require
    the compiled node_sqlite3.node
    file<https://github.com/TooTallNate/node-sqlite3/blob/gyp/lib/sqlite3.js#L1>.
    node-bindings expects to find the compiled .node file in its default build
    location, so once you have compiled with node-gyp, it will Just Work.
    From there, you can require() the node-sqlite3 directory and the package
    handling logic will kick in. Hope that was helpful!
    On Sun, Mar 4, 2012 at 11:53 AM, Lam wrote:

    Well, I am reading the modules section on nodejs.org now.... Hope this
    will help me understand this build process. Thanks.

    On Sunday, March 4, 2012 2:31:09 PM UTC-5, Lam wrote:

    Nathan,

    Just log a new issue per your request in github titled "Trouble using
    node-gyp to build node-sqlite3 in Windows XP". Hope this makes sense to
    you.

    Thanks and I will give your suggestion a try now with the
    node_sqlite3.node file.

    What puzzles me though is that in installing other modules in node such
    as node-gyp, they always create a directory in the node_modules folder and
    then there are plenty of other sub directories such as "lib", "bin" , etc
    that has plenty of JS scripts. So for the node-sqlite3, what should be the
    proper directory structures and the files that need to go into them.

    I probably need to read up some materials about modules in node to learn
    more about how to create modules. So any link will be appreciated.

    Thanks.
    On Saturday, March 3, 2012 4:54:28 PM UTC-5, Nathan Rajlich wrote:

    Hey Jude, please open an Issue on the node-gyp issue tracker about the
    trouble you are having while building. I haven't seen that one yet. Include
    the Windows version you are using.

    Also, once you have the compiled bindings (which you have, in
    build/Release/node_sqlite3.**node), just try firing up node and
    require()ing the node-sqlite directory (if you are in the root of the
    module, do "require('./')" ). Hope that helps!

    mscdex, if you haven't already, I recommend checking out node-gyp. It
    makes all the steps in your node-win-dev example a lot simpler.
    On Sat, Mar 3, 2012 at 1:08 PM, C. Mundi wrote:

    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for node.
    This should be all you need: http://mscdex.net/upload/node-**
    win-dev.zip <http://mscdex.net/upload/node-win-dev.zip>
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    Job Board: http://jobs.nodejs.org/
    Posting guidelines: https://github.com/joyent/**
    node/wiki/Mailing-List-**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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@**googlegroups.com<nodejs%2Bunsubscribe@googlegroups.com>
    For more options, visit this group at
    http://groups.google.com/**group/nodejs?hl=en?hl=en<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<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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@**googlegroups.com<nodejs%2Bunsubscribe@googlegroups.com>
    For more options, visit this group at
    http://groups.google.com/**group/nodejs?hl=en?hl=en<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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Lam at Mar 4, 2012 at 8:38 pm
    Nathan,

    Yes, reading that section makes more sense now and I should have read that
    first. So the explanation on the package.json makes sense and once you
    know the entry point, the rest is easy to follow.

    I've got this to work now! I probably make this too complicate to begin
    with by putting your files under my
    C:\Internet_Download\TooTallNate_SQLite3. I should have simply name it
    C:\Internet_Download\node_sqlite3 and it will work after my build by coping
    this node_sqlite3 directory back to the npm/node_modules sub-folder.

    However, since I don't want all those source files to go into the main npm
    area, here's what I did to create a final deployment folder. This is
    common sense to you. But I am just documenting this here so that any new
    comer like me may be able to search for it.

    I create a directory named "node_sqlite3" somewhere else.
    Then I copy the files from my build directory from
    C:\Internet_Download\TooTallNate_SQLite3 to this node_sqlite3 directory.
    So the following lists the files and the source directory and destination
    directory:

    File Name Source Directory
    Destination Directory
    sqlite3.js C:\Internet_Download\TooTallNate_SQLite3
    node_sqlite3
    package.json C:\Internet_Download\TooTallNate_SQLite3
    node_sqlite3
    *.* C:\Internet_Download\TooTallNate_SQLite3\lib
    node_sqlite3\lib
    node_sqlite3.node C:\Internet_Download\TooTallNate_SQLite3\build\Release
    node_sqlite3\Release

    Anyway, thanks every one for the help!
    On Sunday, March 4, 2012 3:20:10 PM UTC-5, Nathan Rajlich wrote:

    Lam, definitely read up on how modules work, but the questions you were
    asking are more related to how "packages" work (as in, a collection of
    modules in a directory tree). The heart of how packages work is the
    package.json file, which describes, among other things, the entry point of
    the package and the name. That's how node knows which file to load
    initially when requiring a "package" like node-sqlite3.

    So for the case of node-sqlite3, you can see that the entry point<https://github.com/developmentseed/node-sqlite3/blob/29cb28e543b6e30495c462c02d9168d7b8d2065a/package.json#L36>is "lib/sqlite3.js". Now the fork that I made of node-sqlite3 that has gyp
    support, I used node-bindings<https://github.com/TooTallNate/node-bindings>to require
    the compiled node_sqlite3.node file<https://github.com/TooTallNate/node-sqlite3/blob/gyp/lib/sqlite3.js#L1>.
    node-bindings expects to find the compiled .node file in its default build
    location, so once you have compiled with node-gyp, it will Just Work.

    From there, you can require() the node-sqlite3 directory and the package
    handling logic will kick in. Hope that was helpful!
    On Sun, Mar 4, 2012 at 11:53 AM, Lam wrote:

    Well, I am reading the modules section on nodejs.org now.... Hope this
    will help me understand this build process. Thanks.

    On Sunday, March 4, 2012 2:31:09 PM UTC-5, Lam wrote:

    Nathan,

    Just log a new issue per your request in github titled "Trouble using
    node-gyp to build node-sqlite3 in Windows XP". Hope this makes sense to
    you.

    Thanks and I will give your suggestion a try now with the
    node_sqlite3.node file.

    What puzzles me though is that in installing other modules in node such
    as node-gyp, they always create a directory in the node_modules folder and
    then there are plenty of other sub directories such as "lib", "bin" , etc
    that has plenty of JS scripts. So for the node-sqlite3, what should be the
    proper directory structures and the files that need to go into them.

    I probably need to read up some materials about modules in node to learn
    more about how to create modules. So any link will be appreciated.

    Thanks.
    On Saturday, March 3, 2012 4:54:28 PM UTC-5, Nathan Rajlich wrote:

    Hey Jude, please open an Issue on the node-gyp issue tracker about the
    trouble you are having while building. I haven't seen that one yet. Include
    the Windows version you are using.

    Also, once you have the compiled bindings (which you have, in
    build/Release/node_sqlite3.**node), just try firing up node and
    require()ing the node-sqlite directory (if you are in the root of the
    module, do "require('./')" ). Hope that helps!

    mscdex, if you haven't already, I recommend checking out node-gyp. It
    makes all the steps in your node-win-dev example a lot simpler.
    On Sat, Mar 3, 2012 at 1:08 PM, C. Mundi wrote:

    I may have misspoken from memory. As I sit here I do not recall the
    command to build with gyp...too much going on...I apologize if I confused
    things. TooTallNate got it working in the first place. If you're still
    having trouble when I get back on Friday drip me a note and I will get out
    my notes.
    On Mar 3, 2012 1:41 PM, "mscdex" wrote:
    On Mar 3, 2:38 pm, Jude Lam wrote:
    Thanks for the pointer on the vcbuild.bat. Since i use the Windows msi
    install file directly, it doesn't have all the source codes for
    node.

    This should be all you need: http://mscdex.net/upload/node-**
    win-dev.zip <http://mscdex.net/upload/node-win-dev.zip>
    Extract that, set NODE_ROOT to that path (not sure if it likes paths
    with spaces) and run vcbuild and you should be good to go IIRC.

    I haven't dealt with msbuild and/or gyp directly yet, so I can't
    really help you there. This vcbuild setup is just what ended up
    working for me with minimal pain/effort.

    --
    Job Board: http://jobs.nodejs.org/
    Posting guidelines: https://github.com/joyent/**
    node/wiki/Mailing-List-**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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@**googlegroups.com<nodejs%2Bunsubscribe@googlegroups.com>
    For more options, visit this group at
    http://groups.google.com/**group/nodejs?hl=en?hl=en<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<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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@**googlegroups.com<nodejs%2Bunsubscribe@googlegroups.com>
    For more options, visit this group at
    http://groups.google.com/**group/nodejs?hl=en?hl=en<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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Nathan Rajlich at Mar 4, 2012 at 8:49 pm

    node_sqlite3.node    C:\Internet_Download\TooTallNate_SQLite3\build\Release
    node_sqlite3\Release
    Why did you copy into Release and not build/Release? It worked in this
    case because of legacy purposes that node-bindings handles for you,
    but the "official" place for the modules to build into is
    "build/Release" (or "build/Debug" for debug versions of the module).

    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en
  • Lam at Mar 4, 2012 at 9:11 pm
    I just didn't know what I am doing here... LOL. I notice that node/your
    binding module is searching for the following directory when I first put
    the node_sqlite3.node file into the same directory of lib. So Release is
    one of the folder to it. I guess that I will use the proper folder under
    build/Release instead. I am just some what hacking here... Thanks for the
    tip...

    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\build\Debug\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\build\Release\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\out\Debug\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\Debug\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\out\Release\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\Release\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\build\default\node_sqlite3.node
    C:\Documents and Settings\Jude Lam\Application
    Data\npm\node_modules\node_sqlite3\compiled\0.6\win32\ia32\node_sqlite3.node
    On Sunday, March 4, 2012 3:48:56 PM UTC-5, Nathan Rajlich wrote:

    node_sqlite3.node
    C:\Internet_Download\TooTallNate_SQLite3\build\Release
    node_sqlite3\Release
    Why did you copy into Release and not build/Release? It worked in this
    case because of legacy purposes that node-bindings handles for you,
    but the "official" place for the modules to build into is
    "build/Release" (or "build/Debug" for debug versions of the module).
    --
    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 nodejs@googlegroups.com
    To unsubscribe from this group, send email to
    nodejs+unsubscribe@googlegroups.com
    For more options, visit this group at
    http://groups.google.com/group/nodejs?hl=en?hl=en

Related Discussions

Discussion Navigation
viewthread | post