You are viewing archived messages.
Go here to search the history.

hamish todd 2024-04-08 10:57:20

I'm thinking about spreadsheets. Has anyone ever made a convincing interface for defining functions , using a spreadsheet interface?

(I am aware that you can define functions in most modern spreadsheets, but this requires you to go to a traditional coding interface. This is obviously cheating!)

Ionuț G. Stan 2024-04-08 13:20:54

I have come across this a few years back and found the idea intriguing, but never delved deep into it: web.engr.oregonstate.edu/~burnett/Reprints/icfp03.excelFunctions.pdf

Kartik Agaram 2024-04-08 14:46:15

I've always liked LoGlo's approach: loglo.app/2020-06-16

Rows share a stack, which allows naturally for defining a function across multiple cells.

William Taysom 2024-04-08 15:10:17

Loglo is like Forth and spreadsheets at the same time.

One thought is by default showing the formula (intension) and value (extension) of a cell at the same time.

Second thought is that we by default only allow one word (in the Forth sense) per cell.

Third thought. Should be able to hide/fold up intermediate cells.

Final thought. Then a definition is label for the formula used in some folded up cells. Using/copying the label doesn't relabel references like we're used to in spreadsheets, but also duplicates hidden/intermediate cells that we can unfold for viewing a trace.

Bonus. Treat formulas acting on multiple cells respectably.

Kartik Agaram 2024-04-08 15:33:30

I experimented with folding before:

In control flow: akkartik.name/post/2021-02-19-devlog

In function calls: archive.org/details/akkartik-2min-20201020

The spreadsheet angle is not very obvious here, but I was very much influenced by LoGlo (and Brief).

📝 2020-10-20: defining functions : Kartik Agaram : Free Download, Borrow, and Streaming : Internet Archive

A live-updating structured editor for a spreadsheet-inspired postfix language, built up from machine code, and intended to be taken apart.Main project page:...

hamish todd 2024-04-10 14:46:10

Thank you very much folks! I wish "SDF" didn't already mean something to me

Andreas S. 2024-04-13 09:07:51

Hi FoC Community 🙂 I'm looking for something that i found a couple of years ago and apparently my fuzzy descriptions fail my zettelkasten or a search engine for that matter. I think I'm looking for a clojure talk in which someone presented also a tool. This tool used a UI of 2 or Three circles as a kind of number REPL which explained for example how the map function works in clojure. I hope that isn'T too vague if you know the name of the tool, that would be very cool. Thank you!!

Oleksandr Kryvonos 2024-04-13 11:42:39
Andreas S. 2024-04-13 11:46:20

No it wasn’t maria

Oleksandr Kryvonos 2024-04-13 11:53:35

oh, ok, I was sure it was. because demo includes circles

Oleksandr Kryvonos 2024-04-13 11:53:47

but maybe another tool I have in mind

Oleksandr Kryvonos 2024-04-13 11:54:27
Oleksandr Kryvonos 2024-04-13 11:55:16

yeah should be it I hope

Oleksandr Kryvonos 2024-04-13 11:56:39

Знімок екрана 2024-04-13 о 13.56.00.png

Andreas S. 2024-04-13 11:59:14

YES!!!

Andreas S. 2024-04-13 11:59:21

thats the one I was loking for

Andreas S. 2024-04-13 11:59:31

thank you so much Oleksandr Kryvonos

Oleksandr Kryvonos 2024-04-13 12:04:46

welcome, alias for my search (in my brain) is “visual clojure == Vlojure” also it was on reddit in a /nosyntax sub-reddit

reddit.com/r/nosyntax/comments/pxwkjx/vlojure_a_new_way_to_write_clojurescript

Oleksandr Kryvonos 2024-04-13 12:07:51

also I was impressed/jealous that this tool was way more cooler than mine 🙂

Oleksandr Kryvonos 2024-04-13 12:10:54

@Ella Hoeppner - the author of this tool is here btw

Ivan Reese 2024-04-13 15:43:49

She also appears on this episode: futureofcoding.org/episodes/054

Ella Hoeppner 2024-04-13 21:42:53

glad to hear people are still interested in vlojure after so long! 😄

Ella Hoeppner 2024-04-13 21:48:30

fwiw I've been working lately on a replacement for vlojure, here's a sneak peak. This time it's built with rust and wgpu, so it'll be much more cross-platform. Here it's running as a native app on my mac, but will also be able to deploy for the web, and mobile shouldn't be too difficult either. Plus the UI is shaping up to be a lot smoother than the original vlojure, and performance doesn't drop once your program gets large (which was a big issue with the original vlojure). And this time I'm making it much more language-agnostic, such that it can be used with many different languages, rather than just clojure/script.

Ivan Reese 2024-04-13 21:57:52

That's super cool

Andreas S. 2024-04-14 18:49:19

I was talking to a friend who is going to be a computer science teacher, we talked about the Mindstorms book and the topic of LOGO/Lisp and clojure came up. After the talk I send him some notes from my Zettelkasten. I knew I remembered vlojure but couldn’t remember the name. And so I came here :) and we even might get and improved version 👍 😃

Dany 2024-04-14 12:34:59

I wrote a blog post about constant data in PL. Which is kind of curious in text based PL and a place where more visual approaches can really shine. medium.com/@bitteldany/where-does-constant-data-go-b650338b2ee9

📝 Where does constant data go?

All of the programming languages I know make an interesting distinction, between two groups of constants, depending on type.

Jarno Montonen 2024-04-14 13:00:05

We would need to execute the parsing during compilation, but as far as I know no programming language allows allocation during compile time execution.

You could just include the parsed data as a const byte array, which basically all compiled languages allow. The tradeoff is of course in increasing the size of the binary, having less control over when to pay the cost for loading the data into memory (and when to unload it), and increased stress on instruction cache. Anyway, this has been quite common as an optimization in game development.

Stefan Lesser 2024-04-14 13:25:45

You say you are using a “C-like language” for the examples, so I’m not sure what the string type of that language translates to. But in C the trouble with const is that you either point to a constant value, and the pointer can still change, or you declare a constant pointer to a variable, and you can’t change the pointer, but you can change the value. Both of these need to be held in a read/write segment and I assume that is probably why your example copies the string contents o the heap?

In C you can use double const to explicitly have a constant pointer to a constant value, but I have no idea how that plays out when you compile it and no means to try it right now. I wouldn’t be too surprised if that also does something unexpected, given that C compilers have a lot of wiggle room in terms of “implementation details” and “undefined behavior”.

Swift has an explicit StaticString type that is used for literals and enables all kinds of compiler optimizations and compile-time shenanigans, like macros that are type-checked proper Swift code run at compile-time.

Stefan Lesser 2024-04-14 13:38:06

There’s also an ~_*ExpressibleBy…Literal*_~ protocol, which I guess would enable you to implement your own types with their own custom binary representations that can be specified as literals in the code and read and converted at compile time while treated as constants. How useful that really is though, I’m not sure.

Dany 2024-04-14 14:29:21

@Jarno Montonen , that's what I'm doing in that example, or do you mean to include the binary byte stream as a const byte array? Then you'd need to escape all special characters and copy paste from a binary file? Or how would you go about it? That sounds like a dependency with extra steps.

Dany 2024-04-14 14:30:23

Stefan Lesser Should have said C syntax, sorry. With string I'm eyeing c++ std::string. It does a copy when constructed from const char. I assume swift would do the same. As far as I can tell StaticString is swifts way of doing const char. ExpressibleBy.. is syntactic sugar for constructors. What I want is StaticFont, StaticImage, StaticGraph ... 🙂

Jarno Montonen 2024-04-14 14:36:35

Yes, I meant the binary representation of the results of the parsing. It could be a prebuild step to do the parsing and write the prebaking code into a codefile. You wouldn't need to escape anything. It could just appear as initialization of a byte array in the source code.

Jarno Montonen 2024-04-14 14:45:41

The actual implementation would depend on a language, but essentially you'd then point a pointer of correct type to the beginning of the bytes. But you could also just have the prebaking step generate the actual source code that initializes the objects/structs that represent the parse results. So say you're reading in a json "root: { prop1: 23, prop2: "test" }. Your baking step would generate code "static readonly ROOT = new Root {Prop1 = 23, Prop2 = "test" }. I suppose it would depend on the language how much of this ends up being just loading the binary (on program startup) and how much is left to runtime.

Kartik Agaram 2024-04-14 16:07:33

I like the insight that declarative programming is entirely working with constants.

There are ways to convert constants to a representation that the computer can just copy from disk into RAM. It's not clear to me why we don't do that. It's non-trivial (e.g. making sure references to the same object don't serialize to two copies of it) but definitely not rocket science. Looking forward to seeing where you go with this.

Fredrik 2024-04-14 17:59:15

We would need to execute the parsing during compilation, but as far as I know no programming language allows allocation during compile time execution.

Did you look at Zig?

  • Call any function at compile-time.

ziglang.org

Fredrik 2024-04-14 18:07:35

Anyway, what code a compiler accepts in a compile-time context shouldn't be limiting you. There are many ways other ways to execute arbitrary code on compile-time. Traditionally you run a tool like Make (or a more modern option), which lets you run any program to process an input file and generate an output file that is used by the next tool. The tool can either generate a blob that you can include in your program to get untyped data, or a source file you can include to get typed data.

Rust has its own tool Cargo that runs the file 'build.rs' for this purpose, but it also allows procedural macros, that are libraries loaded by the compiler that can run arbitrary code.

Fredrik 2024-04-14 18:11:32

In conclusion, declarative programming is nothing other than defining constants in a text form.

Same goes for non-declarative languages. Think of Lisp.

Dany 2024-04-15 06:04:17

@Fredrik Thanks for bringing up zig, it has indeed nice comptime features. Looking into it now, it seems to allow allocation into the data segment and even reading a file. This is a good general solution. (I will add this to the blog post). Data structures like a graph that contains pointers to itself will need some extra work though.

Dany 2024-04-15 06:05:51

@Fredrik You kind of proof my point. Why is it so simple to define a constant integer, yet if I want for example a constant list of integers I have to go through all those extra steps you outlined.

Fredrik 2024-04-15 06:13:37

That's a good point. It personally bothers me a lot that Rust has five different features that do the same thing, with five different limitations. ( 1. generics, 2. const evaluation, 3. declarative macros, 4. procedural macros, 5. build scripts) I prefer to have one good way to do it, like in Zig.

Fredrik 2024-04-15 06:22:14

Data structures like a graph that contains pointers to itself will need some extra work though.

Looking at Rust, const data can contain references to const data as long as they are not circular. I don't really care though. I never put references in my const data, but instead put indexes that are relative to the base pointer of the const data. A reference is 8 bytes, so I don't want to have that in const data. An index is 1, 2 or 4 bytes depending on the size of the data. Sometimes I've even packed a 12-bit index and a 4-bit length in two bytes.

Dany 2024-04-15 06:31:50

@Fredrik Oh really? So (in rust) the pointers inside the data segment get relocated when the executable is loaded? How does the loader know whats data and whats pointers? The linker would need to add that to the relocation data?

I agree data structures with indices are the way to go. It is also easier to serialize, clone and you can (ideally) allocate everything in single block. You cannot however easily extend, join, reuse part of it.

Fredrik 2024-04-15 06:45:56

I suppose they get relocated. I made an example, but don't know how to make Compiler Explorer show the relocation table. Relocations would be another reason to prefer indexes, as the relocation table adds a number of extra bytes for each pointer, and also slows down loading of the executable, and also takes up memory for the relocated copy of the const data, as opposed mapping the memory directly to the executable file.

rust.godbolt.org/z/8YvfPr5G9

📝 Compiler Explorer - Rust (rustc 1.76.0)

#[derive(Clone, Copy)] pub struct LinkedList<'a, T> { next: Option<&'a Self>, value: T, }

const A: LinkedList<u32> = LinkedList { next: None, value: 42, };

const B1: LinkedList<u32> = LinkedList { next: Some(&A), value: 13, };

const B2: LinkedList<u32> = LinkedList { next: Some(&A), value: 0, };

#[no_mangle] fn peek() -> LinkedList<'static, u32> { B2 }

Dany 2024-04-15 07:23:37

Ok I'm confused. Does this create a linked list inside the data segment or.. 3 list segments and links them on startup. The assembly would suggest the first, but could also be the latter, sadly it doesn't show what's actually in the data.

Fredrik 2024-04-15 07:25:43

The three nodes are in the data segment. The disassembly shows that the function copies a node right out of the data segment without any further processing, showing that the pointer is already correct.

Fredrik 2024-04-15 07:35:56

On second thought, the disassembly of the function doesn't show that clearly enough, due to optimization. Let's instead return a reference to the node, so the constant data cannot be inlined. Now you can also see the relocation being there in the form of a label in the data in the assembly.

rust.godbolt.org/z/nYxh47def

📝 Compiler Explorer - Rust (rustc 1.76.0)

#[derive(Clone, Copy)] pub struct LinkedList<'a, T> { next: Option<&'a Self>, value: T, }

const A: LinkedList<u32> = LinkedList { next: None, value: 42, };

const B1: LinkedList<u32> = LinkedList { next: Some(&A), value: 13, };

const B2: LinkedList<u32> = LinkedList { next: Some(&A), value: 0, };

#[no_mangle] fn peek() -> &'static LinkedList<'static, u32> { &B1 }

Dany 2024-04-15 07:40:40

I see it know, even better if you return B2 and link to B1 inside B2.

Fredrik 2024-04-15 07:42:21

You can also do away with the function entirely and make the data show up in Compiler Explorer by declaring any entry points as pub static instead of const .

rust.godbolt.org/z/o9qc8d5Y4

📝 Compiler Explorer - Rust (rustc 1.76.0)

#[derive(Clone, Copy)] pub struct LinkedList<'a, T> { next: Option<&'a Self>, value: T, }

pub static A: LinkedList<u32> = LinkedList { next: None, value: 42, };

pub static B1: LinkedList<u32> = LinkedList { next: Some(&A), value: 13, };

pub static B2: LinkedList<u32> = LinkedList { next: Some(&A), value: 0, };

pub static C: &LinkedList<u32> = &B2;

Dany 2024-04-16 04:23:22

Thanks for all the feedback, I updated the blog post.. hopefully also making it more clear, what I actually want to see.

Fredrik 2024-04-16 07:16:46

Those are some interesting thoughts you have added. It seems like you want to see something like the Smalltalk system, where everything is an object, and you can use one tool to edit and object, such as a drawing or a document, and then reuse the same object in your programming. The Smalltalk system solved this by not having a compile-time, but instead doing all programming in a live system. When you want to deploy it on another machine, you save an image of the heap, and that's const data that you can run on another machine without doing any processing on startup. This is what Alan Kay calls real OOP . You can find videos of Alan Kay and Dan Ingalls demonstrating it.