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
.png)
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.
Obviously, I can implement those connectors, just wanted to get some feedback, or other suggestions or what should be implemented first
So, we have time, to be prepared for the next time
Check again, looks like there were an outage of the SSO service, should work now
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
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.
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.
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
.png)
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.
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
We are not done, yet 😉
Have a look at this project https://github.com/daimor/realworld-api-quarkus-iris
I've migrated Realworld application made on Quarkus, to work with IRIS, it even uses CI to test it, and all tests passed
I did not find there anything, that I would recommend anybody at all.
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.
you can use $zstrip, where action *P, * is for any place, and P any punctuation
for example
USER>write $zstrip("before!@#$%^&*()_+\-=\[\]{};':""\\|,.<>\/?after", "*P")
beforeafterAnd 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(".!@", "^[!@#$%^&*()_+\-=\[\]{};':""\\|,.<>\/?]*$")
1Yeah, this module regexp, supports recursive, but it's not out of the box solution, and requires to be installed first, unfortunately
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
Just a week for a preview license?
.png)
I'd scan file with VirusTotal, or alternatives
Developer preview license keys are expired
.png)
I just offer an alternative, how to make it with Python
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
}
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.
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.89031975384615385After 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.994676So, my disk can read around 65MB per sec
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.
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)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.
110 minutes, it seems impossible, or, it's something way too wrong
USER>set ts = $zh f i=1:1:65000000 { set ^YYY(i)="somedata" } write !,"elapsed: ", $zh-ts
elapsed: 11.126631
USER>s sub="", count = 0, ts = $zh for { set sub = $Order(^YYY(sub)) quit:sub="" set count = count + 1 } write !,"elapsed: ", $zh-ts
elapsed: 9.549079Here result in seconds
Yes, for sure, my example is too simple, and too far from any real situation.
And there are multiple issues that may happen with your data, it can be how it is stored, where it is stored, how much data in values. And it's difficult to suggest how to check it
Have a look at my series of articles about globals in the database, just for information, it may help understand something, what may go wrong
In any case, there is a right way to count objects, without counting all of them this way. Is using bitmap index, which you can use even if you have own storage, and do not use objects yet. You still able to build own bitmap index, and count items by this index will be at least 64000 times faster, whereas 64000 is just chunk size for bitmap, and speed will vary depends if you don't have much empty spaces between id's, which needs to be numeric