InterSystems IRIS

a simulation of host variables is actually only Available with Embedded SQL only.you know the famous (and horrible to me) :varnam syntax.I propose to take some workaround to allow similar functionality as in other SQL dialects.For good reasons the...

There were some support for Caché, but it's outdated already. And we need support for IRIS.

Flyway is an opensource db migration tool. Here is the related discussion: https://community.intersystems.com/post/flyway-support-intersystems-iris It'd be great to have IRIS support. There is an attempt dated 3 years ago: https://github.com/flywa...

Not sure if everyone is aware but there is a current issue with running Interface Maps, if any of your namespaces uses a Business Process that has many layers. In our case some of the Business Process that I have built has so many layers that even...

Supabase.com is a backend as a service platform. By default, it provides Postgres as a backend, but there is a wrapper mechanism that allows to add different data vendors. https://supabase.com/blog/postgres-foreign-data-wrappers-with-wasm https://...

A cli command like "iris init" which prompt several questions like "Do you want a REST API ? ", "Do you want Analytics modules ?" etc etc...And once the command is done, a blank project is generated with the skeleton of the code

Today it is common to push data from the database to datalake or to notify other systems about data CRUD using kafka. So I suggest create new SQL commands to register a sql table for publish data in json format to a kafka topic and SQL commands to...

Currently there is no way to import a routine (MAC, INT, INC) from file to a given IRIS Server. At least I haven't found a handy one. Management portal allows to import classes but not routines from disc to IRIS. It'd be great to add a UI package ...

Often we need a unittest for a given objectscript class. And the schema of unittest class is pretty typical: the unittest class relates to a certain objectscript class but with the name Test before the class name methods in unittest start with Tes...

There is a Security package in SYS. It allows do a lot via terminal calls. Can be useful via REST API too (secured of course)