1 2 3 Previous Next 37 Replies Latest reply on Aug 21, 2019 1:56 PM by jaramill Go to original post
      • 30. Re: Future of PL/SQL
        Moh

        Hi,

        PL/SQL packages are a part of whole our application landscape. We transform whole landscape to Cloud. An open question for me is, what is correct approach for our PL/SQL Packages?

        Is there any doc/statement available as "Best Practice" migration to cloud?

         

        Regards,

        Moh

        • 31. Re: Future of PL/SQL
          cormaco

          PL/SQL packages are a part of whole our application landscape. We transform whole landscape to Cloud. An open question for me is, what is correct approach for our PL/SQL Packages?

          Is there any doc/statement available as "Best Practice" migration to cloud?

          You have to be more precise. What Cloud? Which product of which vendor is this about?

          If there is an Oracle database included, keep your packages.

          • 32. Re: Future of PL/SQL
            Billy~Verreynne

            Just how is the SDLC different when the server is cloud based, and not bare iron?

             

            Why would PL/SQL code, design, and implementation, differ? Why would another language, or approach, be better?

            • 33. Re: Future of PL/SQL
              L. Fernigrini

              The main difference between an on-premise and cloud environment are usually:

               

                   1) Cloud allows for flexibility to add / remove hardware as needed

                   2) Cloud environment can be handled (backup, patching, etc) by the cloud provider (but you may decide to use just the cloud "infrastructure" (just the "hardware") , and you have to install / upgrade / maintain the software your use).

               

              But whatever you are currently doing with data in your on-premise site, you will probably do on the cloud. What is more, right now you may have some things done on an app server or even on the UI, that you will prefer to do directly on the DB server side (using PL/SQL) to avoid traffic between DB Server and App Server, or even UI (since traffic, even between servers, is usually paid on Cloud environments)

              1 person found this helpful
              • 34. Re: Future of PL/SQL
                jaramill

                AndrewSayer wrote:

                 

                And look who gets money thrown at them... although with very little to show for it.

                I'm too young to be bitter

                Oh now THIS made LOL early in the morning.....sad but true Andrew!

                • 35. Re: Future of PL/SQL
                  Moh

                  Hi cormaco

                   

                  >>You have to be more precise. What Cloud? Which product of which vendor is this about?

                  --> We are in conception phase and need to evaluate different solutions. (Oracle Cloud too)

                   

                  Thanks again about all feedbacks.

                   

                  Regards,

                  Moh

                  • 36. Re: Future of PL/SQL
                    Billy~Verreynne

                    MansiRaval wrote:

                     

                    Not sure about the context "new and modern technologies" mentioned by Moh,

                    but we too in our Jobs being Pl/SQL developer, keeps hearing PL/SQL has no future and it going to be replaced by Big data and other technologies soon.

                    But as I have no detail knowledge on new technology, can not comment on such statement.

                    The Oracle RDBMS product will not discontinue PL/SQL. Any such suggestion is ridiculously naive. There are many 100's of millions of lines of PL/SQL code in Oracle database products (many commercial), and in customers' production databases.

                     

                    Look at one of the hottest Oracle database products, APEX (Application Express). Its market growth over the last 10 years have been significant. It is a web-based client-server framework - written entirely in PL/SQL, and delivering in features, flexibility and performance. And if one takes some time to understand the complexities of stateless client-server, one would realise just wtf PL/SQL is capable of, and the level of integration of PL/SQL with the database kernel.

                     

                    Thus, as long as the Oracle RDBMS has a market as a product, the need for PL/SQL development and experience will exist.

                     

                    As for Big Data. This is not a concept that is not supported by the Oracle RDBMS (and its SQL and PL/SQL languages). So says my Oracle database that analysed over 15TB of (mostly sampled 1-in-10) IP traffic, from 16,032 routers, for 459 VPNs, yesterday  alone.

                     

                    Oracle, SQL, and PL/SQL, are extremely capable. Unfortunately the same cannot be said of many developers, doubting or blaming technology due to their ignorance of that technology.

                    1 person found this helpful
                    • 37. Re: Future of PL/SQL
                      jaramill

                      Billy~Verreynne wrote:

                       

                      Unfortunately the same cannot be said of many developers, doubting or blaming technology due to their ignorance of that technology.

                      Well said.  It's management that throws around "buzzwords and hype phrases" then newbie developers think that they gotta jump on the new hottest technologies thinking PL/SQL is outdated.  Fools...

                      1 2 3 Previous Next