20 April 2017

Oracle RENO

Oracle RENO

R = REST
E = Express
N = Node.js
O = (Node)OracleDB

I've read an article about an REST Api with Node.js and Node-OracleDB at the website of Amis and at the website of Sivakumar Balagopalan.

This inspired me to write a application on the employee table inside the HR schema. The url http://machine:3000/employees fetches all rows in the employees table.

 The url http://machine:3000/employees/200 fetches the employee with employee_id 200 from the employees table.

I implemented the following:

POST /employees Create a new employee
GET /employees Read all the employees
GET /employees/:employee_idRead the employee with the given employee_id
PUT /employees/:employee_id Update the employee
DELETE /employees/:employee_id Delete the employee                         

Now I'm able to show the result inside an Oracle JET application:

19 April 2017

Setting up a development environment


I'm setting up a new development environment so I can do some development with JavaScript, ApEx and REST.

Gitlab on Raspberry Pi
I've a Raspberry Pi 3 and followed the installation instruction on https://about.gitlab.com/2015/04/21/gitlab-on-raspberry-pi-2/. After the installation I have a working gitlab on the Raspberry and I created new projects inside gitlab. 

Pre-installed appliance
I've downloaded the "Network Applications VM" from Oracle Technet. The appliance contains the following: 
  • Oracle Linux 7 
  • Oracle Java JDK 7 and 8
  • Oracle Database XE 11g
  • Oracle Enterprise Pack for Eclipse
  • I updated the Oracle Linux with the latest patches and then I downloaded a new version of Oracle ApEx (5.1.1) since a older version is part of the XE database inside the appliance. I also downloaded ORDS (Oracle REST Data Service)  for the access to ApEx and setting up REST.

    Additional Software

    I downloaded some additional software and installed it inside the appliance
  • Netbeans 8.2
  • Visual Studio Code (for Linux)
  • Postman (for calling REST)
  • Oracle SQL Developer (4.2)
  • DBeaver
  • NodeJS