A little SQL goes a long way

5th January 2021 at 8:28am

http://okmij.org/ftp/papers/DreamOSPaper.html by Oleg Kiselyov

If the OS was represented as a big database, it would be a lot easier to interact with it. For example, if I want a list of files with specific tags:

> select * from files where .tags contain ["music", "creative", "tool"]

Right now there is no easy way to do this kind of search. You might have to do something like:

> find / -opt1 "something" -opt2 "somethingElse"

Or worse, you might have to code your own program to do it.

This is extremely unnatural (and slow) compare to SQL.

Related to

Backlinks: Building a Design System Workbench by CHRISTOPH LABACHER, Datasette by Simon Willison, Nushell, UNIX Philosophy