Please Help: Trying to Build RELEASE for Windows with VS Express C++ 2010 about node-sqlite3 HOT 7 CLOSED

I'm not aware of how to get a working Release build out of the existing Visual Studio file, so I just went with a gyp approach and upload my build to https://github.com/developmentseed/node-sqlite3/downloads.

from node-sqlite3.

the 'vcbuild.bat' is a hack that uses the gyp file I just added (undocumented). I can document how to utilize it on Monday. Ping me then, as I'm out for the weekend now.

from node-sqlite3.

Thanks! (And that for the phenomenally quick reply!) Have an excellent weekend! -- Carlos

from node-sqlite3.

Adding some notes for discussion on Monday.

Clean start. Grabbed the node 0.6.7 sources and built node in Release (' vcbuild.bat release' ). Works.

Downloaded a fresh copy of the windows branch of node-sqlite3. Still using VS GUI for node-sqlite3 build.
Made usual changes to project settings (disable precompiled headers, add include and lib paths, rename target to have .node extension instead of .dll extension)
Good: node-sqlite3 compiles and links in Release.

Copied the node-sqlite3.node to %HOME_DIR%\test\node_modules.
Tried to run the example on the node-sqlite3 homepage. FAIL!
Node says: TypeError: Object # has no method 'verbose'
So I remember that the Windows branch may differ from the master branch. Try this:

var s = require('node_sqlite3'); // ok
var d = new s.Database(':memory:'); // FAIL

The error is...

 undefined:0


 TypeError: undefined is not a function

and node terminates abnormally. Back at the command line, I'm not sure where to start looking.

I remember the warnings I saw when building node-sqlite3 about (not having) __declspec(dllexport) on templates within classes which do have __declspec(dllexport) decoration. I'm 90% sure that's cosmetic, as usual.

Next I do a full-tree diff between the master and windows branches of node-sqlite3. All the windows #ifdefs look good. Verified that VS really is building with _WIN32 to get the right threading model.

Looked at the new gyp stuff. Tried. I seem to be missing something. Will definitely need to ask springmeyer.

Encouraged, but not quite feeling the node-on-Windows love yet. :)

from node-sqlite3.

you need to make sure the node_sqlite3.node is copied into the lib folder and then you should put lib on your $NODEPATH. Then you do require('sqlite3');

from node-sqlite3.

Aha. I suspected (from grepping) for 'verbose' and learning that's
implementation was js stored in /lib) something like this. Thanks. I will
try this!
On Jan 10, 2012 8:18 PM, "Dane Springmeyer" <
[email protected]>
wrote:

you need to make sure the node_sqlite3.node is copied into the lib
folder and then you should put lib on your NODEPATH. Then you do
require('sqlite3');

---

Reply to this email directly or view it on GitHub:

#55 (comment)

from node-sqlite3.

Success!!! Sure enough. I missed (1) that having the js files in /lib is critical and (2) the name to 'require' depends a little on how which step in node's search logic finds it. Awesome. Thanks!

from node-sqlite3.