All
Accepted answers
Evgeny Shvarov · Apr 3, 2022 go to post

Added macro for all the one liners.

So you also can

include dc.one.Line

and call

$$$changealladminpass("pass") to change all the predefined passwords to "pass", and other useful one-liners you suggested.

The Line.cls file illustrates the usage.

Suggest your useful one-liners!

Evgeny Shvarov · Mar 18, 2022 go to post

We are looking for the implementations of different data models with globals as a persistence engine. Technically everyone can implement their own graph, temporal, columnar, document, or any other type of a persistence engine implementing the API via Embedded Python, ObjectScript, or through Native API libs of node.js, java, python, or dotnet.

Also, we are looking for smart data index implementations, such as spatial index, functional indexes for search, etc.

There will be technical bonuses of such. Stay tuned and join our Monday's kick-off for more details.

Evgeny Shvarov · Feb 23, 2022 go to post

Updated the article with notes regarding the lowercase for classes:

Package names are written in all lower case to avoid conflict with the names of classes or interfaces.

So the full qualified name of the class is company.project.subpackage.TheClass.cls.

The approach borrowed from the naming convention for java classes.

Evgeny Shvarov · Feb 22, 2022 go to post

Thanks for the explanation, @Dan Pasco! 

Could you please explain why the size of indexes is reduced and why the queries are faster? Is it because of a shorter global name and path to the indexes?

For a lot of developers who got used to the meaningful global names this random hash can be an issue when you want to examine the global values for the related class/table or to make direct changes to it programmatically.

Evgeny Shvarov · Feb 21, 2022 go to post

Turned out, that this behavior can be adjusted by removing the Final clause from DDL generation via the following flag:

set sc=$SYSTEM.SQL.Util.SetOption("DDLFinal",0,.oldval)
Evgeny Shvarov · Feb 16, 2022 go to post

It's not only for Eastern and Central Europe, @Ben Spead ! Any startup from any region is very welcome! The majority of activities will be online! Besides the Czech Republic, we already have applications from USA, UK, Netherlands, UAE, Ukraine and invite startups to apply!

Evgeny Shvarov · Feb 14, 2022 go to post

If you need to export the result of SQL to CSV you can use csvgen lib. 

install csvgen:

USER>zpm "install csvgen"

Perform export:

USER>set query="select * from your.classname"

USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)

1
Evgeny Shvarov · Feb 13, 2022 go to post

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

Evgeny Shvarov · Feb 12, 2022 go to post

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