IBM i Global

 View Only
  • 1.  CRUD (create, read, update, delete) applications on IBM i

    Posted Thu July 14, 2022 07:20 AM
    Hi all,

    Does anyone know some CRUD software in python or nodejs can be working on IBM i?

    something like this one:

    GitHub - IBM/crud-using-nodejs-and-db2: Create CRUD application using Node.js and IBM Db2 Database on Cloud
    GitHub remove preview
    GitHub - IBM/crud-using-nodejs-and-db2: Create CRUD application using Node.js and IBM Db2 Database on Cloud
    This is an application which uses Node.js to connect to IBM Db2 Warehouse on Cloud for CRUD(create, update, delete) operations. The application showcases how you can create a high performant CRUD application using Node.js and IBM Db2 Warehouse on Cloud. Create schema and tables necessary for storing data in IBM Db2 Warehouse on Cloud.
    View this on GitHub >


    Today I assist to a presentation of a software than read 5250 to create browser output. But for me this is not really interesting, our 5250 screens are very basic, only for CRUD operations with some check. Obviously the software of this presentation doesn't require a lot of works, but for me this is not the solution.

    If there's some software the consent to me to make CRUD operations on DB2, I think it could be a new base to rewrite my display file to a browser.

    Many thanks


    ------------------------------
    Paolo Salvatore
    ------------------------------


  • 2.  RE: CRUD (create, read, update, delete) applications on IBM i

    IBM Champion
    Posted Fri July 15, 2022 03:42 AM
    Edited by Gautier DUMAS Fri July 15, 2022 03:43 AM

    Hi Paolo, 

    Could you consider PHP in addition to Node and Python ? 

    We have developed a PHP micro framework "Skeleton" (Skeleton - CFD-INNOVATION

    ) that allow us to generate two applications that communicate with each other : 

    - RESTFull API in PHP for CRUD operations

    - FrontEnd PHP HTML/CSS/JS which consumes APIs

    Everything is customizable by developing PHP on top. 

    You also have solutions like  https://phpgrid.com/ that do the job.



    ------------------------------
    Gautier DUMAS
    ------------------------------



  • 3.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Fri July 15, 2022 03:54 AM

    Hi PAOLO,

     

    You can see www.aumerial.com

     

    Best regards,

     

    Laurent ROUILLOT

     






  • 4.  RE: CRUD (create, read, update, delete) applications on IBM i

    IBM Champion
    Posted Fri July 15, 2022 05:18 AM
    Edited by Satid Singkorapoom Fri July 15, 2022 05:22 AM
    Dear Paolo

    For Node.js, please explore Mr. Scott Klement's presentation and sample codes here to see if it helps or not : https://www.scottklement.com/presentations/    Use Ctrl+F with "node.js" to locate the entry in the web page.

    Do a Google search with "ibm i node.js" and you will find more.

    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 5.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Fri July 15, 2022 10:21 AM

    Hi Paolo

    Check out https://www.profoundlogic.com/
    I use the software. They have CRUD software for 5250 greenscren, WEB, and as api webservices.
    BR 



    ------------------------------
    Poul Thomsen
    ------------------------------



  • 6.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Fri July 15, 2022 10:22 AM
    Paolo:
               You can create a crud in many languages and techologies ¿whta do you want to achieve?
    You want to make a crud in a green tn5250 screen? or you want to create a GUI screen by using Web technologies?
    Becasue the answer will depend on it.
                 If you want to create Web Based GUI's , I will recommend OpenXava (Java Web Development, with a chapter specific on connecting to IBMi  https://www.openxava.org/es/)

                 If You wan't to use green screen I can send you a base program that yo can tewak and extend as you need.

    ------------------------------
    Santiago Ottonello
    ------------------------------



  • 7.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Fri July 15, 2022 10:34 AM

    Hi,

    it's time to change, the old boss (than always love 5250 and IBM i) is retire, so the new bosses look at 5250 as something old, 

    they have look at Presto by Fresche, but for our internal users I'll prefer something more different from rewrite a green screen to browser, obviously the Presto solutions is faster, because I can reuse the green screen, but I'd like to look for something different...



    ------------------------------
    Paolo Salvatore
    ------------------------------



  • 8.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Mon July 18, 2022 09:47 AM
    Paolo,
    Check this out, this might help you. I have set this up and tested it. I believe I had to make a few changes but it's a good example of a CRUD application that is web based using node.js. @Andy Youens built this and might have some input if you need it.

    https://powerwire.eu/a-nodejs-website-on-ibm-i-final-version
    ​​

    ------------------------------
    Matt Seeberger
    Power i Engineer
    CMA Technology Solutions
    ------------------------------



  • 9.  RE: CRUD (create, read, update, delete) applications on IBM i

    Posted Mon August 29, 2022 03:31 AM
    Hi Matt,

    tha's very interesting, I'd like to study and try it.

    Many thanks.

    ------------------------------
    Paolo Salvatore
    ------------------------------