Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
chrispsn
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
31.
▲
by
chrispsn
6y ago
Is it a matter of writing a comprehensive stats library?
32.
▲
by
chrispsn
6y ago
Mesh can do this, somewhat - exceptions in table columns stick out like a sore thumb in the sheet source. http://mesh-spreadsheet.com
33.
▲
Ngn/K (WASM Port)
(ngn.bitbucket.io)
2 points
by
chrispsn
6y ago
|
0 comments
34.
▲
by
chrispsn
6y ago
Mesh Spreadsheet is explicitly designed to make it easier to view and write decision tables with a projectional editor, while keeping the code as text for storage, version control, etc. https://twitter.com/meshspreadsheet&#x
35.
▲
K Community Showcase
(twitter.com)
6 points
by
chrispsn
6y ago
|
0 comments
36.
▲
by
chrispsn
6y ago
`A 0: ("some";"lines";"are";"here"); / write to file A `B 0: ("more";"lines";"follow";"here"); / write to file B _/ 0:
37.
▲
by
chrispsn
6y ago
In k9 it should be: A_B
38.
▲
APL386 Unicode – An APL Font
(abrudz.github.io)
136 points
by
chrispsn
6y ago
|
65 comments
39.
▲
by
chrispsn
6y ago
I agree with most of this article, except that - for me - grouping by table columns is a more intuitive and flexible way to control subset application than 'rank'. k9 is in development, but blending k7 and k9 we'd get somethi
40.
▲
BQN: An APL Variant from Marshall Lochbaum
(mlochbaum.github.io)
60 points
by
chrispsn
6y ago
|
29 comments
41.
▲
by
chrispsn
6y ago
> you can name columns and use the name in formulas You can do that in Excel too: whether it's the whole column of a sheet, or a column of a table - syntax for latter is `someTable[someColumnName]`. Mesh will have the latter, albeit
42.
▲
by
chrispsn
6y ago
Thanks! I have been considering this! It might impact the 'flow' of modelling eg using automatic cell names like 'A1'. And it might complicate storing the sheet as text (might need to store more complex layout info than
43.
▲
by
chrispsn
6y ago
Yes, that's it.
44.
▲
by
chrispsn
6y ago
When you say 'has the functionality of a spreadsheet but looks nothing like current spreadsheets', what do you mean? I am working on Mesh Spreadsheet. It gives you a spreadsheet UI that writes code as text. It will likely use k9 a
45.
▲
by
chrispsn
6y ago
Yep. JavaScript can also work as a formula language (per the Mesh JS prototype), but APL family languages such as k are much more ergonomic - and 'punchy' - in a spreadsheet context.
46.
▲
High-performance Excel Tables using VBA
(gist.github.com)
2 points
by
chrispsn
6y ago
|
0 comments
47.
▲
K Tech Tree
(gist.github.com)
2 points
by
chrispsn
6y ago
|
0 comments
48.
▲
K Tech Tree
(gist.github.com)
2 points
by
chrispsn
6y ago
|
0 comments
49.
▲
by
chrispsn
6y ago
It's probably like k's find (`?`), which gets the indices of the found elements, or else the length of the list (or null, depending on the dialect) if not found: "abc"?"caz" 2 0 3
50.
▲
by
chrispsn
7y ago
Correction: I think the above can be a bit faster and shorter if we skip the dict, and just index into the keys. Compare: \t:100000 `freq@!s#>(s/!s*#v)!,/v%\.5+!s 941 \t:100000 `freq(s/!s*#v)s#>,/v%
51.
▲
by
chrispsn
7y ago
Yes. When each function is a single character [1], juxtaposition is enough to show the calling order - eliminating the need for brackets in many cases, and reducing syntactic noise. [1] There's a handful of two-character primitives, as
52.
▲
by
chrispsn
7y ago
Another approach to the 'highest averages' method, using a k9 dict: v: 10400 3400 6200 s: 15 quotients: ,/v%\.5+!s labels: s/!s*#v / list of 15x 0, 1, 2. arbitrary; could instead b
53.
▲
by
chrispsn
7y ago
kazinator provided examples in two recent k threads: https://news.ycombinator.com/item?id=22631649 https://news.ycombinator.com/item?id=22666539
54.
▲
TXR Lisp
(nongnu.org)
77 points
by
chrispsn
7y ago
|
9 comments
55.
▲
K Code Tweets
(twitter.com)
2 points
by
chrispsn
7y ago
|
0 comments
56.
▲
Dyalog '18: The Interpretive Advantage [video]
(youtube.com)
14 points
by
chrispsn
7y ago
|
2 comments
57.
▲
by
chrispsn
7y ago
The Shakti co-founder's previous tech was a very fast time series language+DB - this is his next iteration. https://tech.marksblogg.com/billion-nyc-taxi-kdb.html
58.
▲
by
chrispsn
7y ago
Shakti k (k9)! https://shakti.com/ How to install: https://www.youtube.com/watch?v=l19Ef9v2uVI
59.
▲
by
chrispsn
7y ago
Kind of - in Excel everything just has a location reference, even if you name it. So that means you can get collision errors if a dynamic array expands into another cell.
60.
▲
by
chrispsn
7y ago
Thanks! And hopefully the README helps too: https://github.com/chrispsn/mesh/blob/master/README.md
More ›