Lam | 1 Mar 04:03 2012
Picon

Re: Building node-sqlite for Windows

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 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
C. Mundi | 1 Mar 16:50 2012
Picon

Re: Re: Building node-sqlite for Windows

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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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

> sqlite3 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Jude Lam | 1 Mar 17:31 2012
Picon

Re: Re: Building node-sqlite for Windows

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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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

> sqlite3 <at> 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 <at> 2.1.1

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

C. Mundi | 1 Mar 18:30 2012
Picon

Re: Re: Building node-sqlite for Windows

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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge <at> gmail.com> 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

> sqlite3 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Jude Lam | 2 Mar 01:22 2012
Picon

Re: Re: Building node-sqlite for Windows

Thanks!  I will give this a try.

Sent from my iPhone

On Mar 1, 2012, at 12:30 PM, "C. Mundi" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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

> sqlite3 <at> 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 <at> 2.1.1

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

Jude Lam | 3 Mar 15:20 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <cmundi <at> gmail.com> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge <at> gmail.com> 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

> sqlite3 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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


--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Jude Lam | 3 Mar 16:06 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge <at> gmail.com> 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

> sqlite3 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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





--
================================================================================
Jude Lam, CEO
LForge, LLC
Mobile: 865-300-4829


--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
C. Mundi | 3 Mar 17:20 2012
Picon

Re: Re: Building node-sqlite for Windows

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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <judelam.lforge <at> gmail.com> 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

> sqlite3 <at> 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 <at> 2.1.1

npm ERR! sqlite3 <at> 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 <at> 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 <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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





--
================================================================================
Jude Lam, CEO
LForge, LLC
Mobile: 865-300-4829


--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
mscdex | 3 Mar 16:16 2012
Picon

Re: Building node-sqlite for Windows

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.

Jude Lam | 3 Mar 20:38 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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


--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
mscdex | 3 Mar 21:41 2012
Picon

Re: Building node-sqlite for Windows

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

C. Mundi | 3 Mar 22:08 2012
Picon

Re: Re: Building node-sqlite for Windows

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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Nathan Rajlich | 3 Mar 22:54 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <cmundi <at> gmail.com> 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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
mscdex | 4 Mar 01:22 2012
Picon

Re: Building node-sqlite for Windows

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

Lam | 4 Mar 20:31 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Lam | 4 Mar 20:53 2012
Picon

Re: Re: Building node-sqlite for Windows

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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Nathan Rajlich | 4 Mar 21:20 2012
Picon

Re: Re: Building node-sqlite for Windows

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 is "lib/sqlite3.js". Now the fork that I made of node-sqlite3 that has gyp support, I used node-bindings to require the compiled node_sqlite3.node file. 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 <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Lam | 4 Mar 21:38 2012
Picon

Re: Re: Building node-sqlite for Windows

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 is "lib/sqlite3.js". Now the fork that I made of node-sqlite3 that has gyp support, I used node-bindings to require the compiled node_sqlite3.node file. 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 <judelam.lforge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <cmundi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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" <mscdex-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
On Mar 3, 2:38 pm, Jude Lam <judelam.lfo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe <at> 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
nodejs+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
Nathan Rajlich | 4 Mar 21:48 2012
Picon

Re: Re: Building node-sqlite for Windows

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

Lam | 4 Mar 22:11 2012
Picon

Re: Re: Building node-sqlite for Windows

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

Gmane