Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Stacey.

Asked: March 01, 2018 - 5:17 pm UTC

Last updated: March 02, 2018 - 11:56 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

We currently have a read-only application written using MOD PL/SQL. Our agile development group is recommending using angular JS for the AX/AI development, and NodeJS on a Happi framwork. the database is currently Oracle 11.2.0.4. We hope to upgrade in a few months to Oracle 12.1
I have read your recommendations that states:
Data logic processing : pl/SQL

Can you please give some insight on the recommendations? IS this an optimum choice connecting to an Oracle database?

and Chris said...

You can use Node.js on the mid-tier to call PL/SQL. And keep your data processing logic in the database.

In fact, if you've built PL/SQL packages right, you just need to make calls from Node.js to PL/SQL. No need to re-code all your SQL!

If you want to know more about using JavaScript with Oracle Database, my colleague Dan McGhan has several articles on his blog, JavaScript and Oracle:

https://jsao.io/

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Great feedback but had follw up questions

Stacey Cardin, March 01, 2018 - 5:44 pm UTC

Thank you for your very quick response. What are your views about using angular JS for the UI development and NodeJS on a HAPI framework. I need verification and feedback for an optimum development stack for oracle.
Units of development is also going to be contained in dockers.

Thank you
Chris Saxon
March 02, 2018 - 11:56 am UTC

I'm a data guy. I don't have an opinion about UI tech ;)

There isn't a single "optimum development stack" for Oracle Database. The appropriate UI technology depends on many things. Such as the nature of the application, skill and knowledge of your developers, etc.

If you're concerned, ask the development team to explain their reasoning for choosing this stack. Hopefully, they'll be able to give you better reasons than "everyone else is doing it" or "it looks good on my CV".
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library