I've just released the new IRIS DEV template that uses your approach, @Guillaume Rongier
It gives for vanilla IRIS Data platform Community Edition 700MB economy: 2.1G instead of 2.7G,
And for vanilla IRIS For Health Community Edition it gives 3.2G(!) economy: 2.8G instead of 6G...
Want to save some space building your dev images with IRIS - use the approach listed here, or directly use our dev template.
Can we have the similar implementation for GitHub OAuth too? Github is the most popular site for developers, so authentication via GItHub will be very handy for developers.
Thank you, @Yuri Marx!
From all the three articles one received the bonus.
Hi @Oliver Wilms !
I answered you in DM.
We added IRIS Cloud SQL survey bonus! Don't forget to collect one!
Hi @Colin Brough !
I don't know if you can use IRIS but if yes docker+IRIS is a perfect combination for desktop operations.
Thanks, Luca!
There is a new release in intersystemsdc community images.
Now password and username can be provided as env variables.
Here it is:
docker run --rm --name iris-sql -d -p 9091:1972 -p 9092:52773 -e IRIS_PASSWORD=demo -e IRIS_USERNAME=demo intersystemsdc/iris-community
and
irissqlcli iris://demo:demo@localhost:9091/USER
There was a new release of intersystemsdc vanilla images.
Now you can use ENV variables to start IRIS with user, pass and namespace created.
E.g. here is how to start:
docker run --rm --name iris-sql -d -p 9091:1972 -p 9092:52773 -e IRIS_PASSWORD=demo -e IRIS_USERNAME=demo intersystemsdc/iris-communityHere is how to connect via irissqlcli:
irissqlcli iris://demo:demo@localhost:9091/USERheh )
Should I consider it as an accepted answer? :)
Nice hat, though! @Robert Cemper, do you have a such in your collection?
Often we need to clean-up IRIS and start from a clear page with empty database. Docker containers could be an ideal option for that.
Start IRIS in docker container locally:
docker run --rm --name iris-sql -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community -a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'"And connect via irissqlcli:
irissqlcli iris://_SYSTEM:SYS@localhost:9091/USERYou can connect also via other SQL tools.
Use the approach only for development purposes.
Finally, one command to run iris in docker:
docker run --rm --name iris-sql -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community -a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'"And another command to open sql terminal:
irissqlcli iris://_SYSTEM:SYS@localhost:9091/USERThanks to @Robert Cemper and @Dmitry Maslennikov
Finally, here is how run iris docker container and use in SQL after that:
docker run --name iris-sql -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-communityand
docker exec -t iris-sql iris session iris -U %SYS '##class(Security.Users).UnExpireUserPasswords("*")'And SQL connections now work!
$ irissqlcli iris://_SYSTEM:SYS@localhost:9091/USER
Server: InterSystems IRIS Version 2022.3.0.606 xDBC Protocol Version 65
Version: 0.5.1
[SQL]_SYSTEM@localhost:USER> select $zversion
+---------------------------------------------------------------------------------------------------------+
| Expression_1 |
+---------------------------------------------------------------------------------------------------------+
| IRIS for UNIX (Ubuntu Server LTS for ARM64 Containers) 2022.3 (Build 606U) Mon Jan 30 2023 09:07:49 EST |
+---------------------------------------------------------------------------------------------------------+
1 row in set
Time: 0.047sThanks to @Robert Cemper and @Dmitry Maslennikov
Thanks @Robert Cemper !
But I want something I can use via CLI (Command line) interface in a non-interactive way.
You need DML?
maybe csv export and import then could help?
wow. Didn't know we have that! And aliases can be setup and transferred too? E.g. like a package (IPM)?
Would be nice to have
Added a small cheat sheet for IRIS SQL
Thank you @Iain MacDonald !
Hi, Developers!
The cloud portal of InterSystems IRIS Cloud SQL is now available!
Feel free to launch deployments and prepare to the contest!
Hi Jude! If you could introduce the content of pdf in the body of the article that'd be much better.
For those who wants PDF we have PDF export option.
But for your readers it is much easier to work with the article to read it directly here and be able to quote the parts in it in comments, and etc. It is even easier for you if you want to edit/update something in it.
Thanks @Guillaume Rongier !
Do you mind to Release on Open Exchange? Please?
You can try %MONLBL to dig into the performance. The related article by @Sergei Sarkisian
Great example, @Alberto Fuentes !
Curious, what makes this method DeliverToSubscriber being called in Operation?
Thanks @Julian.Matthews7786 ! Very important! Do you have any sample app that demonstrates the approach?
Yes. That’s why it is called Embedded Python
If you go with IPM+Git-source-control you can use wildcards as "MyApp.PKG" which will consider included all the classes in MyApp class package.
Yay!
This time you can develop the solution for the contest in ANY language that understands SQL!
Python, java, .NET, js, C++, Rust, Go, ObjectScript - anything!
Looking forward!