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
go to post Dmitry Maslennikov · Jul 28, 2023 Python ClassMethod IsValid(w As %String) As %Boolean [ Language = python ] { import re;p=r'\([^()]*\)' while re.search(p,w):w=re.sub(p,'',w) return len(w)==0 }
go to post Dmitry Maslennikov · Jul 27, 2023 It's quite tricky to find this page. And I tried, to go through a help page from Management Portal, to find any details, about which version is supported. Anyway, the error seems useless, while it could mention the supported versions too.
go to post Dmitry Maslennikov · Jul 26, 2023 While my global is quite simple, and it's size is about 1.1 GB, or around 18 bytes per record USER>do ##class(%GlobalEdit).GetGlobalSize("/usr/irissys/mgr/user","YYY",.all,.used) USER>zw all all=1109 USER>w all*1024*1024/65000000 17.89031975384615385 After restarting, with a cold cache, I got 17 seconds USER>s sub="", count = 0, ts = $zh for { set sub = $Order(^YYY(sub)) quit:sub="" set count = count + 1 } write !,"elapsed: ", $zh-ts elapsed: 16.994676 So, my disk can read around 65MB per sec
go to post Dmitry Maslennikov · Jul 26, 2023 If your enterprise still uses mechanical disks, that's still a factor that has to be considered All the blocks required to be read to get through the list can be placed all around the disk/s. And it takes time. On a live system, with many changes, and when a lot of different data is stored, the next block can be far from the previous one. So, on mechanical discs, defragmentation is matter, and may slow the speed. I don't know the character of your data, but if you have a lot of data, stored in the globals, it will require to read much more blocks, to even just count the items. And most probably the easiest way to solve it, is just to use bitmap index.
go to post Dmitry Maslennikov · Jul 26, 2023 If you wish to have a conditional filter, then you can use it this way SELECT * FROM SomeTable WHERE (:FilterName = '' OR Name LIKE :FilterName) AND (:FilterValue1 = '' OR Value1 LIKE :FilterValue1) AND (:FilterValue2 = '' OR Value2 LIKE :FilterValue2)
go to post Dmitry Maslennikov · Jul 26, 2023 As I mentioned above, it's a complicated question, and to be sure what's really happening, and why the speed is so slow, it requires a look deeply into the database file and into hardware.
