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

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 !
Vincent ChengSr. Project ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RobOwner (Aidellio)Commented:
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.
Vincent ChengSr. Project ManagerAuthor Commented:
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.
RobOwner (Aidellio)Commented:
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.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Vincent ChengSr. Project ManagerAuthor Commented:
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 !
RobOwner (Aidellio)Commented:
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.
Vincent ChengSr. Project ManagerAuthor Commented:
OK, thanks, Rob, we will prepare some sample codes for better understandings, will get back to you as soon as possible.
RobOwner (Aidellio)Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vincent ChengSr. Project ManagerAuthor Commented:
Thanks, Rob, will be back with samples in another new created question, see you there.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.