Informix

 View Only
  • 1.  Anyone using Informix 4GL Web Services ?

    Posted Wed February 21, 2024 05:01 AM

    Hi community,

    evaluating functionality for a customer, I was just wondering whether Informix 4GL Web Services has ever been used anywhere in a production system / real life.

    Any comments and recommandations about it?

    Thanks
    Eric



    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------


  • 2.  RE: Anyone using Informix 4GL Web Services ?

    Posted Wed February 21, 2024 03:34 PM
    Bonjour/Bonsoir Eric,

    I was curiously waiting to see some answers on this question but I have not seen any so I will send my comments.

    We have been very actively working on web services for the past 10+ years for our clients.  I circled around and played with Informix-4GL web service functionality as it was going to make sense for some projects/systems, however all of a sudden we found ourselves working with Genero for creating web service code, both on the server side and the client side.  These have been running in mission critical  production environments for several years now.  We never got to use Informix-4GL web services in a production setting which I believe your main question is about but since Genero is Informix-4GL syntax at its base, I thought I would share our experience on this - Genero with web service code has been working very well.  We also have been writing web service code in Java and C#.NET to work with Informix and other databases.  One fact with web services is the frequently changing standards, security requirements and these lend themselves more to frequently maintained/updated software.  Informix-4GL works beautifully as we all know for many things, especially business logic and other back end functions (and one important reason they added web service functionality, I believe, was to easily expose such back end functions as web services), however we are not seeing new releases very frequently with it any more and that would be a concern for me if used in a web service setting.  Genero (as well as Java and C#.NET) are being maintained with frequent new releases.

    Regards,

    Hal Maner
    M Systems International, Inc.





  • 3.  RE: Anyone using Informix 4GL Web Services ?

    IBM Champion
    Posted Thu February 22, 2024 08:16 AM
      |   view attached

    Hi,

    Informix Web services solution has been in the Informix 4GL product for some time. However, it has not evolved  for at least 15 years .

    • does SOAP and not REST
    • does not scale
    • monothreaded
    • does not handle a large load and not geared towards real life web intensive environment

    We at ConsultiX offer a solution "ConsultiX Web Services Server"  that allows to use your existing 4GL code without without porting it nor rewriting it:

    • Allows you to create RESTFUL 4GL web services with a minimal development effort.

    • Easy to implement: no need to install and configure a Web application server - install our ConsultiX Web Services Server and go
    • REST protocol ( GET, POST, PUT, DELETE, HEAD ...)
    • Native in the sens that it allows to use your existing 4GL code (100 % code reusable) without duplicating it or rewriting it
    • Easy Maintenance: no maintenance needed when you modify existing the 4GL functions since it uses the same code
    • Compatible with the compiled version of 4GL
    • Mulltithreaded
    • Highly scalable
    • Secure: includes the OpenSSL library with its SSL/HTTPS protocol, so that you can encrypt data exchanges between the web services and the external world
    • Able to communicate with external applications (such as SAP) or existing JAVA or DotNet web services.

    • Performance and Robustness: tested with millions of requests with hardly any increase in response time

    Check the brochure attached for more details.
    • @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;}p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman",serif; mso-fareast-font-family:"Times New Roman"; color:#212120; mso-font-kerning:14.0pt; mso-ansi-language:EN-US; mso-fareast-language:EN-US;}.MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-font-kerning:0pt; mso-ligatures:none; mso-fareast-language:FR;}div.WordSection1 {page:WordSection1
    Cordialement, Regards,    Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr
    Le 21/02/2024 à 21:33, Hal Maner via IBM TechXchange Community a écrit :
    0100018dcd5ff6df-0f3008eb-7d1c-4831-a5a8-c74891126f59-000000@email.amazonses.com">
    Bonjour/Bonsoir Eric, I was curiously waiting to see some answers on this question but I have not seen any so I will send my comments. ... -posted to the "Informix" group



    Attachment(s)



  • 4.  RE: Anyone using Informix 4GL Web Services ?

    IBM Champion
    Posted Thu February 22, 2024 08:29 AM

    I should point out what Eric already knows, that Querix Lycia has better support for web development, both client and services, than Classic 4GL or 4Js Genero and it is fully RESTFUL and simple to use. The latest version does not even require you to rename functions to make them web accessible (previous versions required you to name such functions web_<name>). But, like recommending Genero or "ConsultiX Web Services Server", this does not answer Eric's question which was basically: Can anyone actually using or who has tried to use Classic 4GL's web services interface relate how that worked out? If you don't have a direct answer, it does not good to just promote a different solution.

    My guess is that Eric has already suggested alternatives to the client but the client wants to know about using the IBM solution before making a major decision to port their apps to another one.



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 5.  RE: Anyone using Informix 4GL Web Services ?

    IBM Champion
    Posted Thu February 22, 2024 08:49 AM

    Art,

    It seems that you are also promoting Querix in your email.

    My answer is direct

    • does SOAP and not REST
    • does not scale
    • monothreaded
    • does not handle a large load and not geared towards real life web intensive environment

    An ex manager at IBM Informix even told me not to use it since it did not scale and the labs decided not to pursue the solution.

    Our solution is another solution that customers needing this could use.

    Surprised by your answer! I tought that this could help people using exiting 4GL if the Web services is something they are looking for without the need to duplicate code. There is not need to port to anything else. That is the beauty of it.


    Cordialement, Regards,    Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr
    Le 22/02/2024 à 14:28, Art Kagel via IBM TechXchange Community a écrit :
    0100018dd100fc4f-170f4de0-b16b-4f07-98ac-071435ba2d34-000000@email.amazonses.com">
    I should point out what Eric already knows, that Querix Lycia has better support for web development, both client and services, than Classic 4GL... -posted to the "Informix" group





  • 6.  RE: Anyone using Informix 4GL Web Services ?

    IBM Champion
    Posted Thu February 22, 2024 09:02 AM

    Indeed I did "promote" Lycia. Mainly because it was the last option not mentioned. But my point stands, none of us answered Eric's question, myself included.

    Here is a close as I can come to a direct response:

    I did have one client who tried to use Classic 4GL Web Services early on. They found it hard to use, buggy at the time (there has only been a single release since and one bug patch to the feature), and that it did not perform well.

    I held off posting any answer until this morning because even that experience is not mine and I hate having to bash any Informix product. <sigh>. Fortunately 4GL Web Services is the only one I have had to in a LLLOONNNGG time.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 7.  RE: Anyone using Informix 4GL Web Services ?

    Posted Thu February 22, 2024 02:43 AM

    Hi Eric

    i think we did some tests few years ago, but not found something running fine.
    Actually WS are running with a java program interfaced with a 4GL using pipe to communicate (in a C library).
    It enables the possibility to use 4GL code for a WS.
    But the WS is managed on java side.

    Regards



    ------------------------------
    Jean Francois BOUDRY
    ------------------------------