go to post Evgeny Shvarov · Feb 13, 2022 Snippets are great and deserve attention, but one-liners have a very certain use case, when you can execute it from the command line or as a docker image tweak
go to post Evgeny Shvarov · Feb 12, 2022 And images with ZPM package manager 0.3.2 are available accordingly. From clause could look like: FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm And change the image to any of the following: intersystemsdc/iris-community:2022.1.0.114.0-zpm intersystemsdc/irishealth-community:2022.1.0.114.0-zpm intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm intersystemsdc/irishealth-community:2022.1.0.114.0-zpm intersystemsdc/iris-community:2021.2.0.651.0-zpm intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm Also you can benefit from the latest and preview tags. Latest is equal to the latest GA IRIS, and preview is for the latest Preview version. e.g. FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm equals to: FROM intersystemsdc/iris-community:latest FROM intersystemsdc/iris-community And FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm equals to: FROM intersystemsdc/iris-community:preview And to launch IRIS do: docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2022.1.0.114.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm And for terminal do: docker exec -it my-iris iris session IRIS and to start the control panel: http://localhost:9092/csp/sys/UtilHome.csp To stop and destroy container do: docker stop my-iris
go to post Evgeny Shvarov · Feb 11, 2022 Updated to 651, thanks, @Jeff Fried! Also, we have the latest tag for ZPM images, so this will take the latest: FROM intersystemsdc/iris-community:latest Or just like this: FROM intersystemsdc/iris-community
go to post Evgeny Shvarov · Feb 6, 2022 BTW, there is a very good one-liner to install ZPM, cortesy of @Guillaume Rongier: set $namespace="%SYS", name="DefaultSSL" do:'##class(Security.SSLConfigs).Exists(name) ##class(Security.SSLConfigs).Create(name) set url="https://pm.community.intersystems.com/packages/zpm/latest/installer" Do ##class(%Net.URLParser).Parse(url,.comp) set ht = ##class(%Net.HttpRequest).%New(), ht.Server = comp("host"), ht.Port = 443, ht.Https=1, ht.SSLConfiguration=name, st=ht.Get(comp("path")) if 'st { w $System.Status.GetErrorText(st) q } set xml=##class(%File).TempFilename("xml"), tFile = ##class(%Stream.FileBinary).%New(), tFile.Filename = xml do tFile.CopyFromAndSave(ht.HttpResponse.Data) do ht.%Close(), $system.OBJ.Load(xml,"ck") do ##class(%File).Delete(xml)
go to post Evgeny Shvarov · Feb 6, 2022 Now this list could be expanded by Tableau, PowerBI and Adaptive Analytics (AtScale).
go to post Evgeny Shvarov · Feb 3, 2022 Hi @Julius Kavay! I agree with you! Could you please submit your suggestion on our dedicated Community Ideas site? I could do it too, but it's great to know that it's not an employee who needs that but partners, and ... I already submitted a lot :) Sign with your DC credentials.
go to post Evgeny Shvarov · Feb 1, 2022 Maybe we need to include the rule that checks SQL string for reserve words in ObjectScript Quality checker. @Daniel Tamajon , what do you think?
go to post Evgeny Shvarov · Jan 31, 2022 Included it into csvgen module. to export SQL to CSV you can do the following: USER>set query="select * from your.classname" USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)
go to post Evgeny Shvarov · Jan 31, 2022 Hi @Guillaume Rongier ! I tried to use pip3 in the app and failed. I see it is being installed during the image build, but cannot run it later. What I'm doing wrong?
go to post Evgeny Shvarov · Jan 24, 2022 And images with ZPM package manager 0.3.2 are available accordingly: intersystemsdc/iris-community:2021.2.0.651.0-zpm intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-community:2021.2.0.651.0-zpm intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm intersystemsdc/iris-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-ml-community:2021.1.0.215.3-zpm intersystemsdc/irishealth-community:2021.1.0.215.3-zpm And to launch IRIS do: docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm And for terminal do: docker exec -it my-iris iris session IRIS and to start the control panel: http://localhost:9092/csp/sys/UtilHome.csp To stop and destroy container do: docker stop my-iris And the FROM clause in dockerfile can look like: FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm Or to take the latest image: FROM intersystemsdc/iris-community
go to post Evgeny Shvarov · Jan 24, 2022 Hi @Ben Spead! I've introduced the support for DATETIME type in 1.3.1 release for "guesstype" functionality :) So this should work now, and via LOAD DATA if you are on 2021.2+
go to post Evgeny Shvarov · Jan 21, 2022 But I agree - maybe we shouldn't deploy IRIS with a "prebuilt demo namespace" - a new namespace and database should go with the configuration setting. Tagging @Benjamin De Boe and @Andreas Dieckow
go to post Evgeny Shvarov · Jan 21, 2022 Hi @Werner Noske! It looks like you are trying to work on your project in the built-in USER namespace and database. Don't. USER namespace is for testing/demo purposes. You are welcome to start a new clear database from scratch. For example, you can follow this template that starts with a new clear namespace and database IRISAPP.
go to post Evgeny Shvarov · Jan 21, 2022 Thank you, Robert! What you did and keep doing for the community is priceless! We are very lucky to have you! Thank you so much!
go to post Evgeny Shvarov · Jan 12, 2022 Not sure why this doesn't work. Calling for experts @Dmitry Maslennikov @Eduard Lebedyuk