Open Exchange App The Double Indirection or Yet Another Way to Process Data Arrays in InterSystems IRIS

Code snippet, Docker, ObjectScript, Caché, InterSystems IRIS

Hi guys!

Portrait of Madame X, Gustave Caillebotte.

One of the features I like in InterSystems ObjectScript is how you can process array transformations in a specific method or a function.

Usually when we say "process an array" we assume a very straightforward algorithm which loops through an array and does something with its entries upon a certain rule.

The trick is how you transfer an array to work with into a function.

One of the nice approaches on how to pass the information about an array is using $Name and Indirection operator.

Below you can find a very simple example which illustrates the thing.

Post by Evgeny Shvarov 4 days ago

Last comment 38 min 56 sec ago

+ 2 1 2

comments

views

+ 2

rating

Open Exchange App Brief introduction to Test Driven Development with Caché and CosFaker

Testing, Caché

Estimated reading time: 6 minutes

Hello everyone,

I was first introduced to TDD almost 9 year ago, and I immediately fell in love with it.
Nowadays it's become very popular but, unfortunately, I see that many companies don't use it. Moreover, many developers don't even know what it is exactly or how to use it, mainly beginners.

Overview

My goal with this article is to show how to use TDD with %UnitTest. I will show my workflow and explain how to use cosFaker, one of my first projects, which I created using Caché and recently uploaded to OpenExchange.

So buckle up and let's go.

�

Post by Henry Hamon Pereira 6 days ago

Last comment 4 hours 34 min ago

+ 17 5 1

comments

167

views

+ 17

rating

Belated - Advent of Code 2018 Day 2

Contest, ObjectScript, Caché

Continuing on from my last post, I am posting my succesful output for the Day 2 Part 1 below.

A full explanation of Day 2 part 1 can be found at: https://adventofcode.com/2018/day/2 and the input can be found

at: https://adventofcode.com/2018/day/2/input

A brief description of this exercise is that you receive a sequence of strings.

You have to count the if any duplicate or triplicate chars exist in the string. Multiples will exist, but if you find multiple ldupicates / triplicates you will count them once.

At the end of sequence of strings you have to SUM the no. of duplicate / triplicate chars and multiply them together to get a simple check sum value.

I created 2 methods, one to import the data and the second to analyse the strings and populate the duplicate count and triple count properties

Post by Stuart Byrne 3 April 2019

Last comment 2 days ago

0 0 2

comments

views

rating

Open Exchange App Python Gateway Part I: Introduction

Languages, Machine Learning, Python, InterSystems IRIS

This series of articles would cover Python Gateway for InterSystems Data Platforms. Leverage modern AI/ML tools and execute Python code and more from InterSystems IRIS. This project brings you the power of Python right into your InterSystems IRIS environment:

Execute arbitrary Python code
Seamlessly transfer data from InterSystems IRIS into Python
Build intelligent Interoperability business processes with Python Interoperability Adapter
Save, examine, modify and restore Python context from InterSystems IRIS

Index

The plan for the series so far (subject to change)

Post by Eduard Lebedyuk 5 days ago

Last comment 2 days ago

+ 2 2 2

comments

views

+ 2

rating

Sharding evaluation #1

InterSystems IRIS, InterSystems IRIS Experience, Sharding

IRIS brought us a new WOW feature - SHARDING !
Definitely a great thing!
But how can I find out if it suits my actual applications?
Is there a practical advantage to go for it with my well cooked transactional application?
Or is it just for new still to be designed applications?

Post by Robert Cemper 22 September 2018

Last comment 3 days ago

+ 10 2 3

comments

321

views

+ 10

rating

Using Docker with your InterSystems IRIS development repository

Containerization, Development Environment, Docker, InterSystems IRIS

Hi Community!

I think everyone keeps the source code of the project in the repository nowadays: Github, GitLab, bitbucket, etc. Same for InterSystems IRIS projects check any on Open Exchange.

What do we do every time when start or continue working with a certain repository with InterSystems Data Platform?

We need a local InterSystems IRIS machine, have the environment for the project set up and the source code imported.

So every developer performs the following:

Check out the code from repo
Install/Run local IRIS installation
Create a new namespace/database for a project
Import the code into this new namespace
Setup all the rest environment
Start/continue coding the project

If you dockerize your repository this steps line could be shortened to this 3 steps:

Check out the code from repo
Run docker-compose build
Start/continue coding the project

Profit - no any hands-on for 3-4-5 steps which could take minutes and bring head ache sometime.

You can dockerize (almost) any your InterSystems repo with a few following steps. Let’s go!

Post by Evgeny Shvarov 14 March 2019

Last comment 4 days ago

+ 3 5 4

comments

192

views

+ 3

rating

Determine programmatically if unit tests failed

Beginner, Best Practices, Code snippet, Testing, Caché

I needed to know programmatically if last ran failed or not.

After some exploring, here's the code:

ClassMethod isLastTestOk() As %Boolean
{
  set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result)
  for i=1:1:in.TestSuites.Count() {
    #dim suite As %UnitTest.Result.TestSuite
    set suite = in.TestSuites.GetAt(i)
    return:suite.Status=0 $$$NO
  }
  quit $$$YES
}

Post by Eduard Lebedyuk 20 February 2018

Last comment 5 days ago

+ 1 1 4

comments

232

views

+ 1

rating

Build HealthShare Docker Images for Demo Purposes on a Windows Laptop

Docker, HealthShare

1. Purpose

This is a 10-minute simple step-by-step guide on how to quickly set up various flavors of HealthShare docker containers from scratch on a Win10 laptop.

For example, we can build a couple of HealthShare "global edition vs UK Edition" demos as shown below.

There are a couple of frequently asked questions from HealthShare colleagues and partners:

"I am no Docker guy, but is there a quick way to build various flavors of HealthShare containers simply for demo/PoC/dev/training or troubleshooting purpose?"
"I just can't make "Docker for Windows" work on my Win10 laptop - how did you make that work? What's the simplest/easiest way to play with HealthShare containers on my old Windows laptop?"

The truth is I am not Docker specialist either - I wish I had time for it. I am using an old laptop, and I haven't even tried "Docker for Windows" yet.�

Post by Zhong Li 6 days ago

Last comment 6 days ago

+ 1 0 2

comments

views

+ 1

rating

Closures in ObjectScript

ObjectScript, Caché

After many sleepless nights it's a pleasure to announce the newer, better, moderner ObjectScript compiler which implemented pretty much everything you ever wanted to have in modern ObjectScript:

Design objective of this new compiler is to parse reasonable subset of current ObjectScript syntax which will look readable for stranger, and not scare them with 1 letter syntax. The good start for compiler was the old-good COS Guidelines from here https://github.com/intersystems-ru/cos-guidelines
For reasons we mentioned above we do not parse 1 letter syntax. It's declared evil;
We do not handle dotted syntax for the same reason - modern syntax with {} is proper replacement for dotted syntax blocks;

But we not only parse the modern ObjectScript syntax, we have implemented finally the long-standing request which we always dreamed about. Closures!

Post by Timur Safin 1 April 2019

Last comment 6 days ago

+ 8 3 4

comments

240

views

+ 8

rating

Replacing ZEN - Part 3 - Progress to date 01

Caché, Angular2, JSON, Web Development, ZEN, ZEN Mojo

Index to Articles

Hi All

It's been 6 weeks since my original article
- - - - -but I have been busy on this project

I have been looking at/thinking about a replacement for ZEN for around 12 months but only really started in depth 4 months ago.
Also been in IT for long enough that I can "get a feel" for a product/technology and make decisions accordingly without going into great detail.
Any new technology has a learning curve and I don't want to waste time and effort on something that won't fly.
And, as always, I am looking to minimise the learning curve as I want to concentrate on delivering business benefit.

Post by Peter Cooper 11 May 2018

Last comment 7 days ago

+ 15 0 4

comments

430

views

+ 15

rating

UI for Ensemble Workflow in Angular

Ensemble, Angular, REST API, Web Development, REST Services

This article is translation of one from Habrahabr InterSystems blog (Russian).
The original post can be found here: https://habrahabr.ru/company/intersystems/blog/251611/

Everyone familiar with InterSystems Ensemble, an integration and application development platform, knows what the Ensemble Workflow subsystem is and how useful it can be for automating human interaction. For those who don’t know Ensemble (and/or Workflow), I will briefly describe its capabilities (others may skip this part and learn how they can use the Workflow interface in Angular.js)

Post by Sergey Sarkisyan 30 December 2016

Last comment 8 days ago

+ 5 0 2

comments

1566

views

+ 5

rating

Open Exchange App IRIS/Ensemble as an ETL

Business Operation, Databases, Interoperability, JDBC, Performance, Ensemble, InterSystems IRIS, InterSystems IRIS for Health

IRIS and Ensemble are designed to act as an ESB/EAI. This mean they are build to process lots of small messages.

But some times, in real life we have to use them as ETL. The down side is not that they can't do so, but it can take a long time to process millions of row at once.

To improve performance, I have created a new SQLOutboundAdaptor who only works with JDBC.

BatchSqlOutboundAdapter

Extend EnsLib.SQL.OutboundAdapter to add batch batch and fetch support on JDBC connection.

Benchmark

Benchmarks released on Postgres 11.2 with 1 000 000 rows fetched and 100 000 rows inserted on 2 columns.

alt text

Prerequisites

Can be used on IRIS or Ensemble 2017.2+.

Installing

Clone this repositor

Post by Guillaume Rongier 9 days ago

0 0 1

comments

views

rating

Open Exchange App Should we use computers?

Machine Learning, InterSystems IRIS

The titular question was quite relevant and often discussed some thirty years ago. The thought went: “Sure, there are industries where computers are the norm, but in my industry we got just fine so far, the benefits are questionable, problems innumerable and unsolved. Can we continue as before or should we embrace this new technology?”

Today, everyone asks the same question but about Machine Learning and Artificial Intelligence. The doubts are the same – lack of expertise, lack of known path, perceived irrelevancy to the industry.

Yet, as before, the correct, even the only possible answer is a resounding yes. Read on to find out why.

Post by Eduard Lebedyuk 9 days ago

Last comment 9 days ago

+ 1 0 1

comments

views

+ 1

rating

Open Exchange App Synchronize Data with DSTIME

Databases, Distributed Data Management, Interoperability, InterSystems IRIS Experience, Caché, Ensemble, InterSystems IRIS, Open Exchange

For Data Synchronization inside Caché you have a range of ways to synchronize objects and tables.
At DB level you can use Shadowing or Mirroring

This works excellent and if you need just a part of your data to be synchronized you may split your
data into smaller pieces using Global mapping
Or if you need bi-directional synchronization on Class/Table level you can use the Object Synchronization Feature

The limit of all these excellent features:
They just work from Caché/IRIS to Caché/IRIS.

Post by Robert Cemper 26 March 2019

Last comment 9 days ago

+ 7 1 2

comments

views

+ 7

rating

Replacing ZEN - Part 2 - Strategic Issues

Caché, Angular2, JSON, Web Development, CSP, ZEN, ZEN Mojo

Index to Articles

Published 2018-05-11 Last edit -

Hi All

I this article I detail some strategic issues that a new development UI will need to address - these are the ones that I can think of now - others may come to light during this journey.

See the webinar by Eduard Lebedyuk here from the last Global Summit describing modern web development and Caché

And, as always, if I have missed something please comment....

Post by Peter Cooper 10 May 2018

Last comment 10 days ago

+ 13 2 6

comments

636

views

+ 13

rating

Format of public key when using RSAEncrypt method of %SYSTEM.Encryption or $System.Encryption.RSAEncrypt()

Encryption, Caché

Howdy, Developer Community!

Here’s a fun little formatting problem you may run into when trying to use the RSAEncrypt method of %SYSTEM.Encryption (also useable as $System.Encryption.RSAEncrypt()!), which is documented here:

https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?...

�

Post by Jonathan Sue-Ho 17 January 2019

Last comment 10 days ago

+ 5 0 2

comments

109

views

+ 5

rating

Docker for Windows and the InterSystems IRIS Data Platform

Beginner, Containerization, InterSystems IRIS

Now that the InterSystems IRIS Data Platform Community Edition is available on Docker Hub (https://hub.docker.com/_/intersystems-iris-data-platform), it seems like a great time to try InterSystems IRIS in a container.

Post by David.E Nelson 12 days ago

Last comment 10 days ago

+ 3 0 2

comments

views

+ 3

rating

Replacing ZEN - Index to articles

Caché, Angular2, JSON, Web Development, CSP, ZEN, ZEN Mojo

Hi All
This is the index to a series of articles I hope to create over the coming months.

ZEN and ZEN Mojo are no longer being actively developed by Intesystems - this is a great shame as it is a fine product that works so well for business applications.
However ZEN is a 15 year old product and I need a path forward to replace the ZEN UI with a supported development framework.

This article is an index of the other articles I have, or plan to write. - the articles will be subject to change as I develop my thoughts and climb the learning curve.

Post by Peter Cooper 18 March 2018

Last comment 12 days ago

+ 12 0 8

comments

673

views

+ 12

rating

Search InterSystems documentation using iKnow and iFind technologies

Caché, Tools, Documentation, Mapping, iFind, iKnow

The InterSystems DBMS has a built-in technology for working with non-structured data called iKnow and a full-text search technology called iFind. We decided to take a dive into both and make something useful. As the result, we have DocSearch — a web application for searching in InterSystems documentation using iKnow and iFind.

Post by Konstantin Eremin 18 September 2017

Last comment 1 April 2019

+ 8 0 8

comments

720

views

+ 8

rating

How to write the home address right?

Beginner, Data Model, Languages, Mapping, Object Data Model, ObjectScript, XML, Caché, InterSystems IRIS

How Tax Service, OpenStreetMap, and InterSystems IRIS
could help developers get clean addresses

Pieter Brueghel the Younger, Paying the Tax (The Tax Collector), 1640

In my previous article, we just skimmed the surface of objects. Let's continue our reconnaissance. Today's topic is a tough one. It's not quite BIG DATA, but it's still the data not easy to work with: we're talking about fairly large amounts of data. It won't all fit into RAM at once, and some of it won't even fit on the drive (not due to lack of space, but because there's a lot of junk). The name of our subject is FIAS DB: the Federal Information Address System database - the databases of addresses in Russia. The archive is 5.5 GB. And it's a compressed XML file. After extraction, it will be a full 53 GB (set aside 110 GB for extraction). And when you start to parse and convert it, that 110 GB won't be enough. There won't be enough RAM either.

Post by Dmitrii Kuznetsov 31 March 2019

+ 2 2 1

comments

100

views

+ 2

rating

Bash script to create csv files for every global contained in a %GOGEN exported file from Cache

Code snippet, Caché

Hello

I made for fun a bash script that creates csv files from a %GOGEN exported file.
%GOGEN, the utility for exporting globals for Cache 5.xx

First I thought it would be very simply with bash, but ...
- if I want a header in the csv file
- if you export with GOGEN more globals together not only one
- if I want a csv file for every global/indexes has the global ..

The simply bash script goes up 100 lines of code. If I will start again with this, I would use Python or Go, not bash.

Example:

For a EXPORTED.GLO fil

Post by Julio Francisco 31 March 2019

0 0 1

comments

views

rating

Announcing Support for Docker Container Technology as a Platform in 2016.1 Release

Caché, Docker, Development Environment, Release

InterSystems is delighted to announce the support of Docker container technology as a platform from the moment 2016.1 will be released.

Docker is a disruptive system technology that has many benefits and offers many advantages for those investing in infrastructure-as-code or immutable-infrastructure provisioning & deployment scenarios.
Like any new technology that appears, there is a learning curve, and many considerations need to occur when using it. However, Docker container technology has already proven to be successful by a huge follow-up with many companies already using it in production. Furthermore & FYI, all public cloud providers already support it.

InterSystems validates and supports its technologies on Docker container engine from v1.8 and above with CentOS, Ubuntu, RedHat and SUSE based containers from the official Docker Hub repository or their respective projects and sites.

Have fun with it

Post by Luca Ravazzolo 27 January 2016

Last comment 29 March 2019

+ 5 0 9

comments

1808

views

+ 5

rating

ObjectScript error handling snippets

Code snippet, ObjectScript, Caché

ObjectScript has at least three ways of handling errors (status codes, exceptions, SQLCODE, etc.). Most of the system code uses statuses but exceptions are easier to handle for a number of reasons. Working with legacy code you spend some time translating between the different techniques. I use these snippets a lot for reference. Hopefully they're useful to others as well.

�

Post by Pravin Barton 28 March 2019

Last comment 29 March 2019

+ 11 7 3

comments

133

views

+ 11

rating

Internal Structure of Caché Database Blocks, Part 1

Caché, Databases, System Administration

InterSystems Caché globals provide very convenient features for developers. But why are globals so fast and efficient?

Theory

Basically, the Caché database is a catalog having the same name as the database and containing the CACHE.DAT file. On Unix systems, the database can also be an ordinary disk partition

Post by Dmitry Maslennikov 3 October 2016

Last comment 27 March 2019

+ 8 3 9

comments

2364

views

+ 8

rating

A Tutorial On WebSockets

JavaScript, Node.js, ObjectScript, Tutorial, Web Development, Caché, InterSystems IRIS, Open Exchange

Intro

Most server-client communication on the web is based on a request and response structure. The client sends a request to the server and the server responds to this request. The WebSocket protocol provides a two-way channel of communication between a server and client, allowing servers to send messages to clients without first receiving a request. For more information on the WebSocket protocol and its implementation in InterSystems IRIS, see the links below.

This tutorial is an update of "Asynchronous Websockets -- a quick tutorial" for Caché 2016.2+ and InterSystems IRIS 2018.1+

Post by Lily Taub 19 March 2019

Last comment 22 March 2019

+ 4 2 3

comments

254

views

+ 4

rating

Adopted Bitmaps example now on Open Exchange

Globals, Indexing, Performance, SQL, Caché, Ensemble, InterSystems IRIS, Open Exchange

In my earlier article on Adopting Bitmaps I described the technique already.
Now you can find a code example also on Open Exchange.

Post by Robert Cemper 22 March 2019

+ 7 1 0

comments

views

+ 7

rating

Light weight EXCEL download

Caché

I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.

There is an great article Tips & Tricks - SQL to Excel

there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"

Nice!
But the result is on your server and you are left alone to get it out to your remote user somewhere.
Could be a subject to be solved using REST or WebServices

Post by Robert Cemper 22 August 2017

Last comment 20 March 2019

+ 13 0 10

comments

642

views

+ 13

rating

Behind the scene of isc-tar project and story about Continuous Integration using Github Actions

Containerization, Continuous Integration, Development Environment, DevOps, Docker, InterSystems IRIS

This is a continuation of my story about the development of my project isc -tar started in the first part.

Just having tests is not enough, it does not mean that you will run tests after all changes. Running tests should be automated, and when you cover all your functionality with tests, everything should work well after any change in any place. And Continuous Integration (CI) helps to keep the code and deployment procedure with as fewer bugs as possible and automates the routine procedures, like publishing releases.

I use GitHub to store the source code. And some time ago GitHub started to work on their own CI/CD platform and named it GitHub Actions. It is not widely available, yet. You have to be signed as a beta tester for this feature, as I did. GitHub Actions uses quite a different way how to deal with a build workflow. What is important that Github Actions allows to use docker, and it’s quite easy to customize available actions. And interesting that GitHub Actions is really much bigger than any classic CI like we have in Travis, Circle or Gitlab CI and so on. You can find more in the official documentation.

Post by Dmitry Maslennikov 20 March 2019

+ 2 1 1

comments

110

views

+ 2

rating

Caché eXTreme for .NET - direct access to globals from C#

Caché, .NET

InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET.

Post by Irene Mikhaylova 30 October 2018

Last comment 19 March 2019

+ 4 2 5

comments

447

views

+ 4

rating

Caché Application Consistent Backups with Azure Backup

Best Practices, Cloud, Ensemble, HealthShare, Backup, TrakCare, Caché

Database systems have very specific backup requirements that in enterprise deployments require forethought and planning. For database systems, the operational goal of a backup solution is to create a copy of the data in a state that is equivalent to when application is shut down gracefully. Application consistent backups meet these requirements and Caché provides a set of APIs that facilitate the integration with external solutions to achieve this level of backup consistency.

Post by Mark Bolinsky 21 March 2017

Last comment 18 March 2019

+ 1 1 4

comments

1260

views

+ 1

rating

Overview

Index

1. Purpose

BatchSqlOutboundAdapter

Benchmark

Prerequisites

Installing

And, as always, if I have missed something please comment....

How Tax Service, OpenStreetMap, and InterSystems IRIScould help developers get clean addresses

Theory

Intro

How Tax Service, OpenStreetMap, and InterSystems IRIS
could help developers get clean addresses