How to choose a web development framework when we would like to utilize a lot of PL/SQL program units legacy ?

Posted on 2014-11-17
Last Modified: 2015-08-09
Our team is considering to learn modern web development framework
with repsonsive feature for future development,
currently we have a lot of PL/SQL program units (Stored procedures, functions and packages),
we think front-end using bootstrap (The UI style is great) would be nice,
but do not know how to choose the backend framework to match with that,
especially we need to integrate the PL/SQL stored programs,
and also we are suggested to make a survey on Zurb foundation,
please compare them also if you have any opinion between bootstrap and foundation.

please advise, thanks !
Question by:Vincent Cheng
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
LVL 43

Expert Comment

ID: 40461102
currently we have a lot of PL/SQL program units (Stored procedures, functions and packages),
we think front-end using bootstrap (The UI style is great) would be nice,
but do not know how to choose the backend framework to match with that,

There's a few things to consider:
1) Your team's skill level when it comes to working with front end UI
I personally haven't used Zend but having had done a bit of research it does look to be for all intents and purposes the same as bootstrap.  So does your team have html/css/js skills?  Bottstrap is right out of the box with the basics when it comes to html/css/js.  Then you can move into more complex extensions such as SASS, LESS that assist in the development process.

2) What do you need the framework to do for you?
Do you need a responsive website?  Do you need everything that Zend offers or just the basics that bootstrap does?

3) Your own experience using UI technologies
You don't want to reinvent the wheel so to speak by managing the large learning curve of a new technology, only to discover that it wasn't that far removed from what you already knew.

I've personally used bootstrap quite a bit and the documentation for it is well presented and easy to follow.  There is example code for each component so you're up and running very quickly.

All that said, we can move onto the server side, to integrate with your PL/SQL database.  What comes to mind first is that you're obviously all well versed in Perl.  Perl can be used to serve a webpage as well as pull data from a database and display it.  However, given you're asking this question in the first place, I take it you weren't aware of Perl being able to do this?
There are other options such as PHP, .NET (C#, VB etc) as well as Ruby, Java and many others.  PHP is by far one of the most used technologies when it comes to developing websites.  Again it comes back to your own experiences and programming skill as each language has it's pros and cons but also its own lexical style.
On top of languages such as PHP and .NET are frameworks that assist development and logical grouping of your code.  One that I've used a fair bit is CakePHP ( that separates the front end from the database using a separate "middle man" called a controller.  It's all written in PHP but you should weigh up whether it will bloat (add more code than you need) your site more than it's worth.  More on that if you're interested.

This question is along the lines of "how long is a piece of string" but you can narrow it down for me by describing exactly what you need to do with your SQL data.  e.g. do users need to update data from the webpage, will they require a login to use your site?  If you're simply showing the data with little or no input from a user then that has an impact too.

Author Comment

by:Vincent Cheng
ID: 40466009
Thanks for the reply, Rob.

Yes, you're right, let me describe more about our current situation.

Our current skill set is mainly at only PL/SQL, Oracle D2K, Java (but not quite familiar), but it still acceptable for us to learn something new, as you mentioned, try not too far, and that's why we are carefully surveying which to choose.

As mentioned, what we need is to integrate existing PL/SQL programs in Oracle database, for example, we have some PL/SQL packages which could do the validation, data process things, I think most server-side framework must have some mechanism to deal with basic CRUD stuff, and that's definitely fine with us, but besides that, could you tell us more about how most server-side frameworks co-work with PL/SQL programs ?

Example scenario :
like before inserting into a new record into a table, must call a PL/SQL function and passing some column values as parameters into this function to validate whether this record is allowed to be inserted.
LVL 43

Expert Comment

ID: 40466072
how most server-side frameworks co-work with PL/SQL programs ?
When it comes to CRUD with server side frameworks, I'm mainly dealt with PHP.  It is as simple as a function call to interact with a database or send data to the browser.  

However, given you have your scripts in PL and PL can also be used to serve webpages, why would you not start there:  Your webpages can call the required Perl CGI scripts to interface with your database.  

Keep it simple and use Perl.
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users


Author Comment

by:Vincent Cheng
ID: 40517651
Thanks, Rub, sorry for the late reply.

Excuse me for my lacking knowledge for the web technology, is that possible to give simple examples for using Perl CGI to interact with a PL/SQL function that returns with a record type value, and compared with others language (PHP, JSP, Rail) to do the same thing ?

Sorry I know it might be quite a lot effort to do this, or should I create additional questions on requesting samples for each language separately ?

Merry Christmas and best wishes !
LVL 43

Expert Comment

ID: 40520154
To do it in Perl will mean you don't have to rewrite the code in PHP, JSP, Rails etc.  i haven't used Perl that much but I understand what you're trying to achieve.  

The PL/SQL code becomes part of the CGI:

In the link, there are quite a few examples of how to post data to a perl cgi (specifically the example under "Cheap Database Output").  It shows how to take data posted from the client's browser along with interacting with a database.

In a sense, all you'd need to do is integrate the CGI component with the existing scripts, literally by combining the code.  Are the scripts you have encompassed in classes or objects that you could call from a CGI script, much like "DBI->connect" in the example?

Hard to know without seeing a sample script and what you want to happen with that script based on some input from the client.

Author Comment

by:Vincent Cheng
ID: 40864808
OK, thanks, Rob, we will prepare some sample codes for better understandings, will get back to you as soon as possible.
LVL 43

Accepted Solution

Rob earned 500 total points
ID: 40864844
Thanks, appreciate that. Given this was more than 6 months ago it would usage me some time to come back up to speed. If you can come back when you're ready to work on it full time, that would be best

Author Closing Comment

by:Vincent Cheng
ID: 40921968
Thanks, Rob, will be back with samples in another new created question, see you there.

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr… provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question