Re: Do APEX-installed packages include business logic?
- From: chet justice <chet.justice@xxxxxxxxx>
- To: Yong Huang <yong321@xxxxxxxxx>
- Date: Sat, 29 Aug 2009 21:16:15 -0400
>
> Is it PL/SQL based only when the developer uses the wizards?
>
No, it's all PL/SQL based. It's built on top of the web PL/SQL toolkit. If
you install it, export the sample application that is automatically
created. You'll see it's 100% SQL/PL/SQL.
If they don't use them, is the benefit of APEX (rapid development) lost?
>
No, absolutely not. I've used as little of the built-in stuff (wizards) as
possible and the RAD aspect remains. Perhaps that's a remnant of my former
J2EE days (using stored procs for *everything*). If you have an existing
application that uses packages, there are forms you can automatically
generate based on the signature of those stored procs. You'll have to
fine-tune them, but it still beats any other platform (that I have seen) in
terms of speed of development.
In 2005, I built a 350 page application in 18 months, by myself. That, for
me, is a huge point of pride and speaks volumes for APEX. If you have
strong PL/SQL/database skills, it allows you to concentrate on the
fundamentals of your application (i.e. data/data modeling) without having to
worry (much) about the front end side. But don't let that fool you, APEX is
infinitely flexible. You can do in APEX the same things you can do
(Javascript, Ajax, etc) with any other language (Java/.NET/Ruby) but far
easier.
(If you can't tell, I'm kind of a fan).
chet
--
chet justice
www.oraclenerd.com
On Sat, Aug 29, 2009 at 3:02 PM, Yong Huang <yong321@xxxxxxxxx> wrote:
> > APEX is PL/SQL based.
>
> > You "might" encounter some business
> > rule problems if you use the
> > wizards to generate the data entry screens for you.
> > ...
> > If your team develops all of
> > the data entry screens manually (instead of using the
> > wizards), then chances are that you will never have
> > a problem with Apex.
>
> Thanks, Chet and Bill. If APEX is PL/SQL based, I guess it must have
> lots of packages even a PL/SQL expert has to spend hours of time
> troubleshooting (unless he knows APEX and business). Is it PL/SQL
> based only when the developer uses the wizards? Can DBAs technically
> prevent them from using the wizards? If they don't use them, is the
> benefit of APEX (rapid development) lost?
>
> Yong Huang
>
>
>
>
Other related posts:
