Article Robert Cemper · Jan 24, 2022 1m read GlobalToJSON-Academic I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Academic refers to the structure created.Each logical node of the Global is presented separately with all its descendants.Even if they don't contain any stored data. #Globals #JSON #InterSystems IRIS 2 1 0 280
Question Robert Cemper · Jan 12, 2022 SQL LOAD DATA FROM FILE - limits in VALUE clause ? II try to explore the new SQL LOAD DATA feature in SQL comparing it to SQL INSERT I'm stuck at this point: INSERT INTO <table> (columns...) VALUES (.....)allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)example: INSERT INTO Test (ShortName,DOB) VALUES (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY')) This works perfectly. BUT the same VALUE clause applied to LOAD DATA fails in various ways: #SQL #InterSystems IRIS 1 3 0 207
Article Robert Cemper · Jan 2, 2022 3m read DB Migration using SQLgateway Thanks to @Yuri Marx we have seen a very nice example for DB migration from Postgres to IRIS.My personal problem is the use of DBeaver as a migration tool.Especially as one of the strengths of IRIS ( and also Caché) before is the availability of theSQLgateways that allow access to any external Db as long as for them an access usinig JDBC or ODBC is available. So I extended the package to demonstrate this. #Best Practices #Data Import and Export #Docker #SQL #InterSystems IRIS 10 3 2 620
Article Robert Cemper · Dec 27, 2021 2m read My Reviews on Open Exchange - Dec.2021 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 6 0 0 397
Article Robert Cemper · Dec 25, 2021 2m read AOC2021-rcc After >40 years of writing in-countable lines of code in M*/COS/ISOS (and a bunch of archaic languages)I decided for myself to set a strong signal for the future. We have Embedded Python available(still pre-release)! I just felt it as a sacrilege to ignore this excellent NEW opportunity andstay with the old sermon that I had used for decades. #Docker #Embedded Python #InterSystems IRIS 11 0 0 303
Article Robert Cemper · Nov 30, 2021 2m read My Reviews on Open Exchange - Nov. 2021 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 6 7 0 224
Article Robert Cemper · Nov 26, 2021 13m read Traditional Debugging in ObjectScript Finding errors in your code or examining unexpected behavior is the main purpose of DebuggingI will try to refresh the traditional tools away from the helpers you have in Studio, VScode, Serenji, ....to the basics which have been there before your preferred EDI used it in the background. #Other 19 10 3 1.2K
Article Robert Cemper · Oct 31, 2021 2m read My Reviews on Open Exchange - Okt.2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 3 1 0 164
Article Robert Cemper · Oct 12, 2021 2m read Generating OFX [V1] Just in case you never heard about OFX beforeV1 was an attempt to create a dedicated SGML for banking and ignoring XML. Details.It evolved to XML but not for M$ MONEY. Today we would use JSON for similar tasks. #Other 5 4 0 383
Article Robert Cemper · Sep 29, 2021 4m read 6 Months Reviews on Open Exchange I'm running reviews on Open Exchange since April 2021.I have seen excellent packages, good ones, and some that made me feel just lost.And I started to recognize contributors also by their style and organization of the submitted packages. #Open Exchange 8 3 0 412
Article Robert Cemper · Sep 29, 2021 2m read My Reviews on Open Exchange - Sept.2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 2 1 0 192
Article Robert Cemper · Sep 11, 2021 2m read Successful Troubleshooting During the last weeks, I was working on various issues and problems related to SW development.I found that quite often problem analysis was mostly chasing issues just on the surfacebut not really attacking the deeper reasons of the problem and follow the consequences.It's like the doc that stops your leg bleeding but doesn't see that it is broken. #Other 8 2 0 456
Article Robert Cemper · Sep 10, 2021 4m read Storage Considerations on large data sets I'd like to share with you some storage features that also exist in Caché but are almost unknown and mostly not used. They are of course available in IRIS and gain importancewith large and distributed storage architectures. #Other 14 0 0 432
Article Robert Cemper · Aug 31, 2021 2m read My Reviews on Open Exchange - August 2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 5 0 0 210
Article Robert Cemper · Jul 30, 2021 2m read My Reviews on Open Exchange - July 2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 7 2 0 213
Article Robert Cemper · Jul 15, 2021 1m read Docker Desktop Windows - disk space consumption I run most of my reviews using Docker Desktop on Windows 10.According to the recommendations, I clean up docker and downloaded repositories after tests: Repos are simple but Docker is somewhat resistant to release the consumed disk space. #Docker #Other 15 2 3 2.9K
Article Robert Cemper · Jul 15, 2021 4m read The future position of ObjectScript If you develop in IRIS you are confronted with two major phenomena: an incredibly fast and excellent designed data storage engine a scripting language to work on this storage engine, actually named ObjectScript #Embedded Python #Languages #ObjectScript #Python #InterSystems IRIS 31 33 1 1.7K
Article Robert Cemper · Jul 10, 2021 2m read My Reviews on Open Exchange - June 2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 5 0 0 151
Article Robert Cemper · Jul 10, 2021 2m read My Reviews on Open Exchange - Apr+May 2021 If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.It reflects my experience with the status I found at the time of my review. #Open Exchange 4 1 0 307
Article Robert Cemper · Jun 12, 2021 2m read Running reviews on Open Exchange For several weeks I'm creating reviews on OEX. So I'd like to explain to you the criteria that I apply to find my ratings.Of course, each reviewer is an independent person and has his own criteria and his own opinion.And that's good and important! As Winston Churchill once said: "If 2 people always have the same opinion, then 1 of them is superfluous" #Open Exchange 6 6 0 265