noradle

Want to build solid information system solely on PL/SQL and javascript easily,
no rely on any other programming language or technical stack? develop with NORADLE.

!NORADLE

What's NORADLE?
=================

The word NORADLE is combination of node.js and oracle,
It aims at

1. write http servlet in PL/SQL with extremely concise code
2. with node.js as http gateway, give full http protocol support for oracle environment
3. node.js accessibility to oracle, give node.js ecosystem a real thustworthy db backend

take a first glance at pl/sql servlet code
==========================================

$3

``plsql
procedure bind_data is
cursor c_packages is
select *
from user_objects a
where a.object_type = 'PACKAGE'
and rownum <= 5
order by a.object_name asc;
begin
b.l('');
o.t('');
o.t('');
o.t('

');
o.t(' ', o.t('', m.w('', 'package name,created')));
o.t(' ');
for i in c_packages loop
o.t('');
o.t(' ');
end loop;
o.t(' ');
o.t('

', 'bind sql data to table example');
o.t('

@
', i.object_name); o.t('	', t.d2s(i.created)); o.t('

');
o.t('');
o.t('');
end;
`

$3

`plsql
create or replace package body chart_b is

procedure common_preface(default_type varchar2) is
v_chart_type varchar2(30) := r.getc('chart_type', default_type);
begin
src_b.header;
o.u('', '[animate.css]');
o.u('');
end;

end chart_b;
``

What NORADLE provide?
=====================

* NORADLE support full dynamic(data driving) web development(whether for html page service or json data service),
but more concise than PHP, J2EE, ...
* NORADLE NDBC make node ecosystem embracing oracle, expand node's realm to serious enterprise information systems
* NORADLE call out feature extend oracle PL/SQL to access external service/resource, break restrictions

Core thinking
==============

* use pl/sql stored procedure to implement application/business logic
- servlet code that access data should be as close as the data, avoid complexity and develop-time and runtime overhead
- all SQL should be in PL/SQL stored procedure, no string concat, no network transfer
- no triditional templating, print html/json with concise API, just use pl/sql, introduce no excessive templating language
- give all function that a triditional servlet tech can provide, but be more concise and easier to master
- be aware of that middle layer JAVA/PHP/.NET/PYTHON/RUBY... is superfluous, except adding comlexity
- enjoy the good of oracle, advanced SQL, availility, stability, performance, scalability, tunable...
* node.js can access oracle, and vice versa, they can aid each other
- node.js give oracle a http servlet container environment
- pl/sql can call out by node.js, extending oracle
- by node.js, oracle became a full servlet container, integrate code and data seamlessly
- by connectivity to oracle, node.js ecosysetm will extend to the area of enterprise information system

the resource for NORADLE
========================

$3

$3