I’m not a very organised person. I try to be, but it takes a lot of effort, and, being a programmer, I’m a naturally lazy sort of person. Whenever there’s a repetitive problem, I lean toward automating it in the most generally applicable way possible.

There are any number of tools for organising information, but they all tend to be either highly specific, such as a todo list, or very difficult to automatically organise and sort, such as a wiki. Ideally, I’d like a system that gives me the best of both worlds; the ability to restrict data to a specific form, but a form of my choosing. Essentially, I want a database.

However, most databases aren’t designed for quick, user-friendly, interactive use; that’s why we spend so much effort putting pretty frontends on them. Unfortunately, these facades often limit what we can do. Once we wrap our database in a GUI, we can no longer execute abitrary queries to pull out the data we want.

So what I really want is an interface that allows me to retain all the flexibility of the underlying database. In other words, I want a CLI, a REPL, an interactive prompt which I can use to query and build my database. And for this I need a query language that is both concise and succinct, something I can use to create queries in seconds, and something whose entire syntax can fit on the back of a postcard.