All
Accepted answers
Dmitry Maslennikov · Jun 17, 2023 go to post

and another way to access terminal through web, is by using ttyd, I use it for irissqlcli-web. ttyd helps to webify any terminal application, it can be bash, or iris session

Dmitry Maslennikov · Jun 17, 2023 go to post

You did not mention, what package you would like to use in Python to make REST. 

  • if it's FastAPI, with this package you can use SQLAlchemy and sqlalchemy-iris 
  • Django, with this framework, then just use django-iris

In any case, I would recommend looking into SQLAlchemy, and its API, which has many features, of course including the way to list tables, as well as list columns in tables, and lots of other features.

If you are going to use some other package for making REST API, and this library does not support SQLAlchemy, let me know, I'll have a look, and may implement IRIS for this library too.

Dmitry Maslennikov · Jun 16, 2023 go to post

Looks like the database was created with a different collation, and contains a few globals with this collation. 

I don't remember, but I think in the messages.log it should show which collation is expected. And then, you can change it in Management Portal, and with NLS. When you activate NLS which contains the expected collation, it will be able to mount this database.

Dmitry Maslennikov · Jun 15, 2023 go to post

This part I can do, but, I don't think we should even consider it. This is part of IRIS SQL Dialect, and it's not good when some SQL queries may not work with different connections, e.g. using JDBC, or SMP.

Dmitry Maslennikov · Jun 9, 2023 go to post

It looks like there is something wrong with an instance. And It would require some more details, such as the exact version, edition, and the way how it was installed. And just check it manually if HSSYS is present in the system, as well as HSLIB with databases, and all databases are accessible too.

Dmitry Maslennikov · Jun 9, 2023 go to post

I think it depends on what type of application you have on IRIS.

If it's just some frontend application, then there is a variety of projects to do this task, as it is not much related to IRIS

What exactly do you want to test?

Dmitry Maslennikov · May 25, 2023 go to post

Creating an Index with SQL, not directly in ObjectScript, will build Index by default if you don't say do not do it.

Dmitry Maslennikov · May 21, 2023 go to post

Well, most probably IRIS there running in a container, and you are looking at the wrong place. Inside the container, from IRIS, there will be /usr/irissys, outside it will be somewhere else

Dmitry Maslennikov · May 14, 2023 go to post

with zpm you can use additional parameter for it

zpm "test module-name -only -D UnitTest.Case=Test.PM.Unit.CLI:TestParser"

Use class name only to run all tests there, or add Method name to test only that method in the class

Dmitry Maslennikov · May 14, 2023 go to post

There are no reasons for them to be ClassMethods, UnitTests is quite a complex thing, and it's there are use-cases where it needs to be this way.

Dmitry Maslennikov · May 2, 2023 go to post

I've added support for IRIS to the migration tool Alembic based on SQLAlchemy 

And with this support, Apache Superset can completely operate on IRIS, not just for analyses, but just for its own Superset's needs too.

Dmitry Maslennikov · May 2, 2023 go to post

well, ok, yeah, I did not notice it. But still, the usage per process is still an important part. And even if the leakage is real, it may happen in ZPM itself. The testing scenario does not look like proof much, installing and uninstalling zpm multiple times does not like a real scenario.

Have a look at what will show this query, the result in KB

echo 'select sum(memorypeak) memorypeak,sum(MemoryUsed) memoryused from %SYS.ProcessQuery' | iris sql iris
Dmitry Maslennikov · Apr 28, 2023 go to post

I think you forgot about memory per process, which I would say is not limited at all by default anymore. So, your "leaks", may happen in the processes. ZPM is quite a big package, and the installation will use multiple processes.

So, having most of the memory just mostly for buffers does not work for IRIS, while you need room for the processes, and if you would go to production, you have to have in mind how many active users you would expect and decide how much memory they will consume.

Dmitry Maslennikov · Apr 27, 2023 go to post

You can also use SAM, or plain Grafana for it, which is more suitable for real-time dashboards

And I've recently introduced IRIS support to Apache Superset, which now can be used to show charts on plain SQL tables.

Dmitry Maslennikov · Apr 24, 2023 go to post

There is no way, to catch the possible issues for the previous version of IRIS.

The best case scenario is if you automate the build process, for instance with Docker, and test a compile stage on different versions of IRIS. But the ability to successfully compile may not prove that it will work, it would be better to have some unit tests, which will check it.

One more thing, may help, to check it, using the such tool as ObjectScript Quality, can help with checking System's API version. Where you can set the oldest supported version of IRIS, and during the scan, it can check if Methods are available in that particular version.

Dmitry Maslennikov · Apr 10, 2023 go to post

Some scenarios may require the ability to insert a new row with IDENTITY not default, and in this case you would need to use ALLOWIDENTITYINSERT = 1

CREATE TABLE (..) WITH %CLASSPARAMETER ALLOWIDENTITYINSERT = 1;

Some additional details here

Dmitry Maslennikov · Apr 10, 2023 go to post

Or just add this to the end of docker run command

-a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'"