Amazing Web Applications with PL/SQL and Formspider

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:

http://theformspider.com/API/api_chart.html

Intrigued? Me too! 😉

13 thoughts on “Amazing Web Applications with PL/SQL and Formspider

  1. 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.

  2. 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??

    (4.) I saw a demo on how to build an application using FS. So, for example, when you create a screen with panels and a tree menu, in the IDE, when you deploy the application, how is that tree generated?? Is it using JavaScript?

    • Hi TC,

      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.

      (4.) I When you deploy the application, how is that tree generated?? Is it using JavaScript?
      Yes. If a Formspider screen is rendered in a web browser, we use JavaScriot to render it. The key here is that Formspider application itself has zero lines of JavaScript in its source code. This enables us to render an application using pretty much any client side technology. In other words, Formspider applications do not depend on client side programming languages. (For example, we used to have a Java library that rendered a Formspider application as a Java Desktop App.)

      Hey feel free to email me by the way. I am easy to reach. Our email is on the Formsider website. 🙂

      Kind Regards,
      Yalim

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s