Discussion Evgeny Shvarov · Apr 4 InterSystems SQL Cheat Sheet Hi developers! As you know InterSystems IRIS besides globals, object, document and XML data-models also support relational where SQL is expected as a language to deal with the data. And as in other relational DBMS InterSystems IRIS has its own dialect. I start this post to support an SQL cheatsheet and invite you to share your favorites - I'll update the content upon incoming comments. Here we go! #SQL #Tips & Tricks #InterSystems IRIS 8 25 4 718
Discussion Evgeny Shvarov · Feb 9 Data Transformation as an Element of Interoperability Production Hi folks! I'm playing with IRIS interoperability at the moment and it turned out that Data Transformation cannot be the element of production by itself. It can be called either from data rule or from business process. But why? What if I just want to change the message with the transformation and transfer the message somewhere else? Why the overhead with Rule or Business process? #DTL #Interoperability #InterSystems IRIS 1 1 0 82
Discussion Evgeny Shvarov · Sep 25, 2022 Developing IRIS applications with Docker and VSCode Hi folks! We have a bunch of templates on OEX that provide a handy foundation for building a particular application with IRIS. And the basic principle of each and every template is that we take vanilla IRIS images, load code, and files into the image using Dockerfile, and create a new docker image as a solution. And then we develop running this image and rebuilding it when returning to development. Some developers ask me why we need to build the docker image to work with the code. Indeed, if at the end of the day I need to develop a ZPM package and not a docker image why don't run the vanilla image and load the code and everything in it? The problem I have with the building image approach is that often I can wait a lot to build an image and it fails on some Objectscript problem in the source that I cannot fix as the image is not building. and Any thoughts? How do you develop with docker? #Development Environment #Docker #ObjectScript #InterSystems IRIS #VSCode 1 4 1 223
Discussion Evgeny Shvarov · Dec 28, 2021 On Datasets Licensing Hi developers! We launched the datasets contest. And one of the important questions that need to be covered is dataset licensing. There are two general cases: a) a dataset you take from another place in public Internet or private network/person. b) a dataset you create by yourself or own for any other reason. We decided to follow the principles and considerations that data.world site introduces for datasets' licensing. #Contest #Databases #Other 0 2 0 160
Discussion Evgeny Shvarov · Nov 29, 2021 Naming Convention on ObjectScript Packages, Classes and Package Manager Modules names Hi, Community! Open Exchange (OEX) is getting more and more popular and more and more developers consider publishing their apps in the public package manager registry. This is really great! So the topic of thoughtful naming convention is getting more important and even critical. Let's discuss? #ObjectScript #InterSystems Package Manager (IPM) #InterSystems IRIS 1 6 0 279
Discussion Evgeny Shvarov · Aug 10, 2021 Is there any CRM available built with InterSystems IRIS? Hi developers! Do you know a CRM that is built with InterSystems IRIS or Caché or Ensemble on a backend? #InterSystems Business Solutions and Architectures #Caché #InterSystems IRIS #Other 0 7 0 211
Discussion Evgeny Shvarov · Jul 20, 2021 What is the Best Tool to Edit Data in InterSystems IRIS? Hi folks! How do you edit data in IRIS or Caché? What do you use? Change globals directly via Management Portal? Change data using SQL? Use your favorite dev tool? Which one? Crafted your own? Share your experience, please? #Databases #Tools #InterSystems IRIS 2 12 0 335
Discussion Evgeny Shvarov · Mar 4, 2021 Deploying Packages Without Source Code - commercial mode. Do we need it? Hi Developers! Thank you for using ZPM Package Manager and contributing more and more useful packages to the public registry! But as you already aware ZPM packages are always deployed with source code. Do you think we need to add the option to deploy without source code - e.g. if you want to deploy a commercial package? Will you develop commercial modules if there will be an option and deploy it with ZPM? How do you deploy commercial applications today? #Deployment #InterSystems Business Solutions and Architectures #InterSystems Package Manager (IPM) #InterSystems IRIS 4 10 0 223
Discussion Evgeny Shvarov · Nov 24, 2020 Managing Security Strategy in InterSystems: Users or Applications? Hi Developers! Want to raise security discussion today! Let's discuss how InterSystems security for applications works. In general, the concept is clear: we have Resources (what to protect), Roles which combine a set of privileges and accesses to Resources and Users which can have this or that Role. But there is also a concept of Application which also could have a Role. So you either provide a Role for a User or for an Application. What do you use in production? What is your strategy and why? Pros, cons? #Security #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 0 4 0 188
Discussion Evgeny Shvarov · Oct 2, 2020 VSCode Settings JSON File Hi VSCode users! Just want to check with you, is this settings.json file ideal enough if I: 1. Want VSCode to connect to IRIS in docker? 2. Want to use VSCode SQL Tool? The connection settings file: #Development Environment #Docker #SQL #VSCode #InterSystems IRIS 1 0 1 369