In the good old days, dynamic web applications were created using cgi-bin and C. Yes, C as in pre-C++. Today, this might seem odd or even crazy. But why not. And why not create a website using PL/SQL? Check out Formspider, a web framework that connects AJAX requests directly with PL/SQL stored procedure calls. For instance, to generate charts:
Intrigued? Me too! ;-)
13 thoughts on “Amazing Web Applications with PL/SQL and Formspider”
The horrors, the horrors …
Forget middleware, two-tier purity!!
Thank you for writing about Formspider.
Formspider actually uses middleware by the way.
The architecture of the apps with Formspider are also logically separated into three tiers (MVC).
I understand Samuel’s reaction. PL/SQL is largely a misunderstood programming language by outsiders. It’s viewed as a legacy language which is not true at all. PL/SQL is probably one of the most lively languages that is actively being developed. It actually powers the software in many many enterprises which are Oracle customers or partners.
What it lacked before Formspider is a high quality app development tool that meets the needs of today’s app developers who know PL/SQL.
Did you get a chance to see an app built with Formspider? Here is a video: http://www.youtube.com/watch?v=5gOeF6amOBM&feature=player_embedded#t=0
Not bad for a legacy programming language huh? :-)
Many thanks again for writing about Formspider. Much appreciated.
Hi Yalim, thanks for connecting! Just to get this straight, I’m genuinely intrigued. I can see a couple of very nice use-cases for Formspider and I had actually had a strange love for PL/SQL when I used to work with it. Developing jOOQ, I have come to love embedding SQL as a language in another language (Java, Scala or Groovy, so far).
How would you compare Formspider to Oracle APEX?
I’ve written extensively about Formspider vs APEX. Here are a few links:
A comparison chart: http://www.theformspider.com/compare-formspider-with-apex.php
A few features FS has that Apex don’t: http://theformspider.com/blog/2012/11/28/for-those-of-you-who-dont-want-to-wait-for-apex/
About our different approaches: http://theformspider.com/blog/2012/06/23/formspiderapex/
Formspider is an implementation of a set of principles we believe are essential to build applications for today. These principles can be applied to any technology. We just happened to implement them in PL/SQL.
BTW, I glanced at jOOQ. I loved the idea. If I ever develop a framework for Java, I’ll definitely use it. :-)
Hmm, interesting comparison pages. Note, I think you might be even more successful, if you used a slightly less pejorative, more objective tone against APEX. I understand that you’re competitors, of course… Unless APEX is really broadly considered that bad.
Does the number of downloads on this page here include trial downloads? Or are they all subscribers? http://theformspider.com/blog/2012/11/28/for-those-of-you-who-dont-want-to-wait-for-apex
Your point is well taken. I guess the reason I am so liberal with my comments is that Apex is owned by Oracle. They are big boys. They can take it. They should have done better. I would act differently if Apex was a startup or a small company.
The numbers are for trial downloads and trial Cloud sign ups. We don’t have that many paying customers yet.
As you wish…
Anyway, good luck with your venture! I’m sure we’ll meet again somehow :-)
Thanks. Best of luck to you too. Looking forward to your company page being updated. I am fairly sure we’ll be in touch, too. :-)
How long has this ‘FormSpider’ being around?? Is it a fairly new product?
Our beta was released in 2011. FS 1.0 was released in 2012.
I have some further questions on FormsSpider:
(1.) I read somewhere that FormSpider was build using FormSpider.
That is, the IDE I think.
How is this possible? Can you elaborate a little bit?
(2.) Are you saying that you did not use anything else like Javasript, CSS??
(3.) Also, how does the FS apps deployed?? Do you need a web-server??
Great questions! Please see below for the answers:
(1.) I read somewhere that FormSpider was build using FormSpider. How is this possible?
We used the Formspider framework to build the Formspider IDE. In other words, Formspider IDE’s source code is consists of:
a) Some PL/SQL code that references Formspider PL/SQL API’s and
b) Formspider XML to describe the UI and some other Formspider objects.
2.) Are you saying that you did not use anything else like Javasript, CSS??
No. This is not what I am saying. Formspider has its own JS library. What I am saying is that Formspider IDE uses the same JS library that every other application built with Formspider is using along with the same Formspider PL/SQL API’s and Formspider XML. So in theory, if you felt like it, you could build the Formspider IDE using Formspider.
3.) Also, how does the FS apps deployed?? Do you need a web-server??
Yes. Formspider is deployed to JEE compliant application server such s Glassfish or Tomcat.
Hey feel free to email me by the way. I am easy to reach. Our email is on the Formsider website. :-)