Hi Evgeny, yes I have problems uploading a file (pdf) in my post - I updated the link in my answer to point to my own server for the Caché User Group website. 


I'm using the popular JasperReports reporting library with Caché/IRIS for several years.  See my presentation on this topic from the Caché User Group how to do this: CUG - reporting with JasperReports

You have several options: using the IRIS JDBC connector is the most obvious one, but I'm also using HTTP endpoints returning XML data source to JasperReports. Works very well.

A big advantage is that you can design your reports pixel-precise using JasperSoft Studio.

FYI, you can simply use the JasperReports server community edition: https://community.jaspersoft.com/

You'll need to install JasperReports Server and JasperSoft Studio to work with the IRIS JDBC connector.



Hi Evgeny, I'm using this technique for sending e-mails (using a template engine like handlebars) in my own applications, but I don't have an easy example stripped-down to the bare essentials right at hand. But I'll write an example post how to do this as soon as I have some spare time and I'll add a link to it in this post too.

Hi Evgeny, Rob asked me to post his demo app he created as he's not around ATM.

The demo is the IRIS implementation variant of a very popular example app: https://github.com/gothinkster/realworld

The IRIS demo is at: Conduit on IRIS using QEWD.js

The app is a Medium.com clone (called Conduit) which is implemented with all sorts of front- and back-ends. Which makes it very easy to compare different technologies.



Hi John,

I'm happy to hear the course was useful for you! 

Btw, I can also recommend the YouTube channel from the Frontend Developer conference lately in Amsterdam:

You'll find a featured video there from the creator of Vue.js (Evan You) about how Vue.js will go forward. Btw, in terms of GitHub stars, the Vue.js project currently has 88k stars while React has 91k - it became quickly one of the leading frameworks and adoption is comparable to React. 

I'm also more and more convinced Vue.js is a very complementary front-end for Caché/IRIS (and a natural fit) because of it's simplicity, flexibility and feature richness:

  • simplicity: if you worked with HTML, CSS & JavaScript in a CSP page, your can write Vue.js pages too
  • flexibilty: excellent for existing (bigger) applications because you can even replace pieces of your application with Vue.js controlled fragments - no need to rewrite your existing applications completely!
  • feature rich: under the hood, it uses modern JavaScript technology in the browser (it won't work on Internet Explorer 6 wink) to make your client side application code reactive by design

It's very easy to learn and allows to bind your front-end to your back-end using the technology you prefer like WebSockets (using QEWD), REST, GraphQL, ...)

To use SQL from Node.js - keeping the advantages of both worlds (JS & COS) - I created a small helper module you can use in your own Node.js handler modules.

The way it works is:

  • you call a function/method in COS from your Node.js handler, passing all necessary parameters in

  • the helper module puts them in a temp global (this means you don't have any limits on the amount of data you pass to Caché)

  • your COS code uses the input data (parameters) in the $$$jsData("params", ...) global (I defined a macro for readability)

  • your code fills  the $$$jsData("json", ...) global with the result data (remember that JSON maps 1-to-1 on a Caché global)

  • you get the response back in you Node.js handler and you have your result data available as a JSON object ...

I released a new module for this: qewd-cos - it's explained in detail in the module how it works with a working example. This module defines a standardized way of calling your own functions in Caché - take a look at the source code to see how you can call Caché functions and return standard responses in QEWD.

Btw, you can also use QEWD in the other direction: you can call from your COS code your own QEWD REST (or microService) endpoints using HTTP calls using ##class(%Net.HttpRequest). This is e.g. very useful to send e-mails using standard NPM modules allowing you to use templating engines (like handlebars, ...). It allows you to create more advanced e-mails much easier. Or more in general, to make external Node.js modules/functionality available in Caché which is not built-in.

I completely agree - Vue.js uses the more modern features in JavaScript cleverly (btw which finally rules out IE <= 8). But anyway, Vue.js is a great initiative taken by an Angular developer to create a much faster, more natural and lighter library - keeping the good parts of Angular.

To compare them in terms of GitHub stars:

  • Vue.js: 67.437
  • Angular: 85.077 = 27.955 (version 4) + 57.122 (older version 1.6)
  • React: 75.941

Vue.js has an exponentially growing popularity, compares well to Angular but is much more compact and is nearly as popular as React (but React came out one year earlier!).

Last week I found this excellent blog article comparing the most popular JavaScript libraries and frameworks.

I must say I'm currently using React/Redux for my projects, but last week, Vue.js drawed my attention by coincidence. When I started trying out some examples, this library felt immediately like "this is it" and "why didn't someone else think of this before?" to me. It comes very close to HTML + vanilla JavaScript and the way of coding is very intuitive.

I completely agree Herman! Vue.js looks so "natural" once you start coding with it that you ask yourself the question: "why didn't I think of this before?" ...

IMHO, there's also one big difference between Angular and Vue.js: Angular is a "complete" framework in the sense that it contains all functionality you may need (what makes it big and heavy - 452 kB minified!) while Vue.js is a library for your view + business logic (what makes it so compact and lightweight - only 16 kB minified). With Vue.js, you only include functionality you need for your application. One would argue that with current hardware devices this is no longer an issue, but the performance hit lies in the execution of this amount of code at runtime, which makes it slower the bigger the framework code is.

In fact, the guy who started Vue.js (Evan You) was first working at Google Labs with Angular where he saw the need to make an easier to understand, much more compact library allowing you to do the same with a flat learning curve. When you see Vue.js now with it's companion libs like Vuex, I think he did a really great job!