go to post Dmitry Maslennikov · Sep 8, 2023 IRIS SQL does not have CHECK constraints, so, this syntax not available at all. Just try using a simple string, without enumeration.
go to post Dmitry Maslennikov · Sep 7, 2023 Unfortunately, this is not the case, all transactions have to be closed anyway. In example below, I changed only one value and then used rollback, so, it changed it back and committed Missing TCOMMIT, would only mean, that transaction is still open, and it's a bad sign, which will be logged in messages.log, for a long opened transactions.
go to post Dmitry Maslennikov · Sep 4, 2023 Obviously, I can implement those connectors, just wanted to get some feedback, or other suggestions or what should be implemented first
go to post Dmitry Maslennikov · Aug 29, 2023 Check again, looks like there were an outage of the SSO service, should work now
go to post Dmitry Maslennikov · Aug 28, 2023 or use flag USER>write "$lb(" _ $listtostring($lb("demo",,123),,7) _ ")" $lb("demo",,123)
go to post Dmitry Maslennikov · Aug 28, 2023 I think we still need deeper support for IRIS in DBeaver, and it can be implemented. So it will be possible to have more options to be configured, and more possibilities
go to post Dmitry Maslennikov · Aug 26, 2023 That means improper configuration for the webserver. Anything that goes through a CSP application goes this way. Properly configured webserver, should take care of static files without IRIS, just process them itself. In this case, IRIS will not even know about requests to the static files. Remember, that you should not use a private Webserver in the production at all, and have to have something manually configured. And any newest IRIS non-community versions since 2023.2 will not even install a private webserver anymore unless the IRIS is updated from some previous version.
go to post Dmitry Maslennikov · Aug 24, 2023 Right, it's possible to make it similar to other Database connectors, and I suppose even add it to the list of available connectors. So, anyone will be able to use it, with any IRIS instance, but only SQL way, without the need for any development on the IRIS side.
go to post Dmitry Maslennikov · Aug 24, 2023 IRIS containers will only be tagged with the year and release, such as “2023.2” What about images on Docker Hub? No latest-cd, no 2023.2, no multi-arch images? In some cases, when I need speed of downloading images I preferer using this place
go to post Dmitry Maslennikov · Aug 24, 2023 I don't think so, but I don't see why it cannot be developed anyway. I could probably develop it if you need it.
go to post Dmitry Maslennikov · Aug 22, 2023 fixed: https://openexchange.intersystems.com/package/dbt-iris
go to post Dmitry Maslennikov · Aug 21, 2023 Ron, that’s nice that you discovered dbt, I’ve implemented support for IRIS, directly without sqlalchemy quite some time ago, have a look https://github.com/caretdev/dbt-iris and we had a session on last Summit, about using dbt in a MLonFHIR project
go to post Dmitry Maslennikov · Aug 15, 2023 Have a look at this project https://github.com/daimor/realworld-api-quarkus-irisI've migrated Realworld application made on Quarkus, to work with IRIS, it even uses CI to test it, and all tests passed
go to post Dmitry Maslennikov · Aug 12, 2023 I did not find there anything, that I would recommend anybody at all. compose version, uses Durable SYS, not what I would like to recommend plain Dockerfile, too much garbage, not sure how it is working though
go to post Dmitry Maslennikov · Aug 11, 2023 Fortunately, Community Images has not been affected, yet. But who knows for how long. But, looks like we need something user-friendly than official WebGateway images. And I'd like to be able to easily switch between Community and Enterprise in any community project. But It's kind of tricky now, have to keep the version in mind.
go to post Dmitry Maslennikov · Aug 7, 2023 you can use $zstrip, where action *P, * is for any place, and P any punctuation for example USER>write $zstrip("before!@#$%^&*()_+\-=\[\]{};':""\\|,.<>\/?after", "*P") beforeafter And if you just want to check if the string contains any punctuations, you can compare if the original string does not equal the same after $zstrip. if you wish to use regexp, you can use $match USER>write $match(".!@", "^[!@#$%^&*()_+\-=\[\]{};':""\\|,.<>\/?]*$") 1
go to post Dmitry Maslennikov · Aug 3, 2023 Yeah, this module regexp, supports recursive, but it's not out of the box solution, and requires to be installed first, unfortunately
go to post Dmitry Maslennikov · Aug 3, 2023 NodeJS support for IRIS exists, but too limited, the new version is still on the way, and I have no idea when it comes But, as I see this thing is a testing engine, what exactly do you want to see from this connectivity with IRIS? Probably it does not require anything specifically for IRIS, and can be used in a common way