@Adám Beautiful! O.o No wonder he always has on-point advice. I would love to pick his brain.

@Adám Duh 🤦 Thanks.

@Adám Okay. Cool. I'll stuff that in my back pocket.

@PaulMansour Okay, cool. That's akin to an SQL DB in the range of 10GB or so, assuming small-ish records?

Do you have a blog or similar? I'd love to learn more about special gotchas and primitive performance characteristics related to large datasources.

Okay, initial task for Sunday morning: Figure out a decent empty-array-friendly way to insert 0 after all the 1s in a boolean mask.

something like {(⍵,n⍴0)[⍋⍵,⍥(+\)1⍴⍨n←+/⍵]}

oh, how about 1∘+≠\⍤/⊢

@rak1507 Noice!

/ seems slowish so maybe there's something better, but I doubt anything's beating that for simplicity

@PaulMansour Actually these are the winning Cash 5 lottery numbers, for each day :-D

@cube.head good luck finding a pattern :p

@B.Wilson toolofthought.com

@Adám :D

Found a natural expression that uses all "compose-like" operators together: ⍸∘⌽⍤⍷⍥⌽. Arguably would be better as (⍸⍷⍢⌽) :D

@B.Wilson Record size is less important when dealing with inverted databases. Small columns are good, large number of columns is OK.

@B.Wilson Nice! Now find one that also needs ⍛

@user314639 Hi M Shure, if you want to participate here, please email access@apl.chat