InterSystems IRIS is a Complete Data Platform InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data. As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.
I'm participating in the Developing with InterSystems Objects and SQL with Joel Salomon. The course is very nice and I will share with you some tips I got during the training. Tips presented in the day 2:
In the first installment of this article series, we discussed how to read a “big” chunk of data from the raw body of an HTTP POST method and save it to a database as a stream property of a class. Now let’s look at how to save such data and metadata in JSON format.
I'm participating in the Developing with InterSystems Objects and SQL with Joel Salomon. The course is very nice and I will share with you some tips I got during the training. Tips presented in the day 1:
I just published isc-mem-config on OpenExchange and ZPM. It's a prototype to test whether this kind of user experience (UX) is a good fit for novice and / or more seasoned users. The settings it generates are already fairly-good-practice :-), but also being reviewed by experts within InterSystems in parallel.
I thought i would share a little method I knocked together to traverse and compare 2 JSON objects for basic equivilance. I'm currently working on some data migration, and wanted a basic sanity check to validate that the JSON output is basically equivliant between the old and new, excluding a few things like timestamps.
It's a basic little recurvsive method, that will bubble up any differences over a nested structure. It's very low tech, as that's all I need it to do, but I thought it might be useful for others?
A concurrent session in IRIS: SQL, Objects, REST, and GraphQL
Kazimir Malevich, "Athletes" (1932)
"But of course you don't understand! How can a person who has always traveled in a horse-drawn carriage understand the feelings and impressions of the express traveler or the pilot in the air?"
Kazimir Malevich (1916)
We’ve already addressed the topic of why object/type representation is superior to SQL for implementing subject area models. And those conclusions and facts are as true now as they have ever been. So why should we take a step back and discuss technologies that drag abstractions back to the global level, where they had been in the pre-object and pre-type era? Why should we encourage the use of spaghetti code, which results in bugs that are hard to track down, and which relies only on virtuoso developer skills?
There are several arguments in favor of transmitting data via SQL/REST/GraphQL-based APIs as opposed to representing them as types/objects:
I often miss the ZPM program on a clean system.
Nothing complicated? Take and install.
And in one line? Especially in a docker container.
There is a solution. I'm very happy with it;)
Maybe the line can be shortened?
I have vendors asking for verification that messages for locations are coming through to them. I can get generic ADT_A01 type of numbers in Activity. I'd really like to get some good SQL queries that can give me a count of MSH.4s (for example) for a day for X Operation. I'm not sure which table to look at for that information.
I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.
We have tried with PostgreSQL as well as with TSQL. Same result for each.