go to post Dmitry Maslennikov · Feb 26, 2023 At least you can use VSCode for this task, routines and classes and even some other types
go to post Dmitry Maslennikov · Feb 23, 2023 Go to Security, Web Applications, select /csp/user, which is default app for the USER namespace, or if you need it for another namespace, find default web application for that namespace. And check Analytics there, and save
go to post Dmitry Maslennikov · Feb 22, 2023 You can use whatever you want, just remember about some caveats, like issue with bitslice/bitmap indexes, which requires numerical ID I would recommend using just a Unique Index for the UUID field and use it, it should cover most of the needs.
go to post Dmitry Maslennikov · Feb 22, 2023 Interesting, I'm sure, that tried it, and it did not work. But working now
go to post Dmitry Maslennikov · Feb 21, 2023 To do it, remember to backup the data before the process. Be careful, you can harm your data this way. Documentation about it. One of the ways, at least. Depends on what you really want to achieve. Before, I would recommend learning more about journals, how the data is actually stored, and how the restore works.
go to post Dmitry Maslennikov · Feb 19, 2023 InterSystems does not want support for environment variables for password, as it’s expected by the world, and everyone doing it as a side effect, there is no way to use services feature in GitHub actions, and I suppose such things may exist in other CI’s. But I found that it could be very useful, and at the moment I have to start IRIS in docker manually and reset password
go to post Dmitry Maslennikov · Feb 17, 2023 Cache is quite old, and obviously, it may be incompatible with IRIS. So, you would need to use separate drivers for Cache and IRIS.
go to post Dmitry Maslennikov · Feb 16, 2023 I've done a similar task, with much bigger databases. And it was quite good. Mirroring working with data itself, not the on the block level. So, there should not be an issue, if you do not change data stored there.
go to post Dmitry Maslennikov · Feb 13, 2023 Not sure if there are any changes from default. But, make sure, that you using SuperServer port, which is by default 1972, not WebServer port.
go to post Dmitry Maslennikov · Feb 11, 2023 irissqlcli has a docker version of the tool (even two versions, including for web), is it acceptable? And demo docker-compose-example.yml, which can be used to test it locally with IRIS
go to post Dmitry Maslennikov · Feb 11, 2023 And thanks to open source and @Guillaume Rongier, it's now possible to connect to IRIS in a secure way with SSL requires testing, but, you can find examples here https://github.com/caretdev/irissqlcli/pull/4
go to post Dmitry Maslennikov · Feb 11, 2023 I can't recommend IRIS SQLTools for VSCode, as it's too far away from xDBC realizations, and works just over REST, and there is no way for a good improvement. This tool can be quite enough for some simple queries, or as some simple demonstration, with a small amount of data.
go to post Dmitry Maslennikov · Feb 11, 2023 Access only by web, looks a bit odd, but possible. In my example of irissqlcli-web, I've just used external tool ttyd, which I'm sure can be easily tied with any webserver in use. ttyd is deamon process, supposed to be launched on the server, it opens some port, which can be used in webserver to as a proxy endpoint. Multiline SQL, yes. It supported in a multiple ways, not sure what exactly do you mean A file a bunch of SQL Queries, can be passed to the tool itself as stdin, and it will execute it, along with the tools commands Just paste a bunch of queries, each query or command ended with semicolon. And it will work too. Transactions, yes, sure, everything possible with xDBC, should work here too In the example below, I've just copied and pasted many lines there and executed them. And done, including changing the output format, rollback transaction As for verifying results before coming, this sounds wonderful. I don't have anything yet, in way of automation. But I don't see that it's not possible to implement. If you have any examples of how it has probably already been implemented somewhere, let me know, so, do not reinvent the wheel. And all the features requests are welcome in the GitHub repo And as for deeper integration SQL and IRIS, I'm sure it is worth looking at dbt project. I'm part of the implementation IRIS support, there.
go to post Dmitry Maslennikov · Feb 10, 2023 And I would recommend using pyenv, which may help to install and use multiple versions of Python, and select needed version
go to post Dmitry Maslennikov · Feb 10, 2023 I have not tested it with 3.11, so, not sure how it will work there. You can install multiple versions of Python with pyenv for instance. Yes, this tool connects remotely to any IRIS instance
go to post Dmitry Maslennikov · Feb 9, 2023 Tip, you can go to pypi, https://pypi.org/project/irissqlcli/, and there you may find the list of supported versions
go to post Dmitry Maslennikov · Feb 9, 2023 %Service_Terminal in Docker images already has OS Auth enabled by default
go to post Dmitry Maslennikov · Feb 8, 2023 Well, if you require some parts of API to be anonymously available, and another part requires authorization. Then the easiest way is to implement two these APIs separately, and configure Web Applications this way, where one of them will have anonymous access, and another would require password. And it will work, and you will not need to do anything else. But if have everything in on API, you can look at my demo project. Based on Realworld application, offereded realizations in many different languages and frameworks.
