All
Accepted answers
Evgeny Shvarov · Apr 10, 2023 go to post

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/USER

You can connect also via other SQL tools.

Use the approach only for development purposes.

Evgeny Shvarov · Apr 10, 2023 go to post

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/USER

Thanks to @Robert Cemper  and @Dmitry Maslennikov 
 

Evgeny Shvarov · Apr 10, 2023 go to post

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-community

and

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.047s

Thanks to @Robert Cemper and @Dmitry Maslennikov  
 

Evgeny Shvarov · Apr 9, 2023 go to post

wow. Didn't know we have that! And aliases can be setup and transferred too? E.g. like a package (IPM)?

Evgeny Shvarov · Mar 30, 2023 go to post

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.

Evgeny Shvarov · Mar 24, 2023 go to post

Thanks @Julian.Matthews7786 ! Very important! Do you have any sample app that demonstrates the approach?

Evgeny Shvarov · Mar 24, 2023 go to post

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.

Evgeny Shvarov · Mar 24, 2023 go to post

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!

Evgeny Shvarov · Mar 20, 2023 go to post

Hi @water huang . I notice you use a dot syntax to work with stack levels. ObjectScript has {} for this purpose which seems much more effective.

Evgeny Shvarov · Mar 18, 2023 go to post

Great instruction, Anastasia!

Maybe we could add a new(sic!) button into editor that will expect Youtube URL and will transform it into the embedded form and insert the fragment into the post?

Sounds easier than several operations?

Evgeny Shvarov · Mar 14, 2023 go to post

Hi @Jordan Everett !

You can debug in terminal using ZBreak And Break commands.

E.g. insert in the ObjectScript code a new line where you need to step-by-step debugging:

Break "L"

which means turn on interactive terminal debugging with line-by-line mode

and use "go" command to run the line of code.

Evgeny Shvarov · Mar 10, 2023 go to post

Also IPM enabled images are available.

you can use

FROM=intersystemsdc/iris-community:preview

to get the latest 2023.1 preview build with IPM onboard.