3 ms·
I've joked in the past that my Oracle is my 5th favorite database behind postgres, sqlserver, mysql and being punched in the face, the reason isn't anti oracle
by cwmma 10y ago
I've joked in the past that my Oracle is my 5th favorite database behind postgres, sqlserver, mysql and being punched in the face, the reason isn't anti oracle hate, it's because when I've used oracle db it feels like the company is actively trying to dissuade me.
To connect from node on a mac unlike postgres, mysql or sqlserver where you just install a module (that may or may not need to compile via node-gyp) you must
1. make an oracle account
1a. make sure you prassword donesn't contain <>();%or \
1b. if your password is too long then oracle truncates them either on storage or verification but not both
1c. try get your co worker to try to log into his oracle account on your computer
1d. just use his account on his computer
2. download the various versions of instant client you need
3. follow these obtuse [1] install steps
4. add a tnsnames.ora file somewhere
5. when login fails update your host file to match the name of current host system
To say I would never use this voluntarily is an understatement, the only reason we are using this is because somebody already on oracle is handing us a wad of cash to use oracle, I don't really see those people who use it being the types who need a free trial to get onto the cloud, people use oracle because they can't quite oracle.
1. https://github.com/oracle/node-oracledb/blob/master/INSTALL.md#instosx https://github.com/oracle/node-oracledb/blob/master/INSTALL....
- ismail 10y agohaving to integrate with oracle software on a pretty regular basis I have come to realize: Oracle software is extremely complex, simple things take more effort than they should. Oracle tools are not optimized for developers of today. A key selling point to enterprises is your developers could be more productive with their point and click IDE/interfaces. These days with the tooling around open source I believe you can get things done much faster (and have done this) the code is more maintainable etc. Second disadvantage consider oracles commerce framework atg. They have their own concepts and terms for things that are in open source solutions making it confusing for developers familiar with open source frameworks. This could be on purpose to sell more consulting for partners. Next the is the cost of training and up skilling junior devs. With open source you could probably teach yourself try searching for oracle atg tutorials. Check the # of stackover flow questions vs magneto. Fourth: I have seen people who are "oracle developers" (fusion, odi, erp, atg etc) are mostly just product specialists. Give them a text editor and tell them to write something and deploy to a paas , commit to version control and they struggle. Finally the software tends to be ops heavy encouraging bad practices like no version control or automation. All of these factors are not considered in the purchase or "ROI" calculation, but some of them could seriously hurt your return. I have seen companies spend millions in implementation of an oracle product only to use < 10 % of features and the same business objectives could have been achieved at the fraction of the cost. * excuse typos on mobile