node-db-oracle icon indicating copy to clipboard operation
node-db-oracle copied to clipboard

Windows Support

Open matthewcrews opened this issue 14 years ago • 19 comments

I realize that Node.js is primarily used on Unix based systems but I was wondering if this project would be made compatible with Windows. I'm forced to use a windows environment at work but I would love to start using Node.js. My work also uses an Oracle database and I have not found a way to connect to Oracle with Node.js in Windows. This project is the closest thing I've found. I understand if this is too difficult but I wanted to put the request in if it was possible.

matthewcrews avatar Apr 02 '12 13:04 matthewcrews

Supporting node-gyp would make this a lot easier.

rinie avatar Apr 15 '12 09:04 rinie

i was not aware that this is not supported in windows. since this uses internally oracle client is the port easy. or can i follow some steps to install this on windows

iragavar avatar Jun 19 '12 19:06 iragavar

Bump, for windows support. I currently run Linux where I can, but would like to develop a node.js site using an oracle db on windows at work.

kochecc2 avatar Aug 04 '12 14:08 kochecc2

Ditto for Windows Support

dracisFL avatar Sep 28 '12 19:09 dracisFL

+1

clintharris avatar Oct 11 '12 16:10 clintharris

this would be nice. poking around with node-gyp at the moment to see how far I can get.

dudymas avatar Oct 30 '12 01:10 dudymas

Would definitely like to see this as well.

aus avatar Nov 16 '12 19:11 aus

+1

jlubean avatar Dec 10 '12 19:12 jlubean

Any luck with this one? Esp if Oracle client is already installed on Win (e.g. c:\oracle\product\10.2.0\client_1\instantclient\oraociei10.dll in my case), or even via a locally set up ODBC connection (DSN or Data Source Name)?

darth-bloggs avatar Mar 20 '13 12:03 darth-bloggs

I got gyp working on this but I have been struggling with windows threading... the pthreads port I tried using is just not cutting it, and I keep finding the memory isn't being share properly. If you'd like to take a stab at getting node-gyp to build and run something, be my guest. I thiiink the version I have in master will work, though I have only tested it on one win xp machine (need to put it on win7 and win8).

dudymas avatar Mar 21 '13 11:03 dudymas

@dudymas can you do a pull request with what you have done so far?

jlubean avatar Mar 21 '13 16:03 jlubean

@jlubean Oh wow, sorry I missed this comment. If you still want it, I can make a quick pull request. I have the gyp working on windows xp and VS 2010 but I had to make a macro to swap between threadsafe date/token functions on windows and I'm currently trying to get it to compile against pthreads which is experimental. Let me know if you'd prefer I test on later systems (I have access to win 8 and VS2012 express).

dudymas avatar Apr 05 '13 04:04 dudymas

@dudymas a quick pull request would be nice. I'd prefer windows 7 and above.

jlubean avatar Apr 10 '13 18:04 jlubean

@jlubean okay. I'm testing with oracle 11g R2 XE on windows 8 with VS 2012.

My lord... first time I've tried using submodules with git. Pardon me while I punt kittens out the window trying to get this done... shouldn't be too hard... but jeez. I'm reminded of the "beat it on the head till it works" days of cvs.

I'll be branching pthread-win32 and node-db just for node-gyp. Once I get a starting point and create the pull request, we can stop discussing this here.

dudymas avatar Apr 12 '13 02:04 dudymas

@dudymas I'm interested in this as well, even the work you've done on Windows XP. Any luck on a pull request?

johannish avatar Apr 25 '13 22:04 johannish

@raztus @jlubean I had some guys locally help me with the repos and testing. I almost have the build working, but it's breaking on platform issues. Been reading through the gyp manual and tutorials... there's a handful of configs for windows 7+, and I want to say it'll just be a couple cups of coffee before I check in and pull-request.

Sorry for the delays... my company just rebranded and it was hell (cobol emailers with inline html styling? That update records so you have to reset a handful of tables with each test you run? No thank you.)

I haven't forgotten about you guys, and I want to get some ORM stuff working on a few db's. I'm conscious of how oracle also lets you put select * from table@another_db .. so I'm going to try to get node_db to also let you select stuff that way as my next venture into coding on this. Woo. (hoo?)

To be clear, again, pthreads is still breaking parallel stuff and threads keep botching on this... so there are deeper issues and node-db will be my next overhaul if you really want this to work in windows. I WILL be getting this a clang compile option, however. So instead of fixing pthreads right off the bat, I can use std::thread >:-) Mwahahahahahahah (I just got llvm to compile on visual studio, and I have clang already on cygwin... I want there to be about three or four ways for these gyp compiles to work)...(I have no life)

dudymas avatar Apr 27 '13 12:04 dudymas

@dydymas: good luck, hope you get this working!

artiee avatar May 02 '13 11:05 artiee

@artiee well, I currently have the most curious issue. It's pretty much there, but for the most confounding reasons I have yet to unearth, I'm getting file permission errors trying to include the c stdlibs from VC10, and even more infuriating... I found VC11's include directory to be completely empty!!! Searching for stdint.h on my win8 machine showed as much...

I... I'm really having a hard time believing it. And I just will have to uninstall and reinstall visual studio to see if I can fix this. At some point I may just give out what I do have and see if it works for anyone else... so far, only windows xp seem to work at all :-/ ... and I'm almost able to get clang to work so maybe I'll try that before I give up on gyp. I think if I tweaked the sln files and checked those in, it would work for sure, but then I'd be sacrificing a lot of portability (defeats a lot of the purpose of why I'm trying to get this to work).

dudymas avatar May 03 '13 01:05 dudymas

Okay... more on this. I found out after a week and a half of struggling with other things in VS2012 that a portion of my VC STL for VC11.0 was botched in a bad download. Somehow, cabinet files allow for this, and somehow microsoft is still using them. So, I had to wipe the installer completely including cached cabinet files. THEN reinstalled. Shazzam.

Now I'm resolving linker issues. I am confident again that I'm going to figure this out soon. Maybe one day. Maybe three. Geez. This is why estimates are so hard. There's a lot more variables than what you see at first. Ask your :8ball: when I'll be done, and it'll have a better answer, I guarantee. But it's close. Tasty node-gyp goodness.... can't wait.

dudymas avatar May 09 '13 21:05 dudymas