go to post Dmitry Maslennikov · Jun 17, 2023 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.
go to post Dmitry Maslennikov · Jun 16, 2023 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.
go to post Dmitry Maslennikov · Jun 15, 2023 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.
go to post Dmitry Maslennikov · Jun 9, 2023 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.
go to post Dmitry Maslennikov · Jun 9, 2023 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?
go to post Dmitry Maslennikov · May 25, 2023 Creating an Index with SQL, not directly in ObjectScript, will build Index by default if you don't say do not do it.
go to post Dmitry Maslennikov · May 21, 2023 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
go to post Dmitry Maslennikov · May 16, 2023 No it's just randomly can output errors, and output just nothing
go to post Dmitry Maslennikov · May 15, 2023 It's the compilation log in VSCode, why should I even try this way?
go to post Dmitry Maslennikov · May 14, 2023 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
go to post Dmitry Maslennikov · May 14, 2023 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.
go to post Dmitry Maslennikov · May 13, 2023 VSCode has a way to help with running tests, but it requires implementing from our side
go to post Dmitry Maslennikov · May 3, 2023 Have not seen such errors, but how defined the mirror members, by hostname or by IP?
go to post Dmitry Maslennikov · May 2, 2023 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.
go to post Dmitry Maslennikov · May 2, 2023 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
go to post Dmitry Maslennikov · Apr 28, 2023 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.
