All
Accepted answers
Robert Cemper · Jan 3, 2024 go to post

there is a basic misunderstanding:

inside the <CSP:WHILE...> block you are in HTML context
but you issue instead JavaScript >>>> which just prints it out.
To illustrate this see this simple example:
But changing to JS_context solved my simple demo withalert();
 

<csp:WHILECONDITION="resultSet.Next()"><!-- xValues.push(#(resultSet.Get("StatsDate"))#)
  yValues.push(#(resultSet.Get("Value"))#) --><p>#(resultSet.Get("StatsDate"))#<br>#(resultSet.Get("Value"))#</p><scriptLANGUAGE="JavaScript">
 alert(#(resultSet.Get("StatsDate"))#+'>>>'+#(resultSet.Get("Value"))#);
 </script></csp:WHILE>
Robert Cemper · Dec 29, 2023 go to post

Great Stuff!
This matches seamlessly to the  "real" Customer benchmark I did in 2009 (with Caché)
against PostgreSQL and MySQL
Years went by but the principles haven't changed.

  • keep memory consumption low
  • data transfer between memory and "disk" (or what mimics a disk) is the
    the slowest component of your system (except human user) so keep it as flat as possible

Glad to see that this is still as valid as it was since ever.
After so many years, all new technology tricks didn't change that.

Robert Cemper · Dec 26, 2023 go to post

It is still in IPM. OEX seems to have lost it.  ???
 

zpm:USER>search global-dump-sql
registry https://pm.community.intersystems.com:
global-dump-sql 1.0.2
zpm:USER>install global-dump-sql
 
[USER|global-dump-sql]  Reload START (C:\InterSystems\IRIS\mgr\.modules\USER\global-dump-sql\1.0.2\)
[USER|global-dump-sql]  Reload SUCCESS
[global-dump-sql]       Module object refreshed.
[USER|global-dump-sql]  Validate START
[USER|global-dump-sql]  Validate SUCCESS
[USER|global-dump-sql]  Compile START
[USER|global-dump-sql]  Compile SUCCESS
[USER|global-dump-sql]  Activate START
[USER|global-dump-sql]  Configure START
[USER|global-dump-sql]  Configure SUCCESS
[USER|global-dump-sql]  Activate SUCCESS
 
Just providing the global name results in a full global dump.
Example:
USER>zn"user"
IRISAPP>d$system.SQL.Shell()
SQL Command Line Shell
... select TOP 5 * from zrcc_G.dump where zrcc_G.Dump('^%SYS','"JOURNAL"')=1
Robert Cemper · Dec 25, 2023 go to post

Thank you Maksym !
You reached 100% ObjectScript.
I was really impressed by your Part2 on day 23 + 24

Robert Cemper · Dec 25, 2023 go to post

Hi all,
All challenges of AOC 2023 are published.
You are invited to publish your solutions before Dec.28th:
I'll clone your repos on early Dec 28th. no late coming.

  • To be clear only ObjectScript is accepted, no embedded Python or other
  • Testing is done with IRIS for Windows (x86-64) 2023.2 (Build 227U)
  • Docker containers are not part of this check.
  • No problem If you don't have all solutions you just rank later 
  • My personal special thanks go to the 4 participants, that helped me to set up the test methods.

Actual ranking by verified completion in ObjectScript
 

  • DCrank  AOCrank Scores  Stars   ok%     ----- Code Parts OK -----       Name
0       ---     ----    ----    ---     ----*----*----*----*----*       --- DC Members ---
1       1       6825    50      100     3333333333333333333333333       Kevin An
2       2       6812    50      100     3333333333333333333333333       maxymczech
3       3       6697    50      100     3333333333333333333333333       Yuval Golan
4       13      4646    36      74      3333333331313333--111311-       Oliver Wilms
5       14      4305    35      70      3333333333313133-1111--1-       Ivo ver eecke
  • UTC 2023-12-25 18:52:18
  • EST 2023-12-25 13:52:18  
Robert Cemper · Dec 21, 2023 go to post

A great initiative. A really surprising experience to see the echo of the community.
for those interested in details without personaö self-promotion.

Best wishes - especially HEALTH -- to everyone in the community
And special thanks to the excellent team running this community. 💐🌺🌹🌼🌻🌟

Robert Cemper · Dec 19, 2023 go to post

If you want to clear all old data you have to use  ..%DeleteExtent(..) that you inherit from %Persistent.

Changing from %Persistent  to %SerialObject is a compiler-related action.
The compiler doesn't take care of your storage.
In this case only the access methods change, but not the underlying storage and its content 

Robert Cemper · Dec 18, 2023 go to post 
there are command line utilities i Namespace %SYS down from ^DATABASE
%SYS>d ^DATABASE
 
 1) Create a database
 2) Edit a database
 3) List databases
 4) Delete a database
 5) Mount a database
 6) Dismount a database
 7) Compact globals in a database
 8) Show free space for a database
 9) Show details for a database
10) Recreate a database
11) Manage database encryption
12) Return unused space for a database
13) Compact free space in a database
14) Defragment globals in a database
 
Option?

in addition  Class SYS.Database  holds a long list of utility methods 
you have to dig into Class docu

Robert Cemper · Dec 15, 2023 go to post
  • PPG is a nice feature if your local data might break partition limits.
  • Without knowing details on the internals of %PARALLEL: 
    • It is given that it runs in more than a single process
    • but sharing PPG over multiple processes is not known
    • so a lot of data may accumulate in some of the parallel processes.
Robert Cemper · Dec 13, 2023 go to post

indeed the numbers sometimes overlap:
twoneight   became. 218  !!  that was really nasty 
only removing the first found char was the workaround

Robert Cemper · Dec 13, 2023 go to post

Try to check your code against the 2 test sets in my OEX package:  
sometimes there is a problem if the last line of input.txt is missing a line terminator.
try to keep always an empty line in the end.

Robert Cemper · Dec 13, 2023 go to post

Hi all,
The first half of the competition is over! 
To anticipate questions related to the ranking:
My sorting is  Stars > verified ObjectScript (ok%)  > Scores
After finish when 50 Stars + ok=100% are reached Scores defines the ranking.

Robert Cemper · Dec 12, 2023 go to post

You see now an extended ranking list.
Code Part OK signals the modules that have passed the function test against the Test Sets in OEX
1 => Part1 OK,  2 => Part2 OK, 3 => Part 1+2 are OK, - => nothing OK  the position indicates the day.
ok%  is the percentage of parts verified OK of the 100 parts in totals in the competition.

Robert Cemper · Dec 11, 2023 go to post

Ah, some improvements.
I personally always used UTC since the introduction of ENSEMBLE  (ages back)  

Robert Cemper · Dec 11, 2023 go to post

Your time zone is taken from your settings in the underlying operating system

$ZTZ shows the offset from UTC. You can set it to whatever you need.
but ATTENTION  this affects $H for the whole IRIS instance !!!
take a serious look into documentation on mostly not wanted the side effects

Robert Cemper · Dec 5, 2023 go to post

Similar to previous years I will provide the results of our private leaderboard 

  • It will sort by published ranking but separate DC members from "guests"
  • The matching of DC members is a manual task 
  • if I missed you pls. let me know your identity in AoC by DC mail  to add your DC flag
  • updates will always happen in this reply
    •  
  • DCrank  AOCrank Scores  Stars   ok%     ----- Code Parts OK -----       Name
0       ---     ----    ----    ---     ----*----*----*----*----*       --- DC Members ---
1       1       6825    50      100     3333333333333333333333333       Kevin An
2       2       6812    50      100     3333333333333333333333333       maxymczech
3       3       6697    50      100     3333333333333333333333333       Yuval Golan4       12      4868    39      0       -------------------------       Jaume Ferre
5       13      4646    36      74      3333333331313333--111311-       Oliver Wilms
6       14      4305    35      68      3333333333313133--111--1-       Ivo ver eecke
7       15      4138    34      0       -------------------------       Oskari Kosonen
8       17      3054    24      0       -------------------------       Keith Avery
9       29      1368    12      0       -------------------------       Dieter PAUL
10      30      1046    9       0       -------------------------       TylerFeldhege
11      36      415     4       0       -------------------------       Chris Marais
12      38      302     3       0       -------------------------       Daniel Aguilar
13      39      259     2       0       -------------------------       Muhammad Umar Waseem
14      40      114     1       0       -------------------------       rhodery
15      10      5504    44      0       -------------------------       isc-Junhee Lee
16      19      2326    19      0       -------------------------       isc-Chris Stewart
17      23      1820    15      0       -------------------------       isc-Rebecca Agustin
18      27      1541    12      0       -------------------------       isc-Ajinkya Sonawane
19      37      333     3       0       -------------------------       isc-bquirk
20      41      104     1       0       -------------------------       isc-Arwa A.
21      42      100     1       0       -------------------------       isc-Raj Singh22      ---     ----    ----    ---     -------------------------       --- unknow in DC ---
23      6       6476    50      100     3333333333333333333333333       Test Set1
24      7       6353    50      100     3333333333333333333333333       Test Set2
25      4       6604    50      0       -------------------------       Joaquin Derrac Rus
26      5       6573    50      0       -------------------------       Dominik Znidar
27      9       6062    50      0       -------------------------       Dang Quang Vi
28      8       6184    48      0       -------------------------       Jarjar 314
29      11      5139    42      0       -------------------------       Sloan Kanaski
30      16      3163    27      0       -------------------------       (anonymous user #3860190)
31      9       2491    21      0       -------------------------       Paul Langelaan
32      18      2353    19      0       -------------------------       Jesper Olsson
33      20      2145    18      0       -------------------------       Luke Schuurman
34      22      1947    17      0       -------------------------       Michael Cheng
35      21      2091    16      0       -------------------------       Gary Nguyen
36      24      1719    16      0       -------------------------       SubstantialProduct27
37      25      1661    14      0       -------------------------       hazamashoken
38      26      1619    13      0       -------------------------       nwattana
39      28      1422    12      0       -------------------------       Nahuel
40      31      1015    9       0       -------------------------       Geoffrey Lu
41      32      800     7       0       -------------------------       (anonymous user #214666)
42      23      697     6       0       -------------------------       j-dolenc
43      33      669     6       0       -------------------------       Dominique Dordain
44      34      482     4       0       -------------------------       LFY
45      35      476     4       0       -------------------------       Robert Trifan
  • UTC 2023-12-25 18:52:18
  • EST 2023-12-25 13:52:18

Ranking by completion

Robert Cemper · Nov 27, 2023 go to post
  • in the Java Contest, we are expected to use Java
  • in the Python Contest, we were expected to use Python
  • in the ObjectScript Contest, we were expected to use COS/ISOS
  • in a Node.js Contest, we would be expected to use Node.js

It was never a question of this could have been done differently
As I understand it, the important point is that IRIS has some role to play

Robert Cemper · Nov 24, 2023 go to post

I checked multiple namespaces. All look identical.

everywhere the same picture.
That %Zpy* is stored in IRISSYS.

BTW: the subscript mapping is identic to rMAC in IRIS and also in historic Caché. versions

Robert Cemper · Nov 22, 2023 go to post

I just learned here that "NAMED PIPE" is significantly different in

  • UNIX/Linux where it is just a kind of file structure and
  • Windows where it offers the duplex feature I was looking for

So my workaround (by accident) turns out to be better for my needs than the Linux FIFO feature
as I'm able also to read partial lines and don't need newlines or similar as separators.

it was kind of Lucky Punch

Robert Cemper · Nov 22, 2023 go to post

I also did some experiments using netcat in my container.
Using Ubuntu pipe files works somehow. But it was not convincing.
Ubuntu experts may do it better.