programming-2022 VS usql

The latest thing the system can do is run interactive 3d mathematical visualizations. Here are some physics examples: https://twitter.com/sritchie/status/1503220063264026629, with code living here: https://github.com/sritchie/programming-2022

- multiple stories about the same piece of code, but all with the ability to IMPORT the story as a library

I've been writing sicmutils[0] as a "literate library"; see the automatic differentiation implementation as an example[1].

A talk I gave yesterday at ELS demos a much more powerful host that uses Nextjournal's Clerk to power physics animations, TeX rendering etc, but all derived from a piece of Clojure source that you can pull in as a library, ignoring all of these presentation effects.

Code should perform itself, and it would be great if when people thought "LP" they imagined the full range of media through which that performance could happen.

[0] sicmutils: https://github.com/sicmutils/sicmutils

[1] autodiff namespace: https://github.com/sicmutils/sicmutils/blob/main/src/sicmuti...

[2] Talk code: https://github.com/sritchie/programming-2022

[3] Clerk: https://github.com/nextjournal/clerk

Yes, for these examples SICMUtils is handling the state updates and gives new coordinates to Mathbox to render.

The library works in both JS and the JVM, so I was able to generate an unevaluated code form for the equations of motion (simplified, optimized!), which clerk sends over the wire for the JS build of sicmutils to run.

Here is the code for that demo: https://github.com/sritchie/programming-2022/blob/main/src/p...

The api is settling, of course this is all quite playful! I will add instructions on how to get this building when I’m back at the keyboard.

Another way this will all get more powerful is via the in-progress https://github.com/ChristopherChudzicki/mathbox-react project. When that’s settled we can send a data structure representing a full scene across the wire, and build stuff like www.math3d.org , but with the full power of Clojure augmenting the UI equation editor. Dreamy stuff!

Also all languages has an query-builder / ORM so the benefit of something like PRQL is possibly not big enough to merit it as an additional dependency.

My suggestion:

Make PRQL a cli tool that can be used by allowing users to connect to a database in a similar fashion as something like usql (https://github.com/xo/usql),

take a look at: https://github.com/xo/usql

https://github.com/xo/usql has some good first issues

There's a new release of usql that adds even more autocomplete and fixes a bunch of issues: https://github.com/xo/usql/releases/tag/v0.11.0

I am not a big fan of the complex literate programming style involving code-generation which this article talks about.

But I recently discovered that Google's zx [1] scripting utility supports executing scripts in markdown documents and I combined it with httpie [2] and usql [3] for a bit of quick and dirty automation testing and api verification code and it worked out pretty well.

[1] https://github.com/google/zx#markdown-scripts

[2] https://github.com/httpie/httpie

[3] https://github.com/xo/usql