krazykringle

Consider ‘sc’ - dates from 1981, still actively maintained.

https://github.com/n-t-roff/sc (active fork)

https://en.wikipedia.org/wiki/Sc_(spreadsheet_calculator)

https://manpages.ubuntu.com/manpages/resolute/en/man1/sc-im....

Installable on mac and unix as ‘sc-im’

Does it run a Linux? Will I be able to ssh to it?

Plumbum (above) matches this need in Python. It overloads | to make pipes! It makes it relatively trivial to express shell idioms in Python.

Zerotier (mentioned below) is perfect for this!

To expand a little bit: it provides an (almost) zero-configuration way to set up a private 'layer 2' network that you can connect your home server to, and any other machines that you want to be able to connect to it or to each other. It handles NAT traversal completely transparently.

In practice, it means that if I have a (say) NFS server connected to a Zerotier network I control, I can connect to it transparently from anywhere from another machine on that network, no matter what NATs / firewalls either machine is behind, even if they change. Perfect for phones, roving laptops, etc. I've gone to a model where I do most of my development (over mosh/tmux) on my home machine, from wherever I happen to be.

No home firewall configuration needed at all.

Does it need to suck the entire database into memory to answer a query?

JSON-patch might also serve: http://tools.ietf.org/html/rfc6902

Here's a Python implementation: https://github.com/stefankoegl/python-json-patch

Also: http://archive.org/details/tv

From the site: 1L7LgaRtr3WSw5g1MaJQWj19T6RByssz41