Wednesday, April 01, 2020
Log in

Log in

You are a JavaScript or a Python developer and you don't know Informix?



Are you a JavaScript / Node JS developer or a Python developer? In that case you are probably doing like so many colleagues, that is using the so famous DBMS's I won't even pronounce the names here. So sad you are thousands and more developers competing with the same stack, just because the others feel forced to do that way.

Competing with the crowd is tough, exhausting, costly and, unless you are among the very best worldwide, (which I wish for you), you'll have to deploy a lot of efforts, often with zero fun or close to that, for what result at the end?

When you build an application on top of Informix, you don't code on whatever DBMS, you are coding on the most versatile and advanced DBMS in the market place today!

Informix is HYBRID: Informix understands SQL and NoSQL (99+% compatible with MongoDB): it even allows you to run queries SQL style against NoSql collections and/or query SQL data in mongodb style. It even allows you to run joins between NoSql and SQL data in the same query!

Informix has been tailored for IoT for almost 20 years: no kidding, Informix has been totally visionnaire when in 1998, the company released the TimeSeries datablade for Informix. TimeSeries(c) is just the best ever implementation of time stamp based data management and storage. The world is just discovering it now and major industry leaders now don't want anything else. Discover it and you will see how easy it is to handle time stamp based data in the most efficient way.

The same Informix that runs on big systems serving many thousands of OLTP users runs the same way on so-called "gateway devices", built on top of ARM processors such as Raspberry PI (tm), or Intel Quark (tm) based devices. Same functionality, same reliability.

Informix is robust: run the most demanding NoSQL applications within a bullet-proof Informix infrastructure, along with OLTP applications on the same server (or in an elaborate replication ) which in addition will perform way better than open-source DBMS, providing drasting cuts in hardware requirements!

Informix has the most versatile data replication built-in system: this means you can implement very easily the most demanding and complex data replication schemas you could imagine, in a very consistant, easy to maintain and reliable way. No need to write brain-killer and probably fragile replication applications, just set them up and live happy!

Informix, using the REST protocol, can communicate directly with Browser applications or any device using REST.

Informix also has a MQTT listener, which is a great asset for IOT applications: Informix can collect and send data directly from/to devices using MQTT. Just set up the listener and that's it!

And finally, you can use the native Python and JS drivers to build your applications in you favorite language, taking benefit of all the functionality that the jewel provides.

Your will find those native informix drivers here:
The open Informix DB drivers:

The JavaScript driver

The Python Driver:

The experimental R driver:

And you will want to install the Informix free Developer Edition:

Or the Docker image:

Stand out of the crowd, have fun, live well and build state of the art applications: develop on Informix!IFMXsig

Informix 4GL is modern

Yes, I know, this looks crazy. Who is nuts enough to publish such a statement?

 Well, the debate is not as simple as it looks. IT marketing is often a steamroller which ignores details that are important for the for the potential buyer, since the only goal is to sell, no matter the final result for the customer.

Just like we have been constantly hearing that the mainframes have disappeared since the 80′s, Informix 4GL is still present and working in numerous companies. Their main issue nowadays is not that their applications do not work, it is that the legacy 4GL has not a proper GUI and interfaces poorly with other subsystems.

These issues are often the reason why many of those companies consider quitting the 4GL technology, despite all the advantages of this language:

  • it is a real structured language,
  • it has a native interface with Informix DBMS
  • Forms and Reports clearly make coding easier and faster
  • It can embed custom C functions
  • the language is clear and easy to read: who understand english understand a 4GL program sourcecode.
  • It works, very well, thank you!

The IT world has run a long distance since the 80′s, and new languages and IDEs offer lots of irreplaceable new features such as GUI, object oriented, web deployment and many more. But where is the real progress here, I mean where is the real added value for YOUR company’s operations and developers ? Do they develop faster and better, is maintenance cheaper, are end users happier?

These real questions lead us to think twice, and probably conclude that the new stuff is mainly cosmetics, crtainly not cheaper to develop and maintain, and are not in depth progress. Thus the possible conclusion: I keep using my legacy 4GL applications because they work!

Now, the good news is that there is an excellent way to step over those limitations and put your 4GL applications back on track in terms of technology advance.

This presentation will give you avenues for reflection about this critical matter, and will help you yo understand there is a solution that you should not ignore.

New Gartner analysis talking about ‘legacy’ databases retirement

Mr Donald Feinberg is a vice president and distinguished analyst in Gartner Intelligence in the Information Infrastructure group,  and responsible for Gartner’s research on database management systems and data warehousing infrastructure. Concerned by a recent analysis stating that so-called legacy DBMS like Sybase and Informix would retire in 2015, he brings in this document a faithful analysis based on factual reply to this denigration campaign, which is probably organized by the competition and/or companies that fear Informix and Sybase.

No, Informix will definately NOT retire in 2015, nor within many years. Sincerely, I hardly should understand how a RDBMS that has just been chosen by the government of the Popular Republic of China as unique RDBMS technology for their facilities, would retire in 2015. Either those specialists of denigration are not aware about that important notice, or they do not want to accept a truth that hurts them.

Please check this document. Read until the end.

Where Is Informix ?

The history of Informix is a strange and controversed history: since 2001 many rumors have spread in the IT cosmos and the visible situation is not clear for everybody.

You do not want to miss that deep insight of Informix history since Golden Age to March 2014, featuring a summary of its releases since 9.30 showing the evolution of the product.

You will like to understand how and why Informix is firmly alive despite nasty comments going by, and still has a long way to go.

Click here to learn more about this fascinating and sometimes passionate history.