Article Robert Cemper · Apr 26, 2024 2m read Geo Vector Search #1 Geographic use of vector search The basic idea is to use Vectors in the mathematical sense.I used geographic coordinates. These are of course only 2-dimensionalbut much easier to follow as vectors in text analysis with >200 dimensions. #ObjectScript #SQL #Vector Search #Video #InterSystems IRIS Open Exchange app 5 3 1 290
Article Robert Cemper · Apr 9, 2024 2m read Foreign Tables with CSV in action FOREIGN TABLES is a rather fresh feature in IRIS (2023.?)So I was motivated to try something new by own hands.Documentation of Foreign Table from File is a good starting point.Also the related promotional video is fine to start with. #CSV #SQL #InterSystems IRIS Open Exchange app 8 2 0 312
Article Robert Cemper · Apr 3, 2024 2m read Reviews on Open Exchange - #41 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you made a major change and expect a changed review just let me know. #Open Exchange 0 0 0 82
Article Robert Cemper · Mar 21, 2024 2m read Left Side Functions in ObjectScript In ObjectScript you have a wide collection of functions that return some valuetypically: set variable = $somefunction(param1,param2, ...) There is nothing special about that.But there is a set of functions that I classify as LEFT SIDED The specialty of them is that you can use them also on the left of the equal operator as a target in the SET command: set $somefunction(param1,param2, ...) = value #ObjectScript #SQL #Vector Search #InterSystems IRIS 5 3 1 282
Article Robert Cemper · Mar 21, 2024 2m read VECTOR inside IRIS This is an attempt to run a vector search demo completely in IRISThere are no external tools and all you need is a Terminal / Console and the management portal.Special thanks to Alvin Ryanputra as his package iris-vector-search that was the baseof inspiration and the source for test data. #Embedded Python #ObjectScript #Vector Search #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 8 11 2 497
Article Robert Cemper · Mar 12, 2024 2m read Reviews on Open Exchange - #40 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you made a major change and expect a changed review just let me know. #Open Exchange 1 0 0 91
Article Robert Cemper · Mar 5, 2024 2m read Columnar vs. Row Storage with IRIS native The idea of this package is to compare the performance of columnar storage inside IRIS without wrapping it to some foreign platform that is not my world In addition, I do not want to measure network performance between 2 containers, but inside a closed IRIS environment that I have fully under my control Even the use of SMP or some other browser-based presentation has some influence that I want to avoid. #Columnar Storage #ObjectScript #InterSystems IRIS Open Exchange app 3 2 0 183
Article Robert Cemper · Feb 24, 2024 2m read The bewitched line terminator I want to address the nasty problems about reading a flat text in ASCII, UTF*explicitly excluding HTML, EBCDIC, and other encoding.According to Wikipedia there are at least 8 variations of control characters. CR+LF is typical for Windows LF is typical for the Linux/UNIX world CR is Mac's favorite As you can deduct from the names the inspiration comes from mechanical typewriters. #Containerization #Data Import and Export #Docker #Tips & Tricks #Tutorial #Ubuntu #InterSystems IRIS 25 0 1 465
Article Robert Cemper · Feb 18, 2024 2m read Reviews on Open Exchange - #39 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you made a major change and expect a changed review just let me know. #Open Exchange 1 0 0 135
Article Robert Cemper · Dec 23, 2023 1m read Reviews on Open Exchange - #37 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you made a major change and expect a changed review just let me know. #Open Exchange 1 0 0 145
Article Robert Cemper · Nov 26, 2023 2m read Reviews on Open Exchange - #36 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you did a major change and expect a changed review just let me know. #Open Exchange 1 0 0 132
Article Robert Cemper · Nov 19, 2023 1m read NativeAPI for Java from WebTerminal Based on the successful solution for my 2nd contribution to the Contest I used an adapted version for this package. And have some findings I'd like to share. Multiple communication steps over CPIPE may take time.You won't recognize it on a fast machine. But a slower box withWindows + Docker Desktop + your browser (and more) is neither"Speedy Gonzales" nor a "Road Runner". 🙂 #API #Java #ObjectScript #Tools #Video #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 1 1 0 216
Article Robert Cemper · Nov 19, 2023 2m read Java Global Editor from WebTerminal There are situations when your only access to a server is using a web browser,and there is just no chance of a Terminal or Console access.The Online Demo Server is such a case. So you have WebTerminal. That's fine for ObjectScript and Embedded Python. #API #Contest #Globals #Java #Tips & Tricks #Tools #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 2 0 0 169
Article Robert Cemper · Nov 15, 2023 2m read Java Global Editor This is the related article to the package in Java Contest. I decided to present a CRUD++ Global Editor based on IRIS Native API for Java.++ because it’s a little bit more than just Create, Read, Update, DeleteVisualization of a global is always important to review results immediately. #Globals #Java #Tools #Video #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 0 2 0 357
Article Robert Cemper · Nov 10, 2023 2m read Using NativeAPI Command Line Extension from Java In my previous articles, I described my Command Line Extension to NativeAPI.Of course, this is also available for any other NativeAPI package.So I created this example as a demo for the actual Java Contest.The package contains also an IRIS server in Docker for the demoIt is evident that it also works with any remote IRIS server.You just have to provide it with my NativeAPI CommandLine Extension. #API #Java #Video #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 3 2 0 272
Article Robert Cemper · Oct 27, 2023 1m read Reviews on Open Exchange - #35 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you did a major change and expect a changed review just let me know. #Open Exchange 4 1 0 194
Article Robert Cemper · Oct 11, 2023 2m read Reviews on Open Exchange - #34 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you did a major change and expect a changed review just let me know. #Open Exchange 2 0 0 175
Article Robert Cemper · Oct 6, 2023 2m read Reviews on Open Exchange - #33 If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you made a major change and expect a changed review just let me know. #Open Exchange 1 1 0 188
Article Robert Cemper · Oct 1, 2023 2m read Open Exchange Quality Statistics In my recent post Quality of Open Exchange packages, I tried to raise attention onPull Requests and Issues (on GitHub).I could count the replies on 1 hand. Special Thanks to the French Community!I see the role of a Pull Request as a proposal to fix a problem in the submitted package. #Open Exchange 7 4 0 206
Article Robert Cemper · Sep 26, 2023 1m read Create JSON Objects and Arrays by SQL The related package avoids adding %JSONAdaptor to each class but uses instead SQL functions JSON_OBJECT() to create my JSON objects. With this approach, you can add JSON to any class - even deployed ones - without any need for change or recompiling. The trigger was the Export of M:N relationships as JSON objects or arrays. #JSON #ObjectScript #SQL #InterSystems IRIS #InterSystems IRIS for Health Open Exchange app 11 0 0 409