Previous: , Up: Top  


18 Conculsion

I expect you are surprised by the performance possible by k9 and the fact that it all fits into a 134,152 bytes! (For comparison the ls program weighs in 51,888 bytes and can’t even change directory.)

If you’re frustrated by the syntax or terse errors, then you’re not alone. I’d expect most had the same problems, persevered, and finally came away a power user able to squeeze information from data faster than previously imagined.

If you’ve come along enough to get it, then you’ll probably realised this manual isn’t needed and it’s all here...

The built-in reference screen containing all the k9 commands.

universal database and language - beauty and performance.

select [count first last min max sum avg ..]A by B from T where C
delete from T where C               *update A by B from T where C
x,y      / union, insert, upsert, outerjoin, leftjoin, asofjoin ..
x+y      / equi and asof outer joins: combine markets through time
x#y x_y  / take/drop, intersect/except, inner join

Verb                      Adverb               Noun              System
:    x         y          f/  over  c/  join   bool 011b         \l a.k
+    flip      plus       f\  scan  c\  split  int  0N 0 2 3     \t:n x
-    negate    minus      f'  each  v'  has    flt  0n 0 2 3.4   \u:n x
*    first     times      f': eachp v': bin    char " ab"        \v
%              divide     f/: eachr ([n;]f)/:  name ``ab         \w
&    where     min/and    f\: eachl ([n;]f)\:  uuid              \cd x
|    reverse   max/or                         
<    asc       less                     .z.DTV date 2024.01.01T12:34:56
>    dsc       more                     .z.dtv time  12:34:56.123456789
=    group     equal      I/O                     
~    not       match      0:  r/w line         Class             \f
!    enum      key        1:  r/w char         List (2;3.4;`a)   \ft x
,    enlist    cat       *2:  r/w data         Dict `i`f!(2;3.4) \fl x
^    sort   [f]cut       *3:  kipc set         Func {[a;b]a+b}   \fc x
#    count  [f]take      *4:  http get         Expr :a+b
_    floor  [f]drop
$    string    cast+      
?    unique+   find+      $[b;x;y] if else     t:[[]i:2 3;f:3 4.;s:`a`b]
@    type   [f]at         @[x;i;f[;y]] amend   utable [[b:..]a:..]
.    value  [f]dot        .[x;i;f[;y]] dmend   xtable `..![[]a:..]
math: sqrt sqr exp log sin cos div mod bar ..  util: in bin within ..
\\   exit      / comment  #[if do while]

`csv?`csv t    / read/write csv
`json?`json t  / read/write json
python: import k;  k.k('+',2,3)   
nodejs: require('k').k('+',2,3)

*ffi: "./a.so"5:`f!"ii" /I f(I i){return 2+i;}       //cblas ..
*c/k: "./b.so"5:`f!1    /K f(K x){return ki(2+xi);}  //feeds ..
*enterprise: multi user/thread/core/machine. no limit. fast.
connect to all - depend on none

Previous: , Up: Top