New post
AllAccepted answers
Robert Cemper · May 28, 2020

¡ Hola Salva ! ( @Jose Tomas Salvador)  

You motivated me to give it a try.
And  with a little bit of tweaking the scripts my contribution for the contest 
WebSocket Client JS with IRIS Native API as Docker Micro Server  
is also running with no issues on Docker Desktop for Windows !
A very positive experience that I didn't expect at first sight.
¡ Gracias !

Robert Cemper · May 26, 2020

Typically all strings are UTF encoded.
The average text often consist of  single-byte characters  (a subset of UTF-8)   
As soon as a multibyte character joins the string the whole string just uses WIDE characters

example:

USER>set txt="cher ami j'ai besoin de 100 eur"
USER>zw txt
txt="cher ami j'ai besoin de 100 eur"
 
USER>zzdump txt
0000: 63 68 65 72 20 61 6D 69 20 6A 27 61 69 20 62 65         cher ami j'ai be
0010: 73 6F 69 6E 20 64 65 20 31 30 30 20 65 75 72            soin de 100 eur

USER>set txt="cher ami j'ai besoin de 100 €"
USER>zw txt
txt="cher ami j'ai besoin de 100 €"
 
USER>zzdump txt
0000: 0063 0068 0065 0072 0020 0061 006D 0069                 cher ami
0008: 0020 006A 0027 0061 0069 0020 0062 0065                  j'ai be
0010: 0073 006F 0069 006E 0020 0064 0065 0020                 soin de
0018: 0031 0030 0030 0020 20AC                                100 €
 

The conversion happens totally internal.
depending on your needs you can select the national language table.
different languages sort differently.   e.g German äöü vs. aou 
 

Robert Cemper · May 24, 2020

@Eduard Lebedyuk  , @Dmitry Maslennikov 
I tried it and it works:   - v $(pwd):/mnt/share/

I set it for both containers and they read/write to it as any other user would do.

My consequence: 

  • the "Install container" fills all required data
  • the "production container" consumes it.  It's similar as data transfer from 1 process to the other over IRISTEMP  

and I have no need for a merge as in my initial case. 

Robert Cemper · May 24, 2020

Thank you @Dmitry Maslennikov !
That confirms that I didn't miss a "magic merge feature".
My way wasn't that complete (I stripped the context example)  
Ending up with base to work with.  So I "just" have to elaborate my Dockefile.

My NodeJS has to start after IRIS anyhow, so iris-main could be great:
But to visualize that it isn't just a fake it ist should run -it what iris runs -d detached.
An additional manual start is no problem.

@Eduard Lebedyuk  you inspired me to try the shared volume  yes

I keep you posted
 

Robert Cemper · May 24, 2020

¡Hola Salva! ( @Jose-Tomas Salvador) 

A great contribution. Having this experienced myself I know how much work it was.
A few remarks: 

  • enabling Hyper-V killed my well-grown VMware environment
  • my attempts to install a pure Ubuntu Server distibution failed with various releases.   so I had to accept the pre-selected kits with the graphic interface.
  • the effort to get the network clean in a multi-machine environment was significant   and I had just a week feeling what action were expected from me.
  • finally mapping external volumes for durability wasn't easy and not successful.

Thanks to your description I know that my expectations were just higher than reality.

I finally dropped Docker desktop and returned to my VMware that I used already
before it was supported platform for Caché, wink .  
Especially networking was much easier (to me). 

Maybe a future version might be more convincing.
But as I developed a predecessor of VMware already in 1972.. I'm quite demanding on that subject.  

¡ Saludos desde Viena !
Robert

Robert Cemper · May 21, 2020

Your organization seems to run the traditional centralized approach where a few developers worked
in a rather close contact with each other being informed of any change immediately.
Experiencing all cross-over dependencies on code and data directly.

In a distributed / larger organization this information is poor or missing.
So with more people stirring the same pot of code from remote is a risky exercise.
You are well-advised to have local and separated installations for your developers.

The extra effort is to maintain a common code base  and data set for them.
The advantage is that their changes don't interfere with each other.
The next challenge is to keep test data for them consistent.
This may even be harder to achieve than code consistency and requires  precise maintenance and management.
 

Robert Cemper · May 20, 2020

As there is no default RANDOM() in Caché/IRIS SQL you have to write it yourself.
Create this class:

Class User.Henry
{ ClassMethod Random(maxval As %Integer = 2) As %Integer [ SqlName = RANDOM, SqlProc ]
{
 quit $random(maxval)
} }

Assuming your table has defautl ID (%Integer, MINVAL=1)

SELECT TOP 1  column FROM table
HAVING ID >= RANDOM(MAX(ID))

>= ensures that you just get an existing ID and don't drop on a deleted one

Of course, if you know in advance the highest existing ID   (e.g. maxid)  then RANDOM(maxid)  will do it.

Robert Cemper · May 20, 2020

Extending the reply of  @Vitaliy.Serdtsev 
Basically whatever your variable holds could be a %String  (also including binary values)
COS has a few check functions to interpret the content 

Further on the Pattern Match operator ?  let you sort out pure text and binary, .....

All you have is just content. It is left up to you to decide what type it is.
You can find out by those functions what is NOT.

Only the data type classes decide to some limit what type it should be.