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.
go to post Dmitry Maslennikov · Feb 7, 2023 I would recommend using .editorconfig, it's supported by VSCode. And it's very useful in this thing, when would like to have a control on indention settings in the entire project.
go to post Dmitry Maslennikov · Feb 7, 2023 Hi, the way you trying to install is correct. But could you check the version of Python installed there, it requires version from 3.7 to 3.10
go to post Dmitry Maslennikov · Feb 3, 2023 And another thing were boring me, is that during the build with Dockerfile, there is no way to run normal IRIS but very minimal, as fast as possible, but fully functional, and suggested that as an idea. During the build, there are no need in ECP, TaskManager and Ensemble, even many having many Write Daemons, and also PWS (where it's left). Do not waste time, starting useless processes.
go to post Dmitry Maslennikov · Feb 3, 2023 There are many why's, and this is one of them for sure. Another few things I found quite interesting It starts ECPWork too, even when CE does not have any networking available, including ECP It starts up to 7 AUXWD processes, not sure if there is any help from such amount if you have a limit of 10GB of databases there
go to post Dmitry Maslennikov · Feb 3, 2023 Yeah, this may happen if Recurse flag is not checked for REST application. IRIS hides this flag for REST, but it is still in use, so, you would need to switch to CSP/ZEN, mark Recurse, and return back to REST
go to post Dmitry Maslennikov · Feb 1, 2023 iris.cpf file in the root of IRIS installation, contains these lines DefaultPort=1972 WebServerPort=52773
